Tag Archives: administration

Start Your Engine’s with Startup Procedures

After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up procedures.  This caught my attention as I was not fully aware of what those were.  Naturally I decided to investigate … Continue reading

Posted in Administration | Tagged | 3 Comments

Reverse It

Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server.  I had sent them a code snippet and they inquired as to what the purpose of the function was.  Essentially, this function … Continue reading

Posted in Administration | Tagged | Leave a comment

Ola Hallengren: Output File

I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to manage backups, index maintenance and the overall health of your SQL Servers. It is utilized around the globe and it … Continue reading

Posted in Administration | Tagged | 2 Comments

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 | 7 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 | 3 Comments

T-SQL Tuesday #90 – The Elephant’s Name is Database

T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community  It is the brainchild of Adam Machanic (B|T) and is not limited to just things around the SQL Server database engine. Each month a blogger hosts the event and … Continue reading

Posted in TSQL Tuesday | Tagged , , | Leave a comment

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 | 6 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