Sessions & Content

Search
Content Type
Conference
Tags
(Almost) all about Azure Arc - in 20 Minutes Ben Weissman (he/him)
Join me on a journey through the different offerings in Azure Arc and how they can benefit you as a data professional!
2 Fast 2 Furious - designing for speed, concurrency, and correctness (20 min edition) Mark Broadbent
Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
3 things you don’t want to store in a database (but sometimes have to) Gianluca Sartori
Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.
Apache NiFi 101: Introduction and Best Practices Timothy Spann
Using open source apache nifi to integrate and ingest data at scale
Azure Arc-enabled SQL MI – More than just another kind of SQL Server Ben Weissman (he/him)
Join us, as we explore the capabilities of Azure Arc-enabled SQL Managed Instances.
Azure DevOps trio Kevin Chant
Welcome to Azure DevOps trio, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for Data Platform deployments.
The video is not available to view online.
Azure SQL Database - A true story journey from migration, through synchronization and beyond. Pieter Vanhove
You will be challenged with a case study to design a solution using Azure SQL Database capabilities. At the end of this session, you will better understand the possibilities to migrate on-premises databases to Azure SQL Database. You will learn how to synchronize data across different environments and get more insights on how to troubleshoot issues in Azure SQL Database. This is a hands-on, open discussions and team work kind of session (not a traditional slideshow).
The video is not available to view online.
Database Projects 101 in ADS Warwick Rudd
Database Projects 101 in ADS is an introductory session on how to incorporate Database Projects in Azure Data Studio into a Data Professionals toolkit.
Database Reliability Engineering - the new DBA? Hamish Watson
A session for DBAs considering where their career needs to go.
Dba toolset - Getting things done when the pressure is on martin croft
DBA/Developer Toolset to get you out of that hole and save you some time
Dealing with Bad Networks - The Availability Conundrum Allan Hirt
Are you trying to increase uptime locally or for disaster recovery but your network is terrible? Join the club. This session will discuss different techniques, their pros and cons, as well as considerations for availability when your network is flaky at best.
Deep Inside Azure SQL High Availability Joey D'Antoni
Want to have a deep dive into how SQL Server and Azure SQL service maintain high availablity? This is your session.
Different dimensions of monitoring and tuning performance for Azure SQL Surbhi Pokharna
Azure SQL performance capabilities, how to configure and maintain your Azure SQL for higher performance. We will explore various monitoring tools and pick few scenarios for deeper troubleshooting. In this demo centric session, we will tune our database and find an optimal ground to manage cost. We will generate Power BI powered database score card for trend analysis.
Embedding SQL security practices in your pipelines Stuart Moore
Automate checking your database security model
Enterprise Row Level Security in SQL Server and Power BI Jamey Johnston
Learn how to and why you should protect your data with Row Level Security in SQL Server and Power BI.
Erin & Monica’s Favorite SQL Stuff Monica Rathbun
Two consultants, two different companies, two data professionals passionate about performance tuning. Do we like the same things? Do we have the same approach to problems? Topics will include: Trace Flags, DMVs, DBCC commands, Community Scripts and Intelligent Query Processing Features. We will talk about the features and solutions we agree on, and discuss where we disagree.
Field Testing Ola Hallengren’s Maintenance Solution Joe Pollock
Learn how to best configure and use Ola's Maintenance Solution, based on years of experience using this on thousands of SQL Server instances.
Github and Azure DevOps Duet - SQLBits edition Kevin Chant
A tale about how a development team and an operations team must bond together and figure out how to use GitHub and Azure DevOps together for Data Platform deployments.
Here’s the execution plan … now what? Hugo Kornelis
You know where to find an execution plan. You have taken your first steps reading them. But how are you going to apply this knowlledge to real world problems?
Hunting for fraud with Benford's law in R Thomas Hütter
In this lightning talk I'll demonstrate how to apply the R implementation of Benford's law (which actually is not about crime or fraud) to identify possibly fraudulent invoice or other data.
The video is not available to view online.
<<123>>