Rolling upgrade using database mirroring (and a bug in 2008 RTM)
While trawling through the latest 2008 Books Online this morning to answer a question, I noticed a new section that I hadn't seen before, which
While trawling through the latest 2008 Books Online this morning to answer a question, I noticed a new section that I hadn't seen before, which
In the TechNet Magazine article I wrote on Advanced Troubleshooting with Extended Events, I mentioned the always-on event session called system_health. Jonathan Kehayias, a fellow
Cumulative Update 1 for SQL 2008 RTM contains fixes for two nasty FILESTREAM bugs (among a lot of other bug fixes). The first one concerns
In my previous post today I talked about error 825 and how you should have an Agent alert set up to catch it when it
There are two pretty well-known I/O errors – 823, and 824 – but there’s also one called 825 which most DBAs do*not* know about, and
The first of the long-promised photo posts (with lots of Wikipedia links) – click on photos for larger versions. Over the holidays Kimberly and I
Microsoft has released a PDF showing all the SQL Server 2008 system tables – very cool but you'll need a big printer to print it
Microsoft’s Steffen Krause has written an excellent whitepaper on Tuning the Performance of Change Data Capture in SQL Server 2008, that I technically reviewed, and
Well, it was released a year ago but I only just found out about it last week. The SQL CAT team published a whitepaper last
It’s become something of a tradition for me to do a Valentine’s Day blog post (the 2008 one about SQL Server blogs is at Wow
In SQL Server 2000 and before, the symptoms of database corruption would occasionally manifest themselves as asserts, such as: SQL Server Assertion: File: <recbase.cpp>, line=1378
One of the things I mentioned in my recent TechNet Magazine article on Understanding Logging and Recovery was the need to manage the transaction log
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.