Category: Webinars

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

Columnstore Indexes Improvements in SQL Server 2016 with Niko Neugebauer

Added by 1 year ago

3.37K Views0 Comments

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

Exploring SQL Server’s Plan Cache

Added by 2 years ago

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

Convince Me! – Persuasion Techniques that Get Things Done

Added by 2 years ago

2.00K Views0 Comments

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

Top 10 DBA Mistakes: Horror Stories! – Panel Discussion – Part 4

Added by 2 years ago

2.73K Views0 Comments

In Top 10 DBA Mistakes: Horror Stories! – Panel Discussion – Part 4, Kevin Kline, Aaron Bertrand, Jes Borland, David Klee, Grant Fritchey and Tim Ford briefly touch on indexing strategy and why it is important. They continue to tell their own horror stories for backups and recoveries and some of the things you can do to avoid having your own horror stories.

Top 10 DBA Mistakes: Horror Stories! – Panel Discussion – Part 3

Added by 2 years ago

2.23K Views0 Comments

In Part 3 of Top 10 DBA Mistakes: Horror Stories! - Panel Discussion, the panel talks about how human error is something that is inevitable and tell more horror stories from their own experiences. They stress how it is always important to prepare for these types of mistakes so you can recover faster when they occur.

Top 10 DBA Mistakes: Horror Stories! – Panel Discussion – Part 2

Added by 2 years ago

2.67K Views2 Comments

In Part 2 of the panel session on DBA Horror Stories, Kevin, Jes, David, Grant, Aaron and Tim talk about how the development of technology doesn’t get rid of the DBA, but forces a shift in jobs for the DBA.

Top 10 DBA Mistakes: Horror Stories! – Panel Discussion – Part 1

Added by 2 years ago

3.85K Views3 Comments

In the Top 10 DBA Mistakes: Horror Stories - Panel Discussion, SQL Server MVPs and SQL Cruise Technical Leads, Kevin Kline, Jes Borland, David Klee, Grant Fritchey, Tim Ford and Aaron Bertrand discuss how they learned the most from their experience as DBAs when things went horribly wrong and why it is extremely important to always be knowledgeable about your systems.

Top 10 DBA Mistakes: Horror Stories! – Part 3

Added by 2 years ago

2.57K Views0 Comments

In Part 3 of the series, SQL Server MVPs Aaron Bertrand and SurveyMonkey’s Argenis Fernandez join Kevin Kline. In this video, Kevin, Aaron and Argenis discuss another common DBA Mistake, inadequate preventative maintenance.

Top 10 DBA Mistakes: Horror Stories! – Part 2

Added by 2 years ago

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

Top 10 DBA Mistakes: Horror Stories! – Part 1

Added by 2 years ago

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

Getting Started With Execution Plans

Added by 2 years ago

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

End-To-End Troubleshooting on Microsoft SQL Server

Added by 3 years ago

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

Page 2 of 3123