SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


Matt Bowler is a DBA at Trade Me, and teaches database design and administration courses at the local institute of technology. A recent but avid discoverer of SQL Server, Matt is a regular contributor to forums at MSDN, Experts Exchange and SSC and he blogs at mattsql.wordpress.com.

Archives: April 2012

Locked out of SQL Server.

This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql server.

I have a SQL Server instance with the sa account disabled and all other logins removed to simulate a situation were I am locked out of SQL Server. My… Read more

3 comments, 2,420 reads

Posted in Ctrl-alt-geek on 30 April 2012

SQL Server 2005 backups in a hung state because of full text search process

I came across an issue today where a backup process was in a blocked state with a wait type of MSSEARCH. The issue boiled down to an issue with communication/contention between the SQL Server engine service and the SQL Server Full Text Search service.

An attempt to kill the backup… Read more

2 comments, 573 reads

Posted in Ctrl-alt-geek on 24 April 2012

Instant File Initialization Security Risk

A while ago I blogged about instant file initialization. A colleague of mine pointed out that there is a small but non-zero risk involved with using this setting.

So I decided to put a demo together to test out the security risks involved.

I have a default instance and… Read more

0 comments, 826 reads

Posted in Ctrl-alt-geek on 16 April 2012

Apply SP1 to SQL Server 2008R2 on active/active cluster.

While researching the steps required to service pack SQL Server on an active active cluster I came across a lot of conflicting information. Here are the steps I ultimately followed for an error and issue free update.

1. Make a note of all node names (and/or IP addresses), SQL Server… Read more

3 comments, 888 reads

Posted in Ctrl-alt-geek on 16 April 2012