Sessions & Content

Search
Content Type
Conference
Tags
Behind the Query Store… Kalen Delaney
Look inside Query Store to see what it does and how it works
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.
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.
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.
Enhancements that will make your SQL engine roar #1 Pedro Lopes
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
The video is not available to view online.
Enhancements that will make your SQL engine roar #2 Pedro Lopes
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
The video is not available to view online.
Locking and Blocking Kalen Delaney
Locking and blocking is SQL Server’s default method of managing concurrency in a multi-user environment. In this session we’ll look at the three main aspects of locking, including when locks cause blocking and also examine ways to minimize blocking.
The video is not available to view online.
Recovery Models Made SIMPLE Kalen Delaney
This session looks inside the transaction log to see exactly what is logged for minimally logged operations in each of the recovery models. We also look at other factors in our SQL Server operations that affect what is actually written to the log.
The video is not available to view online.
The Query Store and Query Tuning in SQL Server vNext Grant Fritchey
SQL Server 2016 introduces the Query Store. The Query Store will change how you tune queries. Come to this session to learn everything you'll need.
The video is not available to view online.
SQL CLR Demystified Matt Whitfield
A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.
Building Your T-SQL Tool Kit: Window Function Fundamentals Christina E. Leo
Sets are king when it comes to SQL Server, but sometimes you need to see data row by row. Window Functions help you get the best of both worlds. Learn when and where these functions can help you get what you need without compromising performance.
Dive into the Query Optimizer-Undocumented Insight Benjamin Nevarez
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization.
Inside Ola Hallengrens Maintenance Solution Ola Hallengren
In this session I will talk about backup, integrity check, and index and statistics maintenance, and how you can use my maintenance solution (http://ola.hallengren.com) in an enterprise environment.
Latches, Spinlocks, and Lock Free Data Structures Klaus Aschenbrenner
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
The dangerous beauty of Bookmark Lookups Klaus Aschenbrenner
Join me in this session to get a basic understanding of Bookmark Lookups, and why they can be dangerous in SQL Server.
Things You Can Find in the Plan Cache Matan Yungman
The plan cache is one of SQL Server's fundamental components. Getting to know it can take you a few steps ahead in optimizing your system. In this session we will demonstrate ways the Plan Cache can help us identify performance problems.
T-SQL : Bad Habits & Best Practices Aaron Bertrand
Come to this session to learn how bad habits develop, the problems they lead to, and how you can avoid them.
T-SQL Tips and Tricks Itzik Ben-Gan
The purpose of this session is to have some fun with T-SQL and to learn practical tips and tricks that will help you improve and optimize your solutions.
Understanding Parameter Sniffing Benjamin Nevarez
This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well.
Data loading at warp speeds Ami Levin
Do you struggle to reduce those frustrating long hours it takes to load data? Are your time windows for loading becoming too short for comfort? If so – you simply can’t afford to miss this session…
<<123>>