Administration | John Morehouse

sqlrus.com // dba // bat whisperer

SQL Server Schedulers To Rule Them All

On March 17, 2017August 29, 2020 By John Morehouse

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

Quick Script – Finding Most Recent Backup

On September 19, 2016September 19, 2016 By John Morehouse

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.

Validating Cluster Instance Owner with Powershell

On July 17, 2015July 17, 2015 By John Morehouse

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

T-SQL Tuesday #67 – Extended Events

On June 9, 2015June 9, 2015 By John Morehouse

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

SQL Server 2008 R2 SP3 Install Errors

On May 28, 2015May 28, 2015 By John Morehouse

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

Database Growth

On May 14, 2015May 20, 2015 By John Morehouse

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

T-SQL Tuesday #65 – Failing Over with PowerShell

On April 14, 2015April 14, 2015 By John Morehouse

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

Detaching a Database – File Security Gotcha

On April 9, 2015April 9, 2015 By John Morehouse

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