Tag Archives: administration

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

Configuration Validation – Max Memory

A look at a script that validates the max memory setting for our installed SQL Servers. Continue reading

Posted in Administration, T-SQL | Tagged , , | 6 Comments