Category: Webinars

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

A Better Way to Read Execution Plans Part 1

Added by 4 years ago

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

An Introduction to SQL Server and Containers

Added by 10 months ago

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

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

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.

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.

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.

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.

How Azure is enhancing the Microsoft data platform – Part 1

Added by 10 months ago

1.82K Views0 Comments

SQL Server specialist Gavin Payne discusses how the Microsoft Azure cloud platform has become an integral part of what’s now a very broad and deep Microsoft data platform. He begins by identifying the platform’s different cloud services and how they relate to traditional SQL Server services. Gavin then suggests how these cloud services can then be used with existing on-premises data platforms to create hybrid solutions – something that’s becoming popular with businesses of all sizes.

How Azure is enhancing the Microsoft data platform – Part 2

Added by 10 months ago

1.50K Views0 Comments

SQL Server specialist Gavin Payne discusses how the Microsoft Azure cloud platform has become an integral part of what’s now a very broad and deep Microsoft data platform. He begins by identifying the platform’s diffe...

Indexing Insights in SQL Server

Added by 1 year ago

1.55K Views0 Comments

Indexing is a stab in the dark sometimes. Usage patterns in applications may be different than we expect when making choices for indexing and what we as DBAs think are good indexing decisions may work against us...

Query Progress Tracking in SQL Server

Added by 1 year ago

2.87K Views0 Comments

It's 18:00 o'clock on Friday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. You sta...

Red Flag Radar: Assessing the Technical Quality of ISV Apps Running on SQL Server

Added by 9 months ago

1.24K Views0 Comments

This video takes you through a variety of checks against a third-party application that runs against a SQL Server database, from medical practice management systems, warehouse inventory systems, to laboratory informat...

Page 1 of 3123