The initial release of Database Lifecycle Management is now available on MSDN.The site is something called ''curated content''. This means it's a single consolidated location to look up lots of disparate articles and content, all in one easy to search location. This “curated content view” contains the best content, video, and ...

Here's a quick tip for you:During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time. Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. ...

One of the things that drives me crazy as I'm getting older is that my brain is losing the capacity to differentiate version numbers. As I speak travel around speaking with customers and at conferences, I find my self saying things like ''I can't recall if this problem was fixed in SQL Server 2000 or 2005. But you don't have to worry about that ...

What if I told you to take your latest production backup, restore it on a different machine and try using the database? Are you comfortable with that task? Do you think it will work? When was the last time you tested your backups?
Do you even have a backup?
Why am I asking all these things? Because your data is as good as your last good backup. ...