Browsing the archives for the SysAdmin category
When I was in elementary school we often had planned “fire drills”. We would be told of the impending alarms, the alarms would go off, and we’d all exit the school in an orderly fashion using the prescribed path and exits. Fast forward a hundred years and I’ve discovered why fire drills are important… So [...]
After six months of using SQL Server 2008 Trial, the party is finally over; my free trial has expired. Unlike most trial software applications Microsoft does not present the user with a dialog box indicating that there are only X number of days remaining with the trial version. The SQL Server service will just shutdown [...]
Just in time for the Holidays… Kevin Kline has come to town. Kevin’s topic at the Charlotte SQL Server Users Group weighed the pros and cons of SQL Server virtualization. In this post I will note some of the many points that I learned. Before I dive into the technology details I would like to [...]
When testing data warehouse ETL routines it’s often necessary to be able to reload the same data several times before you get the code dialed in and ready for production work. One way to be able to do this is to simply TRUNCATE the target table, assuming there are no foreign keys on it. If [...]