Tracy Boggiano's SQL Server  Blog Rotating Header Image


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 […]

T-SQL Tuesday #53 – Why So Serious? No SQL Authenication 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 […]

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. […]

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 […]

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 […]

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 […]

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

This month’s T-SQL Tuesday is brought to us by Argenis Fernandez (blog | @DBArgenis). Argenis is asking if we specialize or not, why we do (or don’t) specialize, and why we feel that’s a good thing. I started out my career as a Jack of All Trades mainly because my first employer was a small […]

A New Year Means New Resolutions – 2012

I usually do not make resolutions because that seems like you are trying to give up something instead of gaining something.  I would prefer to call them goals that way they can be a list of possible accomplishments instead of potential failures.  For 2012, I decided to record my goals for the New Year and […]