PowerShell SQL Connection Test

In the interest of providing minimal surface area exposure to my servers I have taken on the common practice of not installing development tools on any of my Production servers. In almost all cases this is no big deal because…

Huge distribution database

The Problem: Today I noticed the data drive of one of my Production servers growing. It wasn’t growing overly fast and it had been quite some time since the last SAN drive expansion so I gave the thumbs up to…

Automated Unattended (Silent) SQL Server Installs with PowerShell

Last time we covered the basics of unattended installs in my post, Unattended (Silent) SQL Server Installations. Here I will be providing and explaining my PowerShell script for facilitating these installations. UPDATED: Click here for the QS-Config product page. Where you can…

Unattended (Silent) SQL Server Installations

As promised from my last post, Relocating SQL Server System Databases without Access to the Instance, today I will be blogging about ‘unattended’ or ‘silent’ installations of SQL Server. I will be discussing the concept and uses of the unattended…

Welcome to my blog!

Welcome to my first post on the new sqlHammer blog site. My name is Derik Hammer and I’m a believer in sharing knowledge. Few people understand how powerful the old saying, “Feed a man a fish, he’ll eat for a…