Becoming a Query Performance Troubleshooting Expert
Every DBA wants to become an expert in query performance troubleshooting. Not every DBA is willing to put in the time and effort it takes to become an expert.
SQL Server Performance
Killing the “SQL Server is a Memory Hog” Myth
At least once a week I read or hear the familiar refrain, “SQL Server is a memory hog,” or “SQL Server uses all the memory.”
Book Review: VMware vSphere 6.5 Host Resources Deep Dive
My friend David Klee recommended that I add the book VMware vSphere 6.5 Host Resources Deep Dive to my bookshelf.
The Future For Database Transaction Units
It was just over three years ago that Microsoft introduced the concept of Database Transaction Units (DTUs). To those of us familiar with SQL Server and SQL Database we all had one question: what the hell is a DTU?
Upgrading to SQL Server 2016: Post-upgrade tasks
After upgrading to SQL Server 2016 is complete you will need to perform a series of tasks to verify that database is ready to be handed over to the end users for further testing. This post will provide you a checklist of items to review after the upgrade is complete.
Upgrading to SQL Server 2016: Upgrade tasks
Let’s look at the steps involved in upgrading to SQL Server 2016.
