4.82K Views0 Comments0 Likes
Kevin goes over how to do basic query tuning. Then he dives into 3 real world query tuning examples that are taken from Answers.SQLPerformance.com. The examples are SSMS vs. Plan Explorer, Massive MERGE, and the Case of the Log Shipping Mystery.
3.09K Views0 Comments0 Likes
Aaron Bertrand goes over how to generate Ad-Hoc Sets efficiently. He shows examples of how to generate them using recursive CTEs, system tables and number tables and shows which way has the best performance.
5.83K Views0 Comments0 Likes
This video is part of the Getting Started Series found on the SQL Sentry client software start page. These videos are intended to give you a basic understanding of some of the features of the product. This video will ...
3.26K Views0 Comments0 Likes
This segment is a follow-up from a previous video titled Graphical Chaining. In this video, you will learn how to restart a chain from any node in case a chain fails, or be alerted on chain conditions like fail...
1.66K Views0 Comments0 Likes
In this session, we’ll explore the technical foundation of containers and the emerging uses of containers with SQL Server. While containers are old hat on Linux, and the only way to reproduce the behavior of multiple instances on a single machine, the offer a variety of benefits on Windows too. For example, they are extremely fast to create, invoke, and run - and they licensed differently. We'll also show how the WinDocks solution compares to Microsoft’s, and of course other technical benefits offered by containers.
38.97K Views0 Comments0 Likes
In this video, renowned query tuning expert and Microsoft Data Platform MVP Aaron Bertrand looks at the brand new release of SQL Sentry Plan Explorer, the industry's most popular free query tuning tool.
3.89K Views0 Comments0 Likes
The SQL Sentry BI Suite provides a performance monitoring solution for the entire Microsoft BI platform by combining SQL Sentry Event Manager, Performance Advisor for SQL Server and Performance Advisor for Analysis Services.
4.06K Views0 Comments0 Likes
In this session, Niko Neugebauer looks at the columnstore indexes and discusses how they've improved in SQL Server 2016. About the speaker: Niko Neugebauer works as a BI Consultant for OH22, which creates int...
3.71K Views0 Comments0 Likes
Aaron Bertrand discusses one of his favorite topics, comma-delimited parameters. He shows the different ways you can split strings and which ways are the best.
2.28K Views0 Comments0 Likes
In this webinar, SQL Server MVP Kevin Kline talks about the importance of being able to persuade people as an IT professional.
4.11K Views0 Comments0 Likes
In this video, Scott Fallen, one of our Sales Engineers, looks at one of our newest features, custom conditions. He starts out by discussing how custom conditions work and how it’s different from anything available in other alerting systems. He also shows some example conditions, which are available in our starter custom condition package.
6.21K Views0 Comments0 Likes
In this video, SQL Server MVP Kevin Kline discusses how to go about troubleshooting and performance tuning your Microsoft SQL Server without any paid professional tools. He goes through his methodology for troubleshooting, which he has learned over the course of many years of trial and error.