I see questions on forums all the time about DBA’s or System Admins finding they are out of drive space due to a very large transaction log.  Post vary a bit on what the admin has tried but a common theme is that they have tried shrinking the file but… Read more

Wow, how time flies by.  It seems like just a month ago I was made the PASS Regional Mentor for South Central US and now I have given up that position to join Jorge and Adam as Regional Mentors for South East US.  Being I live in GA, it is… Read more

I have been working on a new skill this week and that is implementing transactional replication.  I am of course doing all this testing and learning on a development system and thank goodness I am.  I have found all kind of little nuances with getting this setup.  A fun error… Read more

Sounds weird right, but that is exactly what has happened with a VLDB I inherited.  A third party database that I support contains 23 columns per table and 16 of those columns have a non clustered index.  That’s it, that is all there is to the table? Each month a… Read more

Tonight I will be doing a presentation on TEMPDB to the Steel City SQL Users Group in Birmingham AL.  I am very excited to be able to present to a user group other than my own.  I am also nervous about it as well.  I have spoken at 5 SQL… Read more

It sounds simple and logical doesn’t it.  One could say it is common sense right?  How many of us are failing to do this simple task?  It could be things as simple as having a monitor tracking successful backups, amount for free disk space on a drive or the amount… Read more

As a DBA why would I consider attending a pre-con by John Welch at SQL Saturday 89 titled Data Warehousing with SSIS?  For starters lets look at what all the session entails.

-          Laying out a framework for your ETL
Logging, Restartability and Recoverability, Auditing

-          Common SSIS Tasks
Using… Read more

Well at the PASS Summit at least.  The Summit is trying to make sure that all of our first timers get the full experience of the Summit.  It can be a bit overwhelming the first time you attend the largest SQL Server event in the world.  I know it was… Read more

Do you need to perfect your SQL Server skills?  Would you like to get 24 hours of free SQL Server training from some of the top names in Business Intelligence and SQL Server?  Then you are in luck.  24 Hours of PASS is a free event delivered right to your… Read more

If you haven’t visited the SQL Saturday website you should take a look.  There are SEVEN events planned during September around the globe.

SQL Saturday 88, September 3rd, Western Cape South Africa
SQL Saturday 94,  September 10th, Salt Lake City UT – USA
SQL Saturday 95, September 17th, San Diego… Read more