Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little bit of diving into the internals to figure out what is happening or even why it is complex.
When you need to figure out how indexes are contributing to the overall size of a table within a database, this script will help you!
Extended Events continue to grow and improve – even with the removal of a few events.
Announcing…the book At long last the wait is over. After much blood, sweat and more blood and sweat, the next edition of the SQL Server Recipes book is finished. This edition brings several changes and […]
Bringing years of experience together in two all day workshop sessions.
What is that default setting? SQL server does a fantastic job of having numerous settings at the server level and at the database level predefined for you. Additionally, the OS has a bunch of settings […]
Quick run the other way! PASS Summit will never be the same! Why? Well, because for the first time in the history of me, I have been selected to speak at such a prestigious event. Isn’t […]
One of my pet-peeves (and consequently frequent topic of discussion) is finding database settings (or any setting that has changed) without knowing about it. Worse yet is finding that the change has occurred and nobody […]
Dan “L” Greenland (1935 ~ 2015) Dan “L” Greenland, 80, passed away June 30, 2015. Born June 3, 1935 in Highland, Utah, to William John and Cressie Althera Loveridge Greenland. He grew up in Highland and attended […]
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see what else has been made available […]