Tag: sql server

Sort: Date | Title | Views | Comments Sort Descending

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

Added by 3 years ago

4.17K 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 1

Added by 3 years ago

4.22K 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! – Panel Discussion – Part 2

Added by 3 years ago

2.92K 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 Administrative Mistakes on SQL Server

Added by 4 years ago

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

Strategies and Best Practices for Virtualizing SQL Server

Added by 2 years ago

3.88K Views0 Comments

Join our panel of industry experts for a deep dive into monitoring VMware and Hyper-V environments running SQL Server. The panel includes David Klee (@kleegeek), Kevin Kline (@kekline), and Jason Hall (@sqlsaurus) for a discussion covering issues like what are the important performance metrics to monitor, how to maintain peak performance, and ways that SQL Sentry Performance Advisor take all the pain out of maintaining and monitoring your VM estate for peak performance.

End-To-End Troubleshooting on Microsoft SQL Server

Added by 3 years ago

6.19K 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

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

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

Added by 1 year ago

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

Getting Started With Execution Plans

Added by 3 years ago

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

Who Wants To Be A DBA? Roles & Responsibilities

Added by 2 years ago

4.35K Views0 Comments

In this video, Kevin Kline and John Martin discuss the roles and responsibilities of a DBA. They look at the interpersonal issues and answer questions who do I need to satisfy and what’s really expected. They also look at what technical skills you need to succeed as a DBA.

How Azure is enhancing the Microsoft data platform – Part 1

Added by 1 year ago

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

Columnstore Indexes Improvements in SQL Server 2016 with Niko Neugebauer

Added by 2 years ago

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

Page 1 of 3123