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.

More Courses from SQLskills on Pluralsight!

Late this afternoon, two more SQLskills authored courses went live on Pluralsight. The first one is from me, which is SQL Server 2012: Installation and Configuration, while the second one is from my colleague Joe Sack, who authored SQL Server: Troubleshooting Query Plan Quality Issues . With these two courses being available, that makes 13 out of 24 total SQL Server related courses from SQLskills on Pluralsight.  We plan on adding many more during 2013.

If you have not watched a Pluralsight course, I really urge you to give them a try. They pick top authors, and enforce strict quality standards, so you get a great product.

Here is a list of all of the latest releases from the Pluralsight catalog.