In preparation for my PASS Summit 2018 presentation on Friday, here is an updated version of the SQL Server JOIN Types poster Try our JOIN Types Course: Comes Complete with: • Easy to understand lectures with examples • Assignments • …
It is interesting, when working with many different clients, the questions about installing Windows Updates and SQL Server updates comes up and often the discussion leads to the pros versus cons of each. The need to apply updates and the …
Latest Service Packs – To Install or Not to Install? Read more »
If you are going to PASS Summit 2018, please come and see my Exploring SQL Server JOIN Types presentation on Friday afternoon. Check out our SQL Server JOIN Types Course Comes Complete with: • Easy to understand lectures with examples …
Today I have the opportunity to release Database Health monitor version 2.6.5. It has been just a few weeks since the August release, but I did have a chance to build in a few new features shown below. Version 2.6.5 …
Database Health Monitor September Release Now Available Read more »
One of the common CheckDB errors that I see is the Message 824, level 24. This is something that I regularly work to repair for customers with great success. DBCC results for ‘YourDatabaseName’. CHECKDB found 0 allocation errors and …
Occasionally you may want to run DBCC CheckDB against all of the databases on your SQL Server. Hopefully you have a job to run checkdB regularly, but in case you just want to check to confirm that you have no …
Quick script to run DBCC CheckDB for all of your databases Read more »
This week I completed another successful corruption repair. Here is what the client had to say when the database was repaired: Stedman Solutions were no less than amazing! We were in a major bind; we had corruption in a …
My presentation is on the Exploring SQL Server Join Types – INNER, OUTER, and Much More More details…
If you frequently connect to many different SQL Server as I do, you are probably used to the Server Manager loading slowly when you log in with Remote Desktop. The Server Manager has a bad reputation for taking up lots …
Today was the announcement of the 2018 PASS Summit Community Speakers, and I am fortunate enough to have been included on that list for the 4th year in a row. This conference will be in Seattle in November. Here is …