If you are re-attaching databases after a SQL 2008 upgrade, here is a quick n dirty T-SQL command to upgrade to the the correct compatibility level, just run, copy the results and run those: select ‘ALTER DATABASE [' + [name] + ‘] SET COMPATIBILITY_LEVEL = 100′ from master.dbo.sysdatabases
Sometimes when I come across something in SQL, I usually don’t think of it as a blog topic because I have a mistaken belief that “everyone” already knows this. So, today, a quick tip that was needed for a situation that arose the other day. We have a 2000, 2005 and (blessedly) 2008 environment currently [...]
Continue reading about SQL Tip: Running a large script from command line
I had a job failure over the weekend on a SQL Server and while it gave me the job step number, it occurred to me that this maintenance task that does a DBCC CHECKDB on each database separated into separate job steps was getting difficult to manage. The issue was that as new databases were [...]
In my series of articles to help a DBA who is managing multiple servers, I present my first in a long list of harvests that allow you to have a central repository of information about all your servers. All of these harvests use a similar model. They all cursor through the ServerList table I talked [...]
I know some of you have subscribed to this blog and are wondering if all I am going to post about is SQL… Well, for a little while that is where my blogging roadmap is taking me. Today, I want to talk about a table that is very important to any DBA handling more than [...]
Error logging for SQL Server 2005 by creative use of a few system stored procedures
DandyID
AIM
Amazon
Digg
Ebay
Facebook
Flickr
Google Reader
Gyminee
Hulu
iTunes PodCast
LibraryThing
myOpenID
Netflix
Odeo
Plaxo
Shelfari
Stack Overflow
Stumbleupon
Twitter
YouTube