Author: Brandon Abshire
Brandon has worked in IT for nearly 20 years, and currently serves as a SQL Server DBA for a healthcare company in California. In his spare time, he runs for miles and helps maintain Brandon is a certified SQL Server administrator.

Leveraging SQL Database Snapshots

I’ve known about SQL Database Snapshots for a while, but never really took the time to use the feature.  Lately, I’ve gotten into mirroring again and decided to play around with Database Snapshots.  I should clarify at this point that

Posted in SQL Server

A Possible Infinite Recompile was Detected – SQL Server Bug with Linked Servers

I recently assisted in migrating a very large system from SQL Server 2005 SP3 to SQL Server 2008 R2 SP1.  The actual migration of the database went off without a hitch, but we soon encountered an odd error with the

Posted in SQL Server

When xp_delete_file doesn’t work as expected…

Whether you use a Maintenance Cleanup Task as part of a SQL 2005 or 2008 Maintenance Plan, or script out your own cleanup t-SQL, you are probably using the xp_delete_file extended procedure. For quite a while, I’ve occasionally come across

Posted in SQL Server

Slow SQL Query Execution in SQL Server 2005 SP3 x64

Recently, we’ve come across poor SQL performance on a very powerful SQL box and we were having trouble identifying the exact cause. After some talks with the software vendor and Microsoft, we were pointed to the TokenAndPermUserStore cache. There are

Posted in SQL Server

Deploying Maintenance Plans with PowerShell or ASP.NET

I feel that my job as a DBA is very dynamic and usually keeps me busy with new things… except for deploying maintenance plans.  I hate making maintenance plans.  Luckily, I at least have a template that I can use

Posted in ASP.NET, PowerShell, SQL Server

Adding a Node to a SQL 2008 Failover Cluster

Installing a SQL Server 2008 Failover cluster is actually fairly easy, once you have the Windows Cluster set up. I experienced an issue adding the failover node, which is now a separate process compared to how it was done in

Posted in SQL Server

MS BizTalk 2006 & 2009 Installation and Configuration Errors

I recently installed BizTalk 2006 and 2009 on a few servers at work. I found the process to be very painful for some reason. In regards to the BizTalk 2006 installation, I was running into an issue where the installer

Posted in Windows

SQL Browser Routing Errors and Infrastructure Errors in Event Log – syspolicy_purge_history

Recently, I noticed errors occuring daily at 2:00AM on my SQL Cluster. The errors showed Windows logins being routed to the wrong named instances, along with errors from SQL Browser not being able to service client requests. I noticed that

Posted in PowerShell, SQL Server