The Curious Case of… trying to find an MDF file in a RAW disk
(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
Quite often I see questions about DBCC CHECKDB error messages along the lines of: Specifically, the part that confuses people is “Object ID 0, index ID
This post is about a disaster-recovery scenario I described in our bi-weekly newsletter a couple of weeks ago, and wanted to make sure it’s out on the web too
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
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
Last week there was a short discussion on Twitter about why PFS pages (damaged header, not individual PFS bytes) can’t be repaired (prompted by a
As Kimberly mentioned last week, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that
An interesting corruption problem cropped up on the MCM distribution list yesterday and after I figured it out, I thought it would make a good
One of the corruptions that can stymie all efforts at disaster recovery is broken boot page. If the boot page can’t be processed, the database
In the last IEHADR class we just had in Chicago, I was doing a demo of looking in the transaction log to find the point
(Check out my Pluralsight online training course: SQL Server: Detecting and Correcting Database Corruption.) This is a question that I was sent over email that
Exactly five years ago I published survey results showing target uptime SLAs and actual uptime measurements. I re-ran the survey a few weeks ago to
A couple of week ago I kicked off a survey about the extent of your experience with the DBCC WRITEPAGE command. Here are the results:
Back in 2012 I blogged about using fn_dblog and fn_dump_dblog to figure out the point at which something occurred that you’d like to restore to
It’s been a hectic January with client work and preparations for our 2014 classes so I haven’t blogged as much as I wanted, but I
My latest Pluralsight online training course went live today: SQL Server: Detecting and Correcting Database Corruption It’s 4 hours long and is the first in
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
(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
A while back I wrote a comprehensive disaster-recovery flow chart in poster form for SQL Server Magazine, and I’m very happy that it’s now being
I originally blogged a series of corruption demos and associated databases back in 2008, for use with SQL Server 2005 and 2008. Since then the
A couple of weeks ago I kicked off a survey asking how often you perform full backups of your databases. Here are the results: The
A couple of weeks ago I kicked off a survey about where you store your backups. Here are the results: The’Other’ responses are: 8 x
That's a quote from one of my favorite comedy shows, Blackadder. With Hurricane Sandy bearing down on the North East Coast of the US today,
About a month ago I kicked off a survey with some code to run to figure out how many log files your databases have (see
(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
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.
Every so often I get asked how to deal with SPID -2 and once in a blue moon I get asked about SPID -3. Neither
My latest feature article for TechNet Magazine has just been published in the April edition. It focuses on planning an HA/DR strategy within the confines
A few weeks ago I kicked off a survey about disaster recovery testing and how the plan copes with human factors. You can see the original
The recent earthquake in New Zealand and this morning's devastating earthquake and subsequent tsunami in Japan set off a lot of discussion on twitter about
(Check out my online training courses: SQL Server: Detecting and Correcting Database Corruption and SQL Server: Advanced Corruption Recovery Techniques. We can also help you with disaster recovery.) Yesterday on
Last week I kicked off a survey about the size of the largest single SQL Server database in your company – see here for the
A few days ago one of my new blog readers (a pretty smart cookie, as you'll see) sent me a tale of database catastrophe and
(Check out my online training courses: SQL Server: Detecting and Correcting Database Corruption and SQL Server: Advanced Corruption Recovery Techniques. We can also help you with disaster recovery.) As a
(Check out my online training courses: SQL Server: Detecting and Correcting Database Corruption and SQL Server: Advanced Corruption Recovery Techniques. We can also help you with disaster recovery.) One of
The 20-page whitepaper I wrote this Spring for the SQL team has just been published. This whitepaper is titled Proven SQL Server Architectures for High
(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
The very worst piece of advice I ever saw on the Internet was in response to someone asking on a SQL newsgroup ‘how can I
The November 2009 edition of TechNet Magazine is up on the web and contains my latest feature article, the second in a 3-part series on
A few weeks ago I kicked off a survey asking what kind of disaster recovery guide/run-book/plan (I'll just call it a plan from now on)
In this survey I'd like to find out what kind of disaster recovery guide/run-book/plan you have, if any. When a disaster occurs, do you just
In last week's survey I asked you two things, as a precursor to a whitepaper I'm writing for Microsoft The first question was what is
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.