Category: Webinars

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

SQL Server Query Tuning Best Practices – Part 1

Added by 4 years ago

9.65K Views1 Comments

SQL Server MVPs Aaron Bertrand and Kevin Kline begin their series on query tuning best practices. They go over some tips and tricks for writing queries. First, Kevin spends a little time on how to approach your ...

SQL Server Query Tuning Best Practices – Part 2

Added by 4 years ago

4.03K Views1 Comments

SQL Server MVPs Aaron Bertrand and Kevin Kline continue their series on query tuning best practices. Kevin starts by talking about what you should include in test harnesses for testing your SQL code and how to i...

SQL Server Query Tuning Best Practices – Part 3

Added by 4 years ago

2.46K Views0 Comments

SQL Server MVPs Aaron Bertrand and Kevin Kline continue their series on query tuning best practices. They discuss how to build a Transact-SQL test harness to provide stability and predictability to your code. Th...

SQL Server Query Tuning Best Practices – Part 4

Added by 4 years ago

2.38K Views0 Comments

SQL Server MVPs Aaron Bertrand and Kevin Kline continue talking about query tuning best practices. In this video, they continue to discuss more patterns and anti-patterns. Aaron starts out by going over why you ...

SQL Server Query Tuning Best Practices – Part 5

Added by 4 years ago

3.47K Views0 Comments

SQL Server MVPs Aaron Bertrand and Kevin Kline continue their series on query tuning best practices. In the webinar, they continue to discuss some additional patterns, things that do well and make your SQL code...

SQL Server Query Tuning Best Practices – Part 6

Added by 4 years ago

3.03K Views0 Comments

SQL Server MVPs Aaron Bertrand and Kevin Kline conclude their series on query tuning best practices. In this webinar, they cover four different topics, in regard to patterns and anti-patterns, which they see al...

A Better Way to Read Execution Plans Part 1

Added by 3 years ago

4.24K Views0 Comments

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.

Top 10 Administrative Mistakes on SQL Server

Added by 3 years ago

15.34K Views2 Comments

SQL Server MVP Kevin Kline discusses the top 10 administrative mistakes that DBAs make on Microsoft SQL Server. He discusses how most of the mistakes are due to process and business issues instead of issues with technology.

End-To-End Troubleshooting on Microsoft SQL Server

Added by 3 years ago

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

Getting Started With Execution Plans

Added by 2 years ago

7.25K Views0 Comments

In this video, Scott Fallen shares tips on how to get started with execution plans. He discusses what an execution plan is and why they are important. He also walks through a couple of sample plans.

Top 10 DBA Mistakes: Horror Stories! – Part 1

Added by 2 years ago

3.73K Views2 Comments

In Part 1 of the DBA Mistakes series, SQL Server MVPs Aaron Bertrand and SurveyMonkey’s Argenis Fernandez join Kevin Kline. They discuss disk subsystems and why it’s important to think about not only the amount of disk space but also the IO throughput. They also discuss the importance of testing and benchmarking for your disks.

Top 10 DBA Mistakes: Horror Stories! – Part 2

Added by 2 years ago

2.74K Views0 Comments

In Part 2 of the series, SQL Server MVPs Aaron Bertrand and SurveyMonkey’s Argenis Fernandez join Kevin Kline. They transition from discussing disk subsystems to discussing the issues with accepting SQL Server’s installation defaults. They begin by explaining why you need to set the size of a database when you build it and the issues with not managing virtual log files (VLFs) correctly. They also explain why you should not stick with the default power plan.

Page 1 of 3123