Search
Content Type
Conference
Tags
Join me on a journey through the different offerings in Azure Arc and how they can benefit you as a data professional!
Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
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.
Want to have a deep dive into how SQL Server and Azure SQL service maintain high availablity? This is your session.
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.
Learn how to and why you should protect your data with Row Level Security in SQL Server and Power BI.
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.
Improve the quality of your T-SQL code with the free tool ScriptDom
Only the curious will learn and only the resolute overcome the obstacles to learning.
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.
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?
Learn how enhancements to the SQL Server optimizer improve performance without code changes.
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
In this session, you will learn where data lives in a computer system, and the key performance metrics used to understand the health and performance of your storage subsystem.
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.
Quickly and easily migrate databases and associated logins using dbatools.
Even in a cloud provider or virtualized, you still need to worry about the infrastructure supporting SQL Server. This session will cover what that means in the modern world.
I often recommend that folks proactively manage statistics, but I always seem to run out of time to talk about HOW to do that...this session will cover exactly that.
Introduction of areas for partitioning for Beginners
Learn what's new in Microsoft Defender for Cloud for data store
<<12>>