Beware of advice from 3rd-party tools around dropping indexes
(In this post I'm not going to name-and-shame, as I'm sure the problems will be fixed in time.) I want to warn you about unthinkingly
Menu
(In this post I'm not going to name-and-shame, as I'm sure the problems will be fixed in time.) I want to warn you about unthinkingly
(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
(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
There’s still a widely held misconception that when properly in the FULL or BULK_LOGGED recovery models that full or differential backups can truncate the log.
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
Today we've spent a lot of the day in discussions with some folks about developers vs. DBAs, and how it's often the case that the
Here’s a question I got from someone who attended our database maintenance workshop at PASS last week (paraphrased): I attended your pre-conference session on database
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
The sparse columns feature in SQL Server 2008 is generating lots of interest from people looking to deploy extensible schemas. I've seen a few questions
(Quickie post #3 while it's Kimberly's turn to lecture this morning – better pay attention now before I get into trouble) Gail asked a (paraphrased)
(Quickie post #1 while it’s Kimberly’s turn to lecture this morning…) I had a comment on my post dealing with suspect databases, saying that the
(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
Over the last few weeks I've seen (and helped correct) quite a few myths and misconceptions about index rebuild operations. There's enough now to make
Totally off-topic blog post this time. I haven’t blogged in a week as we’ve been in Chicago and Illinois for the memorial for Kimberly’s Father
Kimberly and I were presenting at our local (Redmond) .Net Developers Association on Monday and the following question came up while Kimberly was talking about
It seems like all I’ve been talking about on the forums the last couple of days is the correct order of operations in a maintenance
This has come up several times over the last few days, and is something that Kimberly and I discuss (and deplore) when we lecture –
(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.