Monthly Archives: August 2011

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 … Continue reading

Share
Posted in Query Tidbits, SQL Tuning, SQLServerPedia Syndication | Tagged , | 3 Comments

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 … Continue reading

Share
Posted in SQLServerPedia Syndication, Training/Events | Leave a comment

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 … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | Leave a comment

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 … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | 2 Comments

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 … Continue reading

Share
Posted in SQLServerPedia Syndication, Training/Events | Leave a comment

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 … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | Leave a comment

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 … Continue reading

Share
Posted in SQLServerPedia Syndication, Training/Events | Leave a comment

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 … Continue reading

Share
Posted in SQLServerPedia Syndication, Training/Events | 1 Comment

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 … Continue reading

Share
Posted in Training/Events | 1 Comment

I deem September 2011 – SQL Server Month

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 … Continue reading

Share
Posted in Training/Events | 2 Comments