Move System Databases from the OS Drive

When creating an SQL Server environment using the Azure template, and after running the following query, it is observed that the system databases will be located on the OS partition. For reasons of performance and for example to avoid that the TEMPDB causes a server outage, these must be moved... [Read More]

Obtain Access to SQL Server using PowerShell

A few times, more than I would have wanted, I’ve been asked to support a SQL Server instance which was “discovered” to have been installed by “someone else”. This could have been anyone: a previous DBA, a Developer, an Ops person, a Vendor, or other. Any DBA working in an... [Read More]

Quick Basic Monitoring

Looking into a performance issue, such as when someone reports “blocking”, an important tool every DBA (in my opinion) should have on their toolbelt is the sp_WhoIsActive stored procedure. [Read More]

Filter Out Error Log Messages

The SQL Server error log is a text file, which by default is located in the LOG folder and stores various messages. The message types vary from informational to warnings, to actual errors, all of which can help a DBA in troubleshooting or actually prevent something unwanted from happening. [Read More]