The Curious Case of… emergency-mode repair
(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
(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
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 done incorrectly, technologies used the wrong
The September SQL Server Magazine articles are now available on the web and include my latest feature article on Using Database Repair for Disaster Recovery.
(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 week's been a busy one on the forums and Twitter, with lots of interesting problems people are hitting. One of the things I've noticed
This is a true story, and unfolded over the last few days. It’s deliberately written this way, I’m not trying to be patronizing – just illustrating
Just saw this on a forum – running REPAIR_ALLOW_DATA_LOSS on msdb to cope with corruption. Yes, this will work but it's certainly not safe and
This blog post describes the demo "2 – NC Indexes" from my Corruption Survival Techniques conference session from various conferences in 2008. The links to
For those of you who couldn't make it to a conference this year where I presented my Corruption Survival Techniques session, the folks at TechEd
Now, I’m very thick-skinned and I know there are always some people in a conference session who don’t agree with everything I say (that’s human
This blog post explains the demo scripts and databases I've posted to cover all the Corruption Survival Techniques and DBCC CHECKDB sessions I've presented at
It’s been almost two weeks since my last post as we’ve been offline in Scotland (another photo post to follow – I owe you two
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
Every so often I’ll see posts on the various data corruption forums discussing causes of corruption. In this post I want to debunk some of
Today I presented my brand new session Surviving Corruption: From Detection to Recovery at TechEd. I had a lot of fun putting together the demos, presenting
(I’m actually on-stage here at TechEd doing the DAT track pre-con with Kimberly – she’s on now until lunch so I’m catching up on forum problems…)
In my previous post on interpreting DBCC CHECKDB output, plus in my DBCC Internals session at TechEd IT Forum in Barcelona yesterday, I mentioned there
Last week at SQL Connections someone said that CHECKDB’s output is ‘useless’. Given that I wrote CHECKDB for SQL Server 2005 I was only mildly
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’
(Check out my online training course: SQL Server: Detecting and Correcting Database Corruption.) In this post I want to describe the two worst things I
Now that I have a little more time on my hands I’ve been jumping back into some of the online forums. Last summer I posted
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.