It is a common misconception that you need real production data, or production like data, to effectively tune queries in SQL Server. I am going to explain how you can compile the same execution plans as what your production environment…
Availability groups can no longer be considered new. The feature was released in SQL Server 2012 but I often notice that SQL Server Failover Cluster Instances (FCIs) are much better understood. For a very long time, when people thought about…
You have decided to migrate our on-premise SQL Server database into Azure SQL Database. How do you do that? The first thought that comes to mind is a simple backup from on-premise and restore to Azure SQL Database. Unfortunately, that…
I have begun writing a few blog posts focused on launching your databases into the cloud. Specifically targeted on database migration methodologies. Choosing a migration method involves making a lot of decisions up-front. This post will assume that Managed Relational…
I appreciate everyone’s patience with SQLHammer.com. It is encouraging that you are reading this instead of seeing a Cloudflare error message, a site that does not load images and has a bad SSL certificate, or my maintenance page. Over the last…
This month’s T-SQL Tuesday is being hosted by James Anderson (b | t). T-SQL Tuesday (#TSQL2sDAY) is a blog party founded by Adam Machanic (b | t). Each month a member of the community hosts the party and selects a…
I love Redgate tools. Most of all, I love SQL Prompt because its features increase my productivity on a daily basis. Recently I discovered a couple of new features for the SQL Server Management Studio results grid. The usefulness of…
I have enjoyed working with Availability Groups ever since they were released with SQL Server 2012. Each major version since, the feature has improved and along the way so has my knowledge of them. Knowledge born from mistakes and lessons…
When I was in the U.S. Navy, the sailors had a lot of social challenges since we had 200 grumpy men all sharing the same facilities for several months at a time. It should not be surprising that the laundry…
I am extremely excited to announce that I have achieved level 4 in My Epic Life Quest! Over the last year I had been reminding myself about my own epic life quest. I felt like I had drifted from my…