Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
The video is not available to view online.
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.
The video is not available to view online.
I will show you demos for how to implement each layer of defense. This way, if one layer is breached, you aren’t left defenseless. We will start at the outer layer with network access. Next, we will cover the authentication and authorization using Azure RBAC. Finally, we will protect the innermost layer with Data At Rest and Data In Transit encryption. Once these protections are in place, we’ll see how to monitor Azure SQL security ecosystem for intrusions with Advanced threat protection.
The video is not available to view online.
Understand the automatic performance changes in Azure SQL and SQL Server
The video is not available to view online.
This data governance session guides you through the organization processes, policies and roles that are required for a successful data governance adoption. In addition to demos showing the possibilities of Azure Purview (the MS data governance service), we will share about experiences from our data governance workshops and adoption projects with our customers.
The video is not available to view online.
Database Projects 101 in ADS is an introductory session on how to incorporate Database Projects in Azure Data Studio into a Data Professionals toolkit.
The video is not available to view online.
DBA/Developer Toolset to get you out of that hole and save you some time
The video is not available to view online.
Session covering table distributions, partitioning , RSC and materialised views.
The video is not available to view online.
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.
The video is not available to view online.
How you can improve performance by splitting up large operations in chunks
The video is not available to view online.
Learn how to and why you should protect your data with Row Level Security in SQL Server and Power BI.
The video is not available to view online.
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.
The video is not available to view online.
Learn how to best configure and use Ola's Maintenance Solution, based on years of experience using this on thousands of SQL Server instances.
The video is not available to view online.
What do index rebuilds and defrags really do?
The video is not available to view online.
Only the curious will learn and only the resolute overcome the obstacles to learning.
The video is not available to view online.
How to write stored procedures that have a high likelihood of performing well and are easy to troubleshoot.
The video is not available to view online.
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?
The video is not available to view online.
In this Session MVP Frank Geisler and first time speaker Timur Dudhasch will give an introduction to Bicep for the Cloud DBA. As more and more systems are migrated to the cloud and as the sheer number of systems rises continuously Frank and Timur will demonstrate how to ease the process of creating and maintaining resources in the cloud via bicep
The video is not available to view online.
Hybrid Transactional Analytical Processing solve the age old problem of integrating operational processes with analytical capabilities within a single system. Find out what they're and how they deliver value
The video is not available to view online.
Dynamic SQL is great, until it is used to hack your site. In this session we demonstrate how using the T-SQL "Execute AS" command can limit what can be run using dynamic SQL.
The video is not available to view online.
<<12345>>