4.12K Views3 Comments0 Likes
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.
2.87K Views2 Comments0 Likes
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.
16.33K Views2 Comments0 Likes
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.
4.12K Views2 Comments0 Likes
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.
4.50K Views1 Comments0 Likes
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...
10.64K Views1 Comments0 Likes
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 ...
2.43K Views0 Comments0 Likes
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.
2.34K Views0 Comments0 Likes
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.
1.90K Views0 Comments0 Likes
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...
3.84K Views0 Comments0 Likes
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...
2.95K Views0 Comments0 Likes
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.
1.51K Views0 Comments0 Likes
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.