Msg 602, Level 21, State 50, Line 1
(Yes, Kimberly's lecturing again…) Here's something that I've seen crop up a lot recently on corruption forums: Server: Msg 602, Level 21, State 50, Line
Menu
(Yes, Kimberly's lecturing again…) Here's something that I've seen crop up a lot recently on corruption forums: Server: Msg 602, Level 21, State 50, Line
Last week’s survey was on what kind of regular index maintenance you perform (see here for the survey) as a way of kicking off a
I'm about to start a new series of post about index fragmentation and removing it. For this week's survey, I'd like to know what index
Last week I kicked off the first weekly survey – on whether you validate your backups or not (see here for the survey). The results
Ola Hallengren, who we meet every so often at SQL Connections, has a great script that helps automate consistency checking, backups, and index maintenance. He's
This is an interesting case that cropped up yesterday – the transaction log is damaged so a log backup doesn’t work (with the error below):
We’re doing some research into database settings that people use and the best way to get a good variety of systems is to ask you
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
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
OK – last content post today. I forgot that the February TechNet Magazine also has the latest edition of my regular SQL Q&A column. This
Wow – today is all about new content. As if I haven't already blogged about enough stuff to keep you reading through next week, the
Well, we're back from vacation finally (only for 10 days and then off to India and Thailand for 3 weeks… phew) and I've got a
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
I got bored on the first leg of the journey from Seattle to London so thought I’d bang out a quick blog post. After my
(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
On Tuesday I recorded a couple of sessions with Richard and Greg on RunAs Radio. It’s been a while since either Kimberly or I have been
Well, we’re just back from vacation (photo blog post to follow) and I’ve heard that the feature article on Effective Database Maintenance I wrote for the
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.