SQL Stuff

Stuff about SQL 2000 and SQL 2005
Just a tip for me about SQL Versions...
Working on a database project today I got the latest drop from a co-worker to test on our deployment machine. The process had gone on without a hitch for the past few months but today the SQL 2005 database backup file he gave me would not restore on the deployment machine...gave an error during the restore saying it was "INCOMPLETE". A quick check of SQL Server versions using MS KB 321185 showed us that he was on SQL 2005 SP3 and I was on SQL 2005 SP2. Thankfully that 2 minutes worth of checking ......

Posted On Thursday, April 2, 2009 6:15 AM | Comments (0)

SQL Saturday #9 - Call for Speakers

SQL Saturday #9 scheduled for this year on October 11, in Greenville, SC is looking for speakers. If you are interested let me know and I'll get you plugged in.

For more information visit: http://www.sqlsaturday.com/eventhome.aspx?eventid=12

Posted On Monday, September 15, 2008 6:35 AM | Comments (0)

Event ID: 3000 TFS Warehouse Error
Disclaimer – this article describes a fix that worked for me – YMMV…proceed with caution. I recently encountered a weird error with the TFSWarehouse data cube and reporting services for our site. It started out innocently enough with an error I hadn’t seen before in the event log (shown below) Well that was odd enough because it suddenly appeared out of nowhere, but then I also noticed odd things going on with the reports that TFS generates. It was generating reports but it was all stale data…apparently ......

Posted On Wednesday, January 23, 2008 12:20 PM | Comments (0)

How to change the IP Address of a SQL Cluster
Due to some sweeping changes that are coming down the pipeline at work I've got to change IP's for a number of SQL clusters that are in production. Having gone through enough nightmares while originally setting up these clusters over the years I wasn't looking forward to it... but since I had enough lead time I took some lab assets to mirror the production setup so I could play with it before crunch time. I'm posting the following reference to a Microsoft KB article for my own benefit and for those ......

Posted On Friday, January 4, 2008 9:51 PM | Comments (0)

SQL 2000 and SQL 2005 clustered together...can it be done?
And equally important - is it recommended? Has anyone else out there successfully clustered SQL 2000/2005 together? I've seen stuff out there that says it works and other stuff that says it doesn't. I'm actually about to scrape up some hardware to try it out because the topic came up at work, just wanted some additional insight before making that plunge. The end result we're after is to have an Active/Passive Windows 2003 cluster that has a SQL 2000 instance and a SQL 2005 instance on it...more to ......

Posted On Wednesday, October 3, 2007 10:33 AM | Comments (4)