Pluralsight Free Weekend: September 6-8, 2019

Pluralsight’s entire course library is FREE for everyone this weekend, from Friday, September 6 at 10:00AM MT to Sunday, September 8th at 11:59PM MT! SQLskills has 63 courses available on Pluralsight. If you don’t have a Pluralsight subscription, this is something you should take advantage of.

BTW, my latest course, Azure SQL Database: Diagnosing Performance Issues with DMVs has just gone live.


You can sign up for this here.

Here are links to all of our Pluralsight courses, by author.

Paul Randal (8 courses)

Kimberly Tripp (5 courses)

Jonathan Kehayias (10 courses)

Glenn Berry (16 courses)

Erin Stellato (8 courses)

Tim Radney (3 courses)

Joe Sack (13 courses)

Joe was formerly at SQLskills, before he went back to Microsoft.

New Pluralsight Course Published

On January 10, 2019, Pluralsight published my latest course, SQL Server 2017: Diagnosing Performance Issues with DMVs. This makes fifteen courses that I have done for Pluralsight. Here is the official course description:

Learn how to easily query SQL Server 2017 for performance information to help identify and fix issues that can affect performance and stability. This course is applicable to anyone responsible for SQL Server 2017 and earlier versions.

Essentially, I walk you though the activity and performance-related queries from my SQL Server 2017 Diagnostic Queries. I do this by discussing and demonstrating each query and talking about how to interpret the results of each query. Knowing how to understand what each diagnostic query reveals is extremely useful as you are trying to determine what is going on with your SQL Server instance or database.

This course is a companion to my earlier SQL Server 2017: Diagnosing Configuration Issues with DMVs course that Pluralsight published on July 19, 2018.

Despite the title, this course is still applicable for older versions of SQL Server. This is because many of the queries that I demonstrate and discuss will work on older versions of SQL Server. Ideally, you should be using the correct version of my SQL Server Diagnostic Queries that matches your version of SQL Server so that all of the queries will work. Regardless of that, the core concepts are still relevant for older versions of SQL Server.

You can see all of my Pluralsight courses here.

Upgrading to SQL Server 2016

Many organizations are running older and possibly out of support versions of SQL Server, running on older versions of Windows Server, on old, slower, out of warranty hardware and storage.

SQL Server 2005 fell out of extended support on April 12, 2016. SQL Server 2008 and SQL Server 2008 R2 fell out of mainstream support on July 8, 2014, while SQL Server 2012 fell out of mainstream support on July 11, 2017. SQL Server 2012 Service Pack 4 is due to be released in September, so you should be planning on testing and deploying that when it becomes available.

Besides being out of support, these old versions of SQL Server are missing many very useful new features that can benefit your organization, and make your life as a DBA much easier. In my experience, you need to take the lead, and push your organization to start upgrading, making the business and technical case to justify the effort. I have done a lot of work and research to help you with this undertaking.

My latest Pluralsight course, SQL Server: Upgrading and Migrating to SQL Server 2016 has just been published. This is my eleventh course for Pluralsight, but the complete list of my courses is here. Speaking of Pluralsight courses, the team at SQLskills has 52 courses that we have developed and published. The complete list, along with guidance about what courses you should take depending on your interests and job role are here.

Building on this online course is a new three day class, IEUpgrade: Immersion Event on Upgrading SQL Server, taught by myself and Tim Radney. The first round of this course will be taught in Chicago from October 11-13, 2017.

In August, I will be doing a daily blog series about upgrading to SQL Server 2016/2017. Finally, I will be presenting a half-day session called Migrating to SQL Server 2017 at the PASS Summit 2017 in Seattle, WA from October 31- November 3, 2017.