Found this tool that is good for VHD / Virtual Hard drive / Virtual Machine resizing. I have been running SQL Server on a VM and the performace thus far is good. The December 2007 edition of SQL Server Magazine had some good articles about virtualizing...

C:\Program Files\ProClarity\ProClarity Dashboard Server\ Nice article on SQL 2008 (Katmai) New Features: http://blogs.mssqltips.com/blogs/chadboyd/archive/2007/10/15/katmai-sql-2008-the-list-of-new-features.aspx I have attached a PowerPoint file...

Here is a way to search the Information_Schema to find all tables that have the letter 't' in them, can be helpful to search the metadata of your database schema select * from INFORMATION_SCHEMA.columns where table_name like '%t%' order...

This has been a favorite stored procedure of mine to search the text of my stored procedures for certain phrases... really helpful as the number of stored procs you have grows quite a bit: -- xps '%procedure%' --search for the word 'procedure' in all...

Here is a SQL Server Unattended Install Script I wrote last week... was nice to get it working finally!!! ;the PIDKEY will show up in greyed out text boxes during a MANUAL Install... use this for the PIDKEY Parameter IF NECESSARY (probably not necessary...

Found this script to disable/enable constraint checking here : SELECT 'ALTER TABLE ' + object_name(parent_obj) + ' NOCHECK CONSTRAINT ' + name FROM sysobjects WHERE xtype = 'F' ORDER BY object_name(parent_obj) and to enable: SELECT 'ALTER TABLE...

Here is a nifty way to add an IDENTITY column on the fly... select distinct id = IDENTITY ( int , 1 , 1 ), usr into dim_usr from fact_eyeballs