(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
A question came up on the Data Platform MVP email list last night asking what the FCB_REPLICA_SYNC spinlock is. I answered the question and then
As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see
Earlier today someone asked on the #sqlhelp Twitter alias if there is a history of database snapshot creation anywhere, apart from scouring the error logs.
I’ve blogged about problems with database snapshots a few times previously (see my Database Snapshots category) but here’s a new one that I’ve been meaning
Three weeks ago I kicked off a survey about using database snapshots – see here – because I don’t really know how much they’re used or
As I was writing a quick SQL Server Magazine blog post on database snapshots while waiting for my coffee to brew, I figured it would
The May edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
This is a quick post to clarify an article I saw on SQLServerCentral this morning that seemed to state that transaction rollbacks push data into
The 35-page whitepaper on high availability I wrote for the SQL team over the summer has been published on MSDN. It’s a 2-300 level whitepaper
There are a couple of issues that I’ve heard of in the last few weeks (one while onsite at a customer) and I think they might bite
Recently there’s been a spate of people noticing strange behavior from active transactions when DBCC CHECKDB (or any of the other DBCC consistency checking commands
As you may know, DBCC CHECKDB (and some of the other DBCC CHECK*) commands use an internal database snapshot to get a transactionally consistent view
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
Before I start, I want to make it clear that you can only hit this bug if you ALREADY have corruption, that it’s quite rare,
A couple of weeks ago I blogged about the three tracks of the SQL Server 2008 JumpStart course that SQLskills.com taught internally for Microsoft and
Here’s an issue that I thought was a one-off but it just popped up again over the weekend so I want to publicize it. DBA
This is a post I’ve been meaning to do for a while – detailing some of the problems you can run into when using database
One of the sessions we did yesterday at IT Forum was an Instructor-Led Lab on database snapshots, an Enterprise Edition feature of SQL Server 2005.
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.