Bug: Error: 3449 and server restart during DBCC CHECKDB

Posted on: November 18, 2014 9:24 am

Two new courses on Advanced Corruption Recovery Techniques and Maintenance Plans

Posted on: November 22, 2013 8:40 am

New online course: Detecting and Correcting Database Corruption

Posted on: September 18, 2013 8:53 am

The Accidental DBA (Day 11 of 30): Backups: Backup Storage and Retention

Posted on: June 11, 2013 8:00 am

The Accidental DBA (Day 10 of 30): Backups: Backup Testing for Validation

Posted on: June 10, 2013 8:00 am

The Accidental DBA (Day 9 of 30): Backups: Essential BACKUP Options

Posted on: June 9, 2013 8:00 am

The Accidental DBA (Day 8 of 30): Backups: Planning a Recovery Strategy

Posted on: June 8, 2013 8:00 am

The Accidental DBA (Day 7 of 30): Backups: Recovery Models and Backup Types

Posted on: June 7, 2013 8:00 am

The Accidental DBA (Day 6 of 30): Backups: Understanding RTO and RPO

Posted on: June 6, 2013 8:00 am

Easy automation of SQL Server database maintenance

Posted on: April 16, 2013 1:32 pm

Survey: what mechanism do you use for regular database maintenance?

Posted on: April 5, 2013 8:56 am

DBCC CHECKDB scalability and performance benchmarking on SSDs

Posted on: April 3, 2013 11:34 am

DBCC CHECKDB performance and computed-column indexes

Posted on: March 25, 2013 1:46 pm

Buffer pool disfavoring

Posted on: February 13, 2013 2:25 pm

Multiple log files and why they’re bad

Posted on: September 24, 2012 3:48 pm

New script: When were the sp_configure options last changed?

Posted on: April 26, 2012 11:30 am

Where are sp_configure settings stored? Another reason to backup master…

Posted on: April 26, 2012 10:15 am

Importance of how you run consistency checks

Posted on: April 5, 2012 2:07 pm

Survey: how do you run consistency checks?

Posted on: March 20, 2012 1:35 pm

Who is watching over your precious SQL Servers while you’re busy?

Posted on: September 28, 2011 8:37 am

SharePoint in a SQL Server environment

Posted on: August 22, 2011 10:31 am

Survey: do you have SharePoint in your SQL environment?

Posted on: August 4, 2011 1:33 pm

SharePoint 2010 database maintenance whitepaper

Posted on: July 26, 2011 8:52 am

Performance issues from wasted buffer pool memory

Posted on: June 1, 2011 10:13 am

Survey: how much server memory is being wasted? (code to run)

Posted on: April 15, 2011 8:52 am

Tempdb configuration survey results and advice

Posted on: March 9, 2011 10:42 am

Updated database size survey results

Posted on: February 22, 2011 1:22 pm

Survey: what’s the largest SQL Server database at your company?

Posted on: February 14, 2011 12:11 pm

Importance of network latency when using database mirroring

Posted on: February 8, 2011 10:02 am

Holiday special offer on maintenance+operations audits

Posted on: December 20, 2010 10:37 am

TechNet Magazine Article: Top-10 Secrets of a SQL Server Expert

Posted on: November 1, 2010 7:36 pm

TechNet Magazine: May 2010 SQL Q&A column

Posted on: May 9, 2010 12:46 pm

A SQL Server DBA myth a day: (30/30) backup myths

Posted on: April 30, 2010 9:19 am

Paul and Kimberly interview from MVP Summit

Posted on: April 29, 2010 12:45 pm

A DBA myth a day: (13/30) you cannot run DMVs when in the 80 compat mode (T-SQL Tuesday #005)

Posted on: April 13, 2010 10:40 am

Important things for DBAs to consider

Posted on: April 12, 2010 4:31 pm

Inside sys.dm_db_index_physical_stats

Posted on: March 9, 2010 10:18 am

In the news: our maintenance audits get rave reviews

Posted on: March 9, 2010 8:23 am

New script: is that database REALLY in the FULL recovery mode?

Posted on: October 7, 2009 1:27 pm

DBCC CHECKFILEGROUP bug on SQL Server 2008

Posted on: September 23, 2009 1:54 am

Survey: how do you create and maintain statistics

Posted on: September 15, 2009 12:10 pm

CHECKDB From Every Angle: How to tell if data purity checks will be run?

Posted on: August 19, 2009 11:04 am

Importance of running regular consistency checks

Posted on: August 3, 2009 7:19 am

Weekly survey: how often do you run consistency checks?

Posted on: June 24, 2009 7:00 pm

Importance of data file size management

Posted on: June 24, 2009 6:55 pm

Why you should not shrink your data files

Posted on: June 24, 2009 10:02 am

Weekly survey: how do you manage your data file sizes?

Posted on: June 15, 2009 7:22 pm

Issues around DBCC CHECKDB and the use of hidden database snapshots

Posted on: June 15, 2009 12:50 pm

Backup monitoring and reporting

Posted on: June 4, 2009 10:20 am

Importance of defining and measuring SLAs

Posted on: May 30, 2009 4:00 pm

Weekly survey: maximum allowable downtime – target and actual

Posted on: May 25, 2009 1:58 pm

New script: how much data will the next log backup include?

Posted on: May 24, 2009 2:32 pm

Weekly survey: have you ever tested your disaster recovery plan?

Posted on: May 17, 2009 5:38 pm

Clustered or nonclustered index on a random GUID?

Posted on: May 14, 2009 9:34 am

A sad tale of mis-steps and corruption (from today)

Posted on: May 12, 2009 8:36 pm

Importance of having a manageable environment

Posted on: May 10, 2009 11:22 am

Misconceptions around corruptions: can they disappear?

Posted on: May 5, 2009 8:30 am

Do transactions rollback when DBCC CHECKDB runs?

Posted on: May 4, 2009 4:04 pm

Weekly survey: what’s your largest database, and how many do you manage?

Posted on: May 2, 2009 7:58 am

Importance of having the right backups

Posted on: May 2, 2009 6:32 am

TechNet Magazine: June 2009 SQL Q&A column

Posted on: May 1, 2009 8:08 am

Weekly survey: what kind of backups do you take?

Posted on: April 27, 2009 2:44 am

Physical database layout vs. database size

Posted on: April 27, 2009 12:21 am

Misconceptions around TF 1118

Posted on: April 23, 2009 9:19 pm

Why could restoring a log-shipping log backup be slow?

Posted on: April 21, 2009 5:48 pm

Inside the Storage Engine: More on the circular nature of the log

Posted on: April 21, 2009 12:42 am

SQL 2005 SP2 maintenance plan bug masking corruption

Posted on: April 15, 2009 11:54 pm

Weekly survey: does size really matter – or is it what you do with it?

Posted on: April 10, 2009 3:05 pm

Importance of proper transaction log size management

Posted on: April 10, 2009 12:21 pm

Weekly survey: transaction log size management

Posted on: April 3, 2009 9:59 am

Importance of choosing the right LOB storage technique

Posted on: April 3, 2009 8:46 am

Index rebuilds depend on stats, which are updated by index rebuilds?!?

Posted on: March 27, 2009 7:28 am

How to change a default constraint

Posted on: March 22, 2009 8:04 am

Weekly survey: method of running consistency checks

Posted on: March 21, 2009 5:20 pm

Importance of index maintenance

Posted on: March 21, 2009 3:50 pm

Weekly survey: index maintenance plan

Posted on: March 13, 2009 6:06 pm

Importance of validating backups

Posted on: March 13, 2009 5:17 pm

Great script for automating database maintenance

Posted on: March 13, 2009 10:20 am

TechNet Magazine: April 2009 SQL Q&A column

Posted on: March 11, 2009 12:57 pm

CHECKDB From Every Angle: SQL and Windows bugs around database snapshots

Posted on: March 10, 2009 1:10 pm

How can a log backup fail but a full backup succeed?

Posted on: March 7, 2009 8:57 am

Testing a new survey method: backup validation

Posted on: March 5, 2009 5:54 pm

Database settings survey

Posted on: March 5, 2009 1:32 pm

Easy monitoring of high-severity errors: create Agent alerts

Posted on: February 23, 2009 10:34 am

A little-known sign of impending doom: error 825

Posted on: February 23, 2009 10:15 am

Corruption errors: Msg 5242, Level 22

Posted on: February 13, 2009 3:33 pm

Performance impact of lots of VLFs in the transaction log

Posted on: February 9, 2009 6:18 pm

TechNet Magazine: feature article on understanding logging and recovery

Posted on: January 16, 2009 10:01 am

Comprehensive tempdb blog post series

Posted on: January 16, 2009 9:24 am

TechNet Radio interview on database corruption

Posted on: January 12, 2009 11:00 am

TechEd demo: nonclustered index corruption

Posted on: December 17, 2008 11:03 am

TechEd: 80 minute video of Corruption Survival Techniques presentation

Posted on: December 5, 2008 6:14 am

Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup

Posted on: November 26, 2008 5:43 am

Conference corruption demo scripts and example corrupt databases

Posted on: November 24, 2008 11:27 am

TechNet Magazine: October SQL Q&A column

Posted on: September 23, 2008 1:07 am

Follow-on from instant initialization privilege checking

Posted on: August 30, 2008 7:26 pm

RunAs Radio interview on being an “involuntary DBA”

Posted on: August 28, 2008 6:28 pm

Should Microsoft provide a transaction log reader tool?

Posted on: August 26, 2008 12:21 am

Search Engine Q&A #25: Why isn’t my log backup the same size as my log?

Posted on: August 25, 2008 12:23 am

SQL Server 2008: Does my database contain Enterprise-only features?

Posted on: August 23, 2008 4:06 pm

Search Engine Q&A #24: Why can’t the transaction log use instant initialization?

Posted on: August 20, 2008 7:47 pm

Can GUID cluster keys cause non-clustered index fragmentation?

Posted on: August 20, 2008 7:11 pm

Search Engine Q&A #23: My transaction log is full – now what?

Posted on: August 14, 2008 3:05 pm

Search Engine Q&A #22: Can all page types be single-page restored?

Posted on: August 11, 2008 7:32 pm

How to tell if you have instant initialization enabled?

Posted on: August 11, 2008 7:10 pm

TechNet Magazine: Effective Database Maintenance article and August SQL Q&A column

Posted on: July 8, 2008 5:35 pm

Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)

Posted on: June 8, 2008 5:12 pm

In Print: TechNet Magazine June 2008 SQL Q&A Column

Posted on: May 19, 2008 7:06 pm

Conference Questions Pot-Pourri #7: How to create Agent alerts

Posted on: April 19, 2008 3:05 pm

New script: How much of the database has changed since the last full backup?

Posted on: April 8, 2008 4:49 pm

CHECKDB From Every Angle: When did DBCC CHECKDB last run successfully?

Posted on: March 13, 2008 8:32 pm

Search Engine Q&A #17: Split a VLDB into filegroups or smaller databases for backups?

Posted on: March 13, 2008 5:41 pm

Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials

Posted on: March 12, 2008 5:23 pm

CHECKDB From Every Angle: Example DBCC CHECKDB run-times

Posted on: February 12, 2008 8:35 pm

Search Engine Q&A #10: Rebuilding Indexes and Updating Statistics

Posted on: January 27, 2008 12:01 am

Paul and Kimberly interview on RunAs Radio – What’s New in SQL Server 2008?

Posted on: December 12, 2007 6:07 pm

CHECKDB From Every Angle: Consistency Checking Options for a VLDB

Posted on: November 19, 2007 4:11 am

CHECKDB From Every Angle: How long will CHECKDB take to run?

Posted on: November 15, 2007 4:22 am

Conference Questions Pot-Pourri #5: Database snapshots, and creating a snapshot of a single filegroup

Posted on: November 14, 2007 7:32 am

CHECKDB From Every Angle: Tips and tricks for interpreting CHECKDB output

Posted on: November 14, 2007 7:07 am

Auto-shrink – turn it OFF!

Posted on: November 13, 2007 4:28 am

Conference Questions Pot-Pourri #1: Indexes, stats, corruption, and Enterprise-only features

Posted on: November 5, 2007 3:01 am

Search Engine Q&A #8: How can defragging an index break synchronous mirroring? And what happens?

Posted on: October 25, 2007 5:04 pm

More on Database Mirroring performance and index maintenance

Posted on: October 19, 2007 12:37 am

BACKUP LOG WITH NO_LOG – use, abuse, and undocumented trace flags to stop it

Posted on: October 12, 2007 5:09 pm

Indexes From Every Angle: How can you tell if an index is being used?

Posted on: October 5, 2007 1:39 am

Search Engine Q&A #2: Moving a database while Database Mirroring is running

Posted on: September 28, 2007 3:27 pm