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