Category: Miscellaneous

What’s Tracy Up To, October 2017

Wow this year has been really busy.  I’ve completely turned into a SQL Saturday addict with 15 SQL Saturdays completed, two more scheduled, and one more potential one to go.  I might need an intervention or a 12-step program or I just may continue to have fun and meeting everyone and sharing my knowledge. This …

Read More “What’s Tracy Up To, October 2017”

First Time Advise for Attendees of SQLSaturday or Other Pass Events

Recently I came across on Twitter a question from Chad Smith asking for advise on attending his first SQLSaturday.  The fact is asking means he is already ahead of the game and he is on Twitter.  I got him to follow me on Twitter and offered him the following the following advise via a DM …

Read More “First Time Advise for Attendees of SQLSaturday or Other Pass Events”

Check Backup Encryption Sizes

I had a recent project to enable backup encryption on all our servers.  Then question from the storage team came up will this required additional space.  Well by then I had already enabled in all our test servers so I wrote a query that would compare the average size of backups before encryption to after …

Read More “Check Backup Encryption Sizes”

T-SQL Tuesday #90 – Shipping Database Changes

At my first official DBA job, I was being trained the current DBA on deploying stored procedures.  They had system where you received a ticket with the SQL file attached.  You proceed to see if the procedure existed and if it did.  You right click on it and look at who had access to it …

Read More “T-SQL Tuesday #90 – Shipping Database Changes”

Paul Randal Mentor Me?!

Paul Randal recently won the award for “Person You’d Most Like to be Mentored By” in the Tribal Awards, now Paul is offering to mentor 3 men and 3 women for two months. To get a chance of getting mentored by Paul, you simply need to apply by writing a blog post about why you should be considered …

Read More “Paul Randal Mentor Me?!”

T-SQL Tuesday #53 – Why So Serious? No SQL Authentication Use Your Own Account

At a previous job I had several developers that had passwords for SQL authenticated accounts for systems that would give them more access than they needed when they had Windows accounts that would give them enough to troubleshoot issues.  Our trick was to write a login trigger that would block any SQL Authentication accounts that …

Read More “T-SQL Tuesday #53 – Why So Serious? No SQL Authentication Use Your Own Account”

T-SQL Tuesday #051: Place Your Bets

This month’s T-SQL Tuesday is brought to us by Jason Brimhall.  We are writing about times someone took chances with the databases that the DBAs felt were not worth it.  I am going to talk about taking chances with your backups, our #1 job as DBAs is to have backups. Let’s start with the scenario. …

Read More “T-SQL Tuesday #051: Place Your Bets”

Script to Setup SQL Server Database Mirroring for Multiple Databases

Last year I had project that involved using database mirroring between two servers that had 20+ user databases on them and setting those up one a time takes way too long.  I wrote this script to generate script that could be ran in SQLCMD mode and setup mirroring between the two servers.  The @newmirror variable …

Read More “Script to Setup SQL Server Database Mirroring for Multiple Databases”

T-SQL Tuesday #44 The Second Chance

This month’s T-SQL Tuesday is brought to us by Bradley Ball (blog | @SQLBalls). Bradley asked us to write about Second Chances.  Giving us a chance for us to talk about things we have learned from mistakes we have made.  Over the years we have all made mistakes or wished we would have done something …

Read More “T-SQL Tuesday #44 The Second Chance”

Query “SQL Server has encountered ? occurrence(s) of I/O requests taking longer than 15 seconds to complete on file” from the Logs

Recently we moved some servers from being physically on local drives to virtual on our SAN.  We started getting Error 833 messages every night during Integrity Checks.  The more servers we added the more messages we got.  I needed a quick way to retrieve these messages from our error logs and considering we cycle the …

Read More “Query “SQL Server has encountered ? occurrence(s) of I/O requests taking longer than 15 seconds to complete on file” from the Logs”