Sessions & Content

Search
Content Type
Conference
Tags
Introduction to Perf Troubleshooting Using Wait Statistics Paul Randal
Learn what wait statistics are and how to use them to identify performance bottlenecks.
Behind the Query Store… Kalen Delaney
Look inside Query Store to see what it does and how it works
DAX for the SQL developer Alexander Arvidsson
Learning DAX can be tricky, especially if you have a background in SQL.
The video is not available to view online.
DAX Gotchas Chris Woolderink
The FILTER function does not create a new filter context but a row context. The ROW function is executed in a filter context without creating a row context. To demystify this and all the other DAX Gotchas that I bumped into is the goal of my session.
Deeper Integration and New Transformation for SSIS in ADF Sandy Winarko
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
Lets go deep in SQL Server Unit Testing with Visual Studio Geovanny Hernandez
Everyone that has been involved in Software Development can notice how huge the impact of a bug can be, and Databases are not the exception. In this session, you will learn how to test your SQL Server projects using Visual Studio and SQLUnitTesting.
The video is not available to view online.
Lightning Talks Various Speakers
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
The video is not available to view online.
PowerShell Medley Jonathan Allen
A stream of handy tips, tricks, and ideas to boost your PowerShell skills and productivity.
Slack for the DBA Stuart Moore
Slack, Bots, ChatOps? Is any of this useful to a DBA? Yes, come and let me show you how!
The video is not available to view online.
Understanding Gremlin and Azure Cosmos DBs Graph API for SQL Professionals Dave Lusty
Azure Cosmos DB has many use-cases, and not all of them are clear to Azure Cosmos DB newcomers. If you're a relational expert and have been wondering about graph, how you'd survive without a schema, and scale out databases this session can help.
Data Science For The DBA - Get Started Now Manohar Punna
If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will show you an end-to-end Data Science project covering the core technologies in Microsoft Data + AI stack.
DAX Best Practices Marco Russo
Best bractices in DAX formulas from real world experience.
Introduction to Graph Processing with SQL Server 2017 Markus Ehrenmüller-Jensen
Hierarchies and graphs are the bread and butter of most business applications. SQL Server 2017 comes now with a different approach: Graph Database. You will learn best practices, have fun and will leave with handy scripts.
Parallel Database Maintenance with 24/7 Systems and Huge DBs Grzegorz Łyp
Session deals with the database maintenance problems (like defragmentation) in situation of 24/7 system. As we walk through the basic maintenance we keep in mind that our database is big and it takes a lot of time to do the proper maintenance.
Performance Monitoring Using Extended Events, DMVs & Query S Ola Hallengren
Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.
Revenge: The SQL! Rob Volk
Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.
The video is not available to view online.
Row Level Security-A real world example Bjørn D. Jensen
Row Level Security based on related tables
Simplifying XEvents Management with dbatools Chrissy LeMaire
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools
Tame Your Unruly Data...With Constraints! Rob Volk
Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.
Temporal Data in SQL Server Dejan Sarka
Use temporal support in SQL Server and add what is missing out of the box.
<<1234567>>