How HyperBac worked for me
I recently installed HyperBac on a clients SQL Server to reduce the amount of space needed to store their backups. Specifically we were looking to reduce the amount of space the log backups took, but I was curious to see how much space the full backups would be reduced by. The full backups were ~53 […]
What does WITH (NOLOCK) actually mean
Contrary to popular belief WITH (NOLOCK) isn’t actually the SQL Server “Turbo” button. While it may appear that way, there’s actually some stuff going on in the back that makes it look this way. Understanding what is happening is critical to using WITH (NOLOCK) correctly. When you use the NOLOCK query hint you are telling […]
SQL Server Consolidation at #SQLExcursions
The fifth and final session that I’ll be presenting at SQL Excursions is on SQL Server Consolidation. There are lots of ways to consolidate SQL Server databases, and some times the wrong method of consolidation is selected by people. Knowing all of the options when working on a SQL Server Consolidation project is key to […]
Take a virtual motorcycle ride around Ketchikan, AK
A few weeks ago I went on SQL Cruise with Kris (my wife) and a bunch of other SQL geeks. When the ship was stopped in Ketchikan, Alaska while a bunch of people were going in the water (crazy right?) I hopped on the back of a Harley and went riding through town as part […]