Author: Derik Hammer

We are all familiar with table variables, local temp tables, and global temp tables but what some people over look is that stored procedures…

Powershell and .NET Objects Now that we’ve covered SQLCMD.exe with the command prompt I’d like to dive into the present and future of Windows…

One challenge for a DBA is to setup the appropriate backup plans for the databases under our responsibility. It is easy to use SSMS’s…

SQL Server 2012 RTM Cumulative Update #10 is now available. KB Article: KB #2891666. Build Number is 11.0.2420. Applicable to @@VERSION 11.0.2100 through 11.0.2419. NOTE:…

Recently I blogged about two methods to repair transactional replication. Transactional Replication – Fixed in Minutes Today I was attempting to apply the same…

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…

Often I find myself thinking to myself, “if only I had one more DBA.” I’m sure we’ve all said this often enough and probably not…

May Updates for SQL Server Cumulative Update #11 for SQL Server 2008 SP3 is now available. KB Article: KB #2834048. Build Number is 10.00.5840. Applicable…

Recently I found myself involved in a project where a tab delimited text file (updated daily) was being imported into a MS SQL Server…

Every SQL Server DBA is intimately familiar with SQL Server Management Studio (SSMS) and/or previous tools such as Query Analyzer. What some of us…