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 […]
If You Aren’t Measuring It, You Can’t Manage It
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 of free space in your […]
Data Warehousing with SSIS
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 FTP to Retrieve Files, Copying and Archiving Files, Executing SQL Statements, Moving Data […]
I Am Going to Be a Big Brother #sqlpass #firsttimers
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 for me. There is so […]
Register for 24 Hours of PASS NOW! #sqlpass
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 computer. All you have to do […]