Category Archives: SQL Server

Query the status of SQL Agent jobs

I’ve been involved in building a solution on top of SQL Server peer to peer replication (SQL 2014 SP1) and slowly building up a script library for general DBA tasks within that solution. One common task is to add a … Continue reading

Posted in SQL Server, Uncategorized | Leave a comment

Drop down boxes not working in SQL Server 2012 Configuration Manager

After a data centre power outage a decision was made to switch the start up mode of a bunch of our SQL Servers to manual so that the on call DBA could manage the reintroduction of the servers in a … Continue reading

Posted in Powershell, SQL Server | 2 Comments

Behaviour change for delete … output … into in SQL Server 2014

A colleague of mine discovered an interesting behaviour change from SQL Server 2012 to SQL Server 2014. We recently upgraded one of our servers from SQL 2012 to SQL 2014 and a job started failing. (Although I haven’t explicitly tested … Continue reading

Posted in SQL Server, T-SQL | Tagged , , , | 4 Comments

The most recent backup problem

When I first began this blog, back at the beginning of my DBA career, it was purely a place for me to keep queries, things I was learning, processes and handy links. This is one of those posts, there’s nothing new or ground-breaking … Continue reading

Posted in Disaster Recovery, Powershell, SQL Server | 1 Comment

Space issues with SSIS temp files

The page came at a reasonable hour. All of the overnight ETL and processing jobs were just winding up before the business started in earnest for the day. One of the final jobs of the morning failed, a job that … Continue reading

Posted in SQL Server, SSIS | Tagged | 5 Comments

Another great reason to enable remote admin connections

I recently came cross another great reason to enable the remote admin connections server configuration on SQL server. If you don’t know what the DAC is I’m not going to go into detail here so check out these posts here, … Continue reading

Posted in Disaster Recovery, Security, SQL Server | Leave a comment

Tracking down CPU spikes using process explorer and DMVs

What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish I knew but I don’t. I do know that I have been on the receiving end a few times. Just … Continue reading

Posted in Service Broker, SQL Server | Tagged , , , | 3 Comments

The full text error and why I was happy to see it.

The Situation: I was recently involved in the migration of a group of core databases from three SQL Server 2005 instances to three SQL Server 2012 instances. There were quite a few moving parts that needed to be considered as part of … Continue reading

Posted in Database options, Disaster Recovery, SQL Server | Tagged , , , | 2 Comments

Migrating SQL Server logins

Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During some recent migration work I realised that SQL Server Management Studio could do most of the work of sp_help_revlogin. I … Continue reading

Posted in Security, SQL Server, T-SQL, Uncategorized | Tagged , | 8 Comments

Rolling back transactions with cursors and local variables.

I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent so I’ve been working on error handling and “transactionalising” certain parts of the process. I needed to answer a couple … Continue reading

Posted in Database Theory, SQL Server, T-SQL | Tagged | Leave a comment