Derik Hammer

Posts by: Derik Hammer

AWS Database Migration Service

AWS Database Migration Service

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…

Website hosting challenges

Website hosting challenges

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…

Redgate SQL Prompt Grid Features

Redgate SQL Prompt Grid Features

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…

Top 10 Tips for Availability Groups

Top 10 Tips for Availability Groups

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…

Dryer Lint

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…

Ding Level 4 in My Epic Life Quest

Ding Level 4 in My Epic Life Quest

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…

DBCC CLONEDATABASE

DBCC CLONEDATABASE

Often I hear developers claim that they need production data in order to properly tune their queries. There are a couple of reasons that they believe this. The most important one is likely because the execution plans generated in a…

Azure SQL Database Elastic Pools

Azure SQL Database Elastic Pools

Azure SQL Database Elastic Pools are a mechanism for grouping your Azure SQL Databases together into a shared resource pool. Imagine for a moment that you had a physical server on premise. On that server, you have a single SQL…

My SQL Cruise Diary

My SQL Cruise Diary

It has been three years since I first heard of SQL Cruise from Grant Fritchey (b | t). At the time, I was working for a large tax preparation company. They would not allow me to attend any conference during…