Sessions & Content

Search
Content Type
Conference
Tags
10 Productivity tools in 20 minutes Rob Sewell
You are busy, we are busy, everyone is busy. These are the tools that two busy consultants use to improve their productivity. We want to tell you about the tools that we use; that maximise our time, simplify our life, reduce our key strokes and generally make us appear more amazing. So that you can use them too. We have 20 minutes, so we wont go into much detail but we have some good quick stories to tell.
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.
Applying a Security Mindset to Lockdown Azure SQL Database Surbhi Pokharna
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.
Automagic Tuning in SQL Server Joey D'Antoni
Understand the automatic performance changes in Azure SQL and SQL Server
Data Governance with Azure Purview - Theory, Customer Insights and Demos Bernhard Engleder
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.
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.
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
Dedicated SQL Pools : How some stuff 'really' works Mark Pryce-Maher
Session covering table distributions, partitioning , RSC and materialised views.
Developer Enhancements in SQL Server 2022 Kendal Van Dyke
SQL Server 2022's latest developer enhancements from the Product Group.
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.
Don't Bite Off More than You Can Chew - Take it in Chunks Erland Sommarskog
How you can improve performance by splitting up large operations in chunks
The video is not available to view online.
Ensuring visibility across the modern database landscape Arun Kannan
Join us for the session where we discuss the best approaches to database monitoring including how organizations can better collaborate to isolate issues & optimize experiences by centralizing and correlating metrics across your entire database stack.
The video is not available to view online.
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.
Fragmentation Explained in 20 Minutes Brent Ozar
What do index rebuilds and defrags really do?
From Housekeeping to Data Engineer - My journey to find my passion Jean Joseph
Only the curious will learn and only the resolute overcome the obstacles to learning.
Fundamentals of Stored Procedures Brent Ozar
How to write stored procedures that have a high likelihood of performing well and are easy to troubleshoot.
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?
<<123>>