Category Archives: Administration

Experienced DBA: Rookie Mistake

M.A.S.H 4077.  Mobile Army Surgical Hospital.  One of my all time favorite TV shows that I still watch to this day.  There is one episode that has always stuck with me is one where Hawkeye has to deal with death … Continue reading

Posted in Administration | Tagged | 5 Comments

Knowing the Options

Quick look at @@options and a script that will be a little more useful to see what options are enabled for your current session. Continue reading

Posted in Administration | Tagged | 2 Comments

Schedulers To Rule Them All

A look at an issue I discovered with SQL Server 2012 Enterprise Edition ISO that was installed. Continue reading

Posted in Administration | Tagged | 4 Comments

Quick Script – Finding Most Recent Backup

A quick script that I wrote to find the most recent full backup of a database as well as generate a restore command for me with the appropriate file location. Continue reading

Posted in Administration | Tagged | Leave a comment

Validating Cluster Instance Owner with Powershell

A look how I am using powershell to send out validation emails regarding our clustered instances. Continue reading

Posted in Administration | Tagged , | Leave a comment

T-SQL Tuesday #67 – Extended Events

A look on how I am using extended events to monitor which SQL logins are authenticating to the sql instance. Continue reading

Posted in Administration | Tagged , , , | Leave a comment

SQL Server 2008 R2 SP3 Install Errors

A look at an install error that I encountered with SQL Server 2008 R2 Service Pack 3. Continue reading

Posted in Administration | Tagged | 2 Comments

Database Growth

An experiment to confirm that a SQL Server database will grow in increments specified by the auto growth settings. Continue reading

Posted in Administration, Internals | Tagged | 4 Comments

T-SQL Tuesday #65 – Failing Over with PowerShell

A look at how I’m using Powershell to hep control who is the owner of a clustered resource for serviceability. Continue reading

Posted in Administration, TSQL Tuesday | Tagged , , | 4 Comments

Detaching a Database – File Security Gotcha

A look at what happens to file permissions when you detach a database with an active directory or machine user account. Continue reading

Posted in Administration, Internals | Tagged , | 5 Comments