14.65K Views6 Comments0 Likes
Have you ever wondered who is the World’s Fastest DBA? Well now you have a chance! Watch as the SQL Sentry Racing Team takes to the Charlotte Motor Speedway to find out who is truly the World’s Fastest DBA.
4.18K 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.
4.23K 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.
2.93K 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.67K 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.
10.87K 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 ...
4.63K 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...
7.22K Views1 Comments0 Likes
SQL Sentry has moved into a new office! Only a few team members had access to the office before the grand unveiling on Friday, December 6th. Check out the reactions when everyone sees the new space for the first time....
3.47K Views1 Comments0 Likes
Event Manager’s advanced chaining features enable you to quickly and easily define dependencies and workflows involving SQL Agent jobs, Windows Tasks and/or Oracle jobs. The video takes look at what you can do ...
3.28K Views1 Comments0 Likes
Aaron Bertrand explains what the SP_ prefix is and discusses the performance issues with using it when you call a stored procedure. He also mentions a blog post he wrote about the SP_ prefix, which can be found at SQLPerformance.com/sp_prefix.
3.20K Views1 Comments0 Likes
Aaron Bertrand and Kevin Kline discuss some of the advantages for specifying the schema when creating, altering and referencing objects. They discuss how specifying a schema can affect performance and how important it is for security. They also use demos to illustrate the importance.
5.23K Views0 Comments0 Likes
In this video, Lori Edwards gives a demo on the tools offered by SQL Sentry that are focused on helping you with SQL Server.