New course: Consolidation Tactics and Best Practices

Tim’s first ever Pluralsight course has been published – SQL Server: Consolidation Tactics and Best Practices – and is just over two hours long. It consolidates (ha!) all of Tim’s knowledge and experience from managing major consolidation projects over the years, as well as client experience from the SQLskills team. The modules are: Introduction General Considerations Consolidation Candidates Large Single […]

New course: Replacing Profiler with Extended Events

Erin’s new course is called SQL Server: Replacing Profiler with Extended Events and is just under 2.5 hours long. It’s based on her very popular user group/conference session and will help you move painlessly from using Profiler to using Extended Events – as Extended Events are the only way to monitor all features added in SQL Server 2012 […]

New course: Scaling SQL Server 2012 and 2014: Part 2

Glenn’s new course is called SQL Server: Scaling SQL Server 2012 and 2014: Part 2 and is just under 3 hours long. It covers a plethora of configuration and hardware issues that can prevent a workload from scaling, plus methods for scaling up and out and new features in 2014 that can help. Part 1 of the course (here) […]

New course: Understanding and Using DBCC Commands

Erin’s new course is called SQL Server: Understanding and Using DBCC Commands and is just over 2.25 hours long. It covers all the documented DBCC commands and a few of the undocumented ones, plus Erin goes into details about how to use DMVs, when available, to provide more detailed information. The modules are: Introduction Basic Commands Informational Commands […]

New course: Building Simple Asynchronous Applications

My first post of the year is about our first Pluralsight course of the year! Jonathan’s new course is called SQL Server: Building Simple Asynchronous Applications and is just over 1.5 hours long. It’s the first in a series of courses that Jonathan’s doing this year about using Service Broker, based on the extensive work he’s done with some […]

New course: Index Fragmentation Internals, Analysis, and Solutions

My latest Pluralsight course has been published! It’s called SQL Server: Index Fragmentation Internals, Analysis, and Solutions and is just over 2.5 hours long. The modules are: Introduction Index Structure and Index Uses Types of Index Fragmentation Causes of Index Fragmentation Detecting Index Fragmentation Avoiding Index Fragmentation Removing Index Fragmentation Check it out here. We now […]

New course: part 2 of Kimberly’s Optimizing Stored Procedure Performance

Kimberly’s latest Pluralsight course is live! This is part 2 of her very popular course: SQL Server: Optimizing Stored Procedure Performance. The course is more than 3 hours long and has the following modules: Introduction Session Settings Session Settings (section 2) Special Considerations Troubleshooting Techniques Check it out here. We now have more than 130 hours […]

New SQLskills Pluralsight courses

We’ve released a couple of new Pluralsight courses recently: The first is the conclusion of Glenn’s DMVs course series, SQL Server 2014 DMV Diagnostic Queries – Part 3, based on the very popular set of DMV queries he publishes every month. The second course is Jonathan’s long-awaited SQL Server: Change Data Capture course. The short abstract is: Learn […]

New SQLskills Pluralsight courses

We’ve just released two new courses on Pluralsight: The first new course is the conclusion of Joe Sack’s query-tuning course: SQL Server: Common Query Tuning Problems and Solutions – Part 2. The second new course is Kimberly’s long-awaited SQL Server: Optimizing Stored Procedure Performance. It’s more than seven hours long and the abstract is: When using stored […]

New SQLskills Pluralsight courses

We’ve just released a new course on Pluralsight, and there were a couple of other courses released earlier this year that you may have missed. The new course is Joe Sack’s SQL Server: Common Query Tuning Problems and Solutions – Part 1. It’s almost three hours long and the abstract is: There are a wide […]

Send me your wait stats and get my advice and 30 days of free Pluralsight in return

[Edit: 3/25/14 No more codes left – thanks for all the data! – please don’t send any more.] Yes, you read that correctly. Call me crazy, but I’ve been wanting to do this for a while. Here’s the deal: You run the code from this post that creates a 24-hour snapshot of the wait stats […]

New course on Optimizing Ad Hoc Statement Performance

Kimberly’s second Pluralsight online training course has just gone live and is available for watching! Her course is SQL Server: Optimizing Ad Hoc Statement Performance and is a mammoth 7.5 hours long and full of extensive demos. The modules are: Introduction (21 mins) Statement Execution Methods (90 mins) Estimates and Selectivity (98 mins) Statement Caching […]

Two new courses on Advanced Corruption Recovery Techniques and Maintenance Plans

I’ve just heard from our good friends at Pluralsight that our two latest online training courses are now live and available for watching! My latest course is SQL Server: Advanced Corruption Recovery Techniques which follows on from my earlier SQL Server: Detecting and Recovering from Database Corruption course. The course is 4 hours long and has […]

New online course: Why Physical Database Design Matters

Kimberly’s first Pluralsight online training course went live today: SQL Server: Why Physical Database Design Matters It’s 4 hours long and is the first in a multi-part series on performance. The modules in this course are: Introduction Data Types and Row Size Data Types and Index Size Data Types and Query Performance You can get to […]

New online course: Detecting and Correcting Database Corruption

My latest Pluralsight online training course went live today: SQL Server: Detecting and Correcting Database Corruption It’s 4 hours long and is the first in a two-part series, with a more advanced course coming in a few weeks. The modules in this course are: Introduction Causes of Database Corruption Detecting Page Corruption Consistency Checking DBCC […]

New online course on communication skills

My latest online training course was published by Pluralsight on Friday: Communications: How to Talk, Write, Present, and Get Ahead! The course is 2.5 hours long and draws on my extensive experience communicating and mentoring people on how to communicate more effectively. It’s aimed at everyone who needs to communicate, no matter which industry they […]

Free 24-hour pass for Pluralsight online courses

Those nice folks at Pluralsight are offering everyone on the planet a free 24-hour pass to check out all their online courses (more than 400 of them), including all of the ones we’ve recorded. There are no strings attached and no credit-card registration required – they’re just celebrating raising a whopping $27.5 million in investment […]

New 7.5 hour online course on logging, recovery, and the transaction log

As you know we're recording a lot of content for Pluralsight, and they've just published my latest course today: SQL Server: Logging, Recovery, and the Transaction Log. This is a carefully structured, 7.5 hour brain dump of everything I know about logging and recovery, which will be useful whether you're a beginner, a seasoned DBA, or […]

SQLskills training goes online worldwide (and free in September!)

We can make SQL Server scale really well, but we can't scale ourselves. Although our Immersion Events are extremely popular, and in high demand, we can't spend all year traveling and teaching, and we can't come to everyone's favorite location, so we have to limit the number that we can do. Our 2013 public training […]