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 […]
Category: SQLServerPedia Syndication
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 […]