Yesterday Pluralsight published my new course, “SQL Server 2012: Nonclustered Columnstore Indexes”. The intent behind this course was to provide a fast ramp-up on the aspects of this feature that you should consider when looking at whether or not this is a viable option for your SQL Server relational data warehouse workloads. The course covers [...]
Joe Sack
SQL Server Performance Tuning, High Availability and Disaster Recovery Blog
New Course: “SQL Server 2012: Nonclustered Columnstore Indexes”
Posted on: May 9, 2013 8:25 am
New Course: “SQL Server: Query Plan Analysis”
Posted on: March 29, 2013 7:06 am
Yesterday Pluralsight published my new course, SQL Server: Query Plan Analysis. The short description is as follows: “Learn how to interpret and analyze SQL Server query plans, making performance problems easier to recognize and understand, applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards.” As of today, that makes [...]
SQLIntersection: Unashamed Database Engine Coverage
Posted on: February 27, 2013 7:04 am
On the week of April 8th, in the MGM Grand in Las Vegas, I’ll be delivering a few sessions at the SQLIntersection conference along with some pretty incredible company, including: Aaron Bertrand, Sr. Consultant, SQL Sentry, Inc. [blog | twitter] Andrew J. Kelly, Mentor, SolidQ [blog | twitter] Bob Ward, Principal Architect Escalation Engineer, Microsoft [...]
SQL Server Event Schedule for H1 2013
Posted on: January 31, 2013 4:36 am
I’ve had a couple of months at home, focusing on consulting engagements, and now I’m about to enter back in to conference / Immersion Event season. I’ll still be consulting, but half of the time I’ll be doing it from a hotel room. While it is nice to interact with people via email, phone and [...]
New Course: “SQL Server: Troubleshooting Query Plan Quality Issues”
Posted on: January 11, 2013 5:14 pm
My latest online course, “SQL Server: Troubleshooting Query Plan Quality Issues” was published today by Pluralsight. The short description is as follows… “Learn how to identify, diagnose, and prevent problems where SQL Server chooses the incorrect query plan for your critical queries, applicable to developers, DBAs, and anyone responsible for SQL Server, from SQL Server 2005 onwards.” This 2 [...]
New Course: “SQL Server: Common Performance Issue Patterns”
Posted on: November 21, 2012 11:43 pm
My latest course, “SQL Server: Common Performance Issue Patterns“ was just published by Pluralsight.com. The course description is as follows: “There are a wealth of problems that can affect the performance of SQL Server workloads, and Joe shows you more than 35 common performance issue patterns. With 17 detailed demos, you’re shown how to recognize each [...]
New Course: SQL Server: Transact-SQL Basic Data Modification
Posted on: September 18, 2012 5:16 am
As Paul recently announced, the entire SQLskills team will be rolling out SQL Server content across several subjects on Pluralsight.com. My latest course, “SQL Server: Transact-SQL Basic Data Modification”, which is the companion to “SQL Server: Transact-SQL Basic Data Retrieval”, was just published today by Pluralsight.com. The course description is as follows: “If you need [...]
New course: “SQL Server: Transact-SQL Basic Data Retrieval”
Posted on: August 1, 2012 3:07 am
Today I learned that the video course I’ve been working on these last two months has been published on Pluralsight: SQL Server: Transact-SQL Basic Data Retrieval The general description from Pluralsight of this course is as follows: “If you need to retrieve data from a SQL Server database then you need to know how to [...]
Four reasons why I’m looking forward to #SQLSat104
Posted on: December 11, 2011 11:58 am
Next month I’ll be attending and speaking at the Colorado Springs #SQLSat104. I’m looking forward to this event for a number of reasons: 1. It’s my very first SQLSaturday! I’ve always wanted to attend – but neglected to do anything about it until now. 2. The day is packed with great session choices. While I [...]
