Kevin / Added Videos

Sort: Date | Title | Views | Comments Sort Ascending
View:

Ad-Hoc Sets

Added by 5 years ago

3.43K Views0 Comments

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.

Add Target

Added by 2 years ago

6.62K Views0 Comments

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 ...

An Introduction to SQL Server and Containers

Added by 2 years ago

1.97K Views0 Comments

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.

Become a Query Tuning Master with the Newest Release of SQL Sentry Plan Explorer

Added by 2 years ago

42.80K Views0 Comments

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.

Comma Delimited Parameters

Added by 5 years ago

4.01K Views0 Comments

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.

Convince Me! – Persuasion Techniques that Get Things Done

Added by 3 years ago

2.52K Views0 Comments

In this webinar, SQL Server MVP Kevin Kline talks about the importance of being able to persuade people as an IT professional.

Custom Conditions

Added by 3 years ago

4.43K Views0 Comments

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.

End-To-End Troubleshooting on Microsoft SQL Server

Added by 4 years ago

6.67K Views0 Comments

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.

Event Manager Overview

Added by 7 years ago

4.19K Views0 Comments

This video provides a brief overview of some of the features and functions of Event Manager, including the all devices global calendar view. It also goes a little more in depth in talking about what Event Manag...

Execution Plan Self-Destruct

Added by 5 years ago

2.63K Views0 Comments

Kevin Kline discusses how SQL Server wants to reuse execution plans but there are issues that can cause execution plans to never be reused. He also shares some examples of how to fix these issues which will help improve SQL Server performance.

Exploring SQL Server’s Plan Cache

Added by 3 years ago

2.53K Views0 Comments

SQL Server’s plan cache is one of the largest regions of memory and is used to store SQL and T-SQL code for quick execution. It is largely self-maintaining and self-tuning. However, the kind of code you write and the way you invoke that code can have an enormous impact on how the plan cache is maintained, tuned, and optimized.

Fragmentation Manager Overview

Added by 7 years ago

5.19K Views0 Comments

SQL Sentry Fragmentation Manager introduces new automated index maintenance capabilities to Performance Advisor. In the video, Steve Wright discusses how Fragmentation Manager improves the manageability and vis...

Page 1 of 612345...Last »