- "... a scholar and a true gentleman." - Buck Woody, Microsoft's "Real World" SQL Server DBA.
Friend of Redgate
-
Recent Posts
Tags
Agresso AskSSC Backup Book Review Books Career CTE DBCC Denali Design Disaster Recovery Education ETL Full Text Indexes Indexing Installation IT Management Kaseya Maintenance Maintenance Plans Management Meme Monday Migration Monitoring MSDB Normalization Performance PowerShell Programming red-gate Restore SQLBits SQLSaturday SQL Server 2000 SQL Server 2005 SQL Server 2012 SSMS T-SQL T-SQL Tuesday Training Upgrade User Group Windows 2012 WordPress WTFArchives
Categories
SQL Server blogs
SQL Server Resolution
Tag Archives: Upgrade
Adventures with DBCC and Database Upgrades
We have (had?) an application that has been retired (Hurrah!). However, even though it has been retired, there is still the occasional request to extract data from this database, which was hosted on a SQL2000 SP3a server. So what I’m … Continue reading
Posted in SQLServerPedia Syndication
Tagged DBCC, SQL Server 2000, SQL Server 2005, SQL Server 2008 R2, Upgrade
2 Comments
Unable to launch Activity Monitor.
It all started so innocently. A SQL Server 2005 installation. An installation of SQL Workbench, sorry, “Microsoft SQL Server Management Studio.” And a need to find out what’s going on. Click, click, click – Activity Monitor. Double-click. Uh-oh. (Incidentally, why … Continue reading
Posted in SQLServerPedia Syndication
Tagged Cluster, Installation, SQL Server 2005, Upgrade, WTF
2 Comments
SQL Server Upgrades ahoy!
A major problem facing many of us is that of sprawl. In my case, I have databases served by SQL Server 2000, 2005 & 2008. As if that’s not bad enough, the service pack levels on these servers varies, as … Continue reading
