I just 10 short days Atlanta GA will be hosting the most stellar lineup of speakers SQL Saturday has ever seen. There have been lots of chatter about SQL Sat #89 being deemed SQL Rally of Atlanta. With 485 people registered and 26 currently on the waiting list, we will have to keep a close […]
When technology works.
Living in the South East has it perks with the abundant rivers, lakes, streams, mountains, and friendly people. It also has some drawbacks like being within reach of tropical storms, hurricanes, and the abundance of tornados. This Labor Day was quickly impacted by Tropical Storm Lee who came ashore early into the three day weekend. […]
It is not a blame game.
Here is a hypothetical situation. A dba works for ACME Corp. Due to what ever reason a change has to be made to a user account within Active Directory that should not create any negative issues for the user account. Sounds typical right? The change is made (just happens to be the domain user account […]
Shrinking Transaction Logs
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 it didn’t shrink and a […]
PASS Regional Mentor
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 much easier for me to […]
Learning Transactional Replication
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 I came across today after […]
Adding an Index to Save Space
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 new table is created and […]
Steel City SQL User Group
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 Saturdays in the past 7 […]