Archive

• Auditing
• Backup/Restore
• Bad Advice
• Benchmarking
• BlogEngine.NET
• Books
• Buffer Pool
• Bugfixes
• Career
• Change Data Capture
• CHECKDB From Every Angle
• Checkpoint
• Classes
• Compression
• Conference Questions Pot-Pourri
• Conferences
• Constraints
• Consulting
• Corruption
• Database Maintenance
• Database Mirroring
• Database Snapshots
• DBCC
• Disaster Recovery
• Electronics
• Encryption
• Example Scripts
• Extended Events
• Failover Clusters
• FILESTREAM
• Fragmentation
• Fusion-io
• General
• Hardware
• High Availability
• Indexes From Every Angle
• Inside the Storage Engine
• Install / Setup
• Instant Initialization
• Interviews
• Involuntary DBA
• IO Subsystems
• Jokes
• Latches
• LOB data
• Locking
• Log Shipping
• MCM
• Memory
• Misconceptions
• On-Disk Structures
• Page Checksums
• Partial Database Availability
• Partitioning
• Performance Tuning
• Personal
• Photography
• Policy Based Management
• Products
• Query Processor
• Query Tuning
• Repair
• Replication
• Resource Governor
• Search Engine Q and A
• Security
• Sharepoint
• Shrink
• Snapshot Isolation
• Sparse Columns
• Spinlocks
• SQL Agent
• SQL Server 2008
• SQL Server Magazine
• SQLIOSim
• SSDs
• Statistics
• Surveys
• TechNet Magazine
• tempdb
• TGIF
• Tools
• Trace Flags
• Training
• Transaction Log
• T-SQL Tuesday
• Undocumented commands
• Wait Stats
• Webcasts
• Where In The World Are Paul And Kimberly
• Whitepapers
• Uncategorized

Auditing (6)

Date	Title	Comments	Rating
2010-12-20	Holiday special offer on maintenance+operations audits	0	None
2010-03-09	In the news: our maintenance audits get rave reviews	0	None
2010-01-19	Remote DB maintenance auditing promotion	3	None
2009-03-02	New whitepaper on SQL Server Audit in 2008	0	None
2008-03-05	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 1	0	None
2008-02-15	SQL Server 2008 JumpStart	0	None

Backup/Restore (66)

Date	Title	Comments	Rating
2011-08-25	SQL Server Magazine: feature article on using database repair	0	None
2011-07-21	TechNet Magazine: July 2011 SQL Q&A column	0	None
2011-05-24	SQL Server Magazine: feature article on advanced BACKUP and RESTORE options	2	None
2010-06-18	Disaster recovery 101: backing up the tail of the log	7	None
2010-06-03	Presenting for PASS DBA virtual chapter June 9th	1	None
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2010-04-27	A SQL Server DBA myth a day: (27/30) use BACKUP WITH CHECKSUM to replace DBCC CHECKDB	11	None
2010-04-24	A SQL Server DBA myth a day: (24/30) twenty six restore myths	8	None
2010-04-20	A SQL Server DBA myth a day: (20/30) restarting a log backup chain requires a full database backup	4	None
2010-03-05	TechNet Magazine: March 2010 SQL Q&A column	0	None
2010-01-04	TechNet Magazine: January 2010 SQL Q&A column	3	None
2009-12-09	What can cause log reads and other transaction log questions	8	None
2009-11-05	TechNet Magazine: feature article on recovering from disasters using backups	2	None
2009-10-07	New script: is that database REALLY in the FULL recovery mode?	2	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-06-05	TechNet Magazine: Feature article on backups and backup strategy	3	None
2009-06-04	Backup monitoring and reporting	0	None
2009-05-29	Misconceptions around the log and log backups: how to convince yourself	8	None
2009-05-24	New script: how much data will the next log backup include?	0	None
2009-05-17	Weekly survey: have you ever tested your disaster recovery plan?	1	None
2009-05-02	Importance of having the right backups	9	None
2009-04-27	Weekly survey: what kind of backups do you take?	0	None
2009-04-21	Why could restoring a log-shipping log backup be slow?	1	None
2009-04-10	Importance of proper transaction log size management	10	None
2009-03-25	Is running repair on msdb safe?	2	None
2009-03-25	Msg 602, Level 21, State 50, Line 1	1	None
2009-03-23	Measuring 'churn' in a SharePoint content database using SQL Server	0	None
2009-03-13	Importance of validating backups	7	None
2009-03-07	How can a log backup fail but a full backup succeed?	3	None
2009-03-05	Testing a new survey method: backup validation	0	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-01-16	TechNet Magazine: February 2009 SQL Q&A column	0	None
2008-11-26	Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup	6	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-11-12	TechNet Magazine: December 2008 SQL Q&A column	0	None
2008-11-11	Conference Questions Pot-Pourri #9: Q&A around compression features	2	None
2008-10-29	High-end backup compression numbers	4	None
2008-10-26	Planning a backup strategy - where to start?	0	None
2008-09-23	TechNet Magazine: October SQL Q&A column	4	None
2008-08-25	Search Engine Q&A #25: Why isn't my log backup the same size as my log?	1	None
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	4	None
2008-08-14	Search Engine Q&A #23: My transaction log is full - now what?	0	None
2008-08-11	Search Engine Q&A #22: Can all page types be single-page restored?	1	None
2008-08-11	How to tell if you have instant initialization enabled?	4	None
2008-07-08	TechNet Magazine: Effective Database Maintenance article and August SQL Q&A column	1	None
2008-06-08	Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)	6	None
2008-04-08	New script: How much of the database has changed since the last full backup?	9	None
2008-03-13	Search Engine Q&A #17: Split a VLDB into filegroups or smaller databases for backups?	0	None
2008-02-21	Search Engine Q&A #16: Concurrent log and full backups	4	None
2008-02-15	SQL Server 2008 JumpStart	0	None
2008-02-05	Search Engine Q&A #15: Mirrored backups	1	None
2008-01-31	More on how much transaction log a full backup includes	4	None
2008-01-09	SQL Server 2008: Backup Compression CPU Cost	7	None
2007-12-23	Patents and parties	0	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-10-30	Fed up with BACKUP success messages bloating your error logs?	0	None
2007-10-25	Debunking a couple of myths around full database backups	8	None
2007-10-15	BACKUP WITH COPY_ONLY - how to avoid breaking the backup chain	7	None
2007-10-12	SQL Server 2008: What's been removed in this version? BACKUP LOG WITH NO_LOG for one!	0	None
2007-10-12	BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it	22	None
2007-10-10	Search Engine Q&A #7: Restoring from a backup file containing multiple database backups	0	None
2007-10-06	How does daylight savings time affect disaster recovery?	4	None
2007-10-06	Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup	1	None
2007-10-03	Inside the Storage Engine: Anatomy of an extent	1	None
2007-09-20	SQL Server 2008: Backup Compression	4	None
2007-09-04	Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors	6	None

Bad Advice (22)

Date	Title	Comments	Rating
2011-04-04	Beware of advice from 3rd-party tools around dropping indexes	2	None
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2009-06-24	Why you should not shrink your data files	20	None
2009-05-29	Misconceptions around the log and log backups: how to convince yourself	8	None
2009-05-15	Misconceptions around database repair	5	None
2009-05-12	A sad tale of mis-steps and corruption (from today)	8	None
2009-03-25	Is running repair on msdb safe?	2	None
2009-03-04	Mandatory SQL breathalyzer test	4	None
2008-11-26	Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup	6	None
2008-11-25	Corruption survival techniques - useless?	8	None
2008-10-19	Sparse columns: misleading info in Books Online	0	None
2008-09-02	Can the hack-the-suspect-database-into-the-server trick work for corrupt file headers?	1	None
2008-09-02	Better behavior with suspect databases in SQL Server 2008	0	None
2008-08-29	Creating, detaching, re-attaching, and fixing a suspect database	15	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	2	None
2008-06-08	Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)	6	None
2008-05-30	Backups, trains, birds, and painfully contrived movie plots	0	None
2008-05-14	How hard is it to pick the right non-clustered indexes?	7	None
2008-01-27	Search Engine Q&A #10: Rebuilding Indexes and Updating Statistics	10	None
2007-10-12	BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it	22	None
2007-09-15	Corruption: Last resorts that people try first...	0	None
2007-09-13	Common bad advice around disaster recovery	0	None

Benchmarking (14)

Date	Title	Comments	Rating
2011-05-24	Benchmarking: Multiple data files on SSDs (plus the latest Fusion-io driver)	19	None
2010-08-10	Benchmarking: Introducing SSDs (Part 3: random inserts with wait stats details)	1	None
2010-07-09	Benchmarking: Introducing SSDs (Part 2: sequential inserts)	10	None
2010-06-22	Benchmarking: do multiple data files make a difference?	14	None
2010-05-10	Benchmarking: Introducing SSDs (Part 1b: not overloaded log file array)	10	None
2010-05-06	Benchmarking: Introducing SSDs (Part 1: not overloaded log file array)	12	None
2010-03-25	Benchmarking: 1-TB table population (part 5: network optimization again)	8	None
2010-03-08	Benchmarking: 1-TB table population (part 4: network optimization)	6	None
2010-03-03	New hardware to play with: Fusion-io SSDs	20	None
2010-02-15	Benchmarking: 1-TB table population (part 3: separating data and log files)	10	None
2010-01-27	Benchmarking: 1-TB table population (part 2: optimizing log block IO size and how log IO works)	28	None
2010-01-21	Benchmarking: 1-TB table population (part 1: the baseline)	30	None
2010-01-18	Interesting case of watching log file growth during a perf test	4	None
2009-12-01	Benchmarking hardware setup	14	None

BlogEngine.NET (0)

Date	Title	Comments	Rating

Books (10)

Date	Title	Comments	Rating
2011-12-30	2011: the year in books	4	None
2010-12-31	2010: the year in books	0	None
2010-10-19	Myths and misconceptions: 60-page PDF of blog posts	12	None
2009-12-30	Once in a lifetime: 100 books in a year	25	None
2009-12-18	So you want to write a Storage Engine...	17	None
2009-10-08	SQL Server MVP Deep Dives book available to order	1	None
2009-03-11	Our book has been published!	1	None
2009-01-16	Daily SQL Server 2008 tips from TechNet Magazine	0	None
2008-11-25	Finished my seminal work on DBCC CHECKDB	3	None
2008-10-19	SQL Server 2008 Internals available to pre-order on Amazon.com	2	None

Buffer Pool (3)

Date	Title	Comments	Rating
2011-10-19	Page Life Expectancy isn't what you think...	16	None
2011-06-01	Performance issues from wasted buffer pool memory	9	None
2008-08-26	Inside the Storage Engine: What's in the buffer pool?	5	None

Bugfixes (13)

Date	Title	Comments	Rating
2011-03-29	(Not a) CHECKDB error "Unable to deallocate a kept page"	1	None
2010-01-25	DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6	2	None
2010-01-13	Diskeeper 10 Intelliwrite corruption bug	5	None
2009-12-03	Interesting 2008 partitioned view perf bug fixed in SP1 CU4	1	None
2009-12-02	2005 corruption bug with XML index rebuild fixed in latest CU	1	None
2009-05-06	What is FSAgent.exe and why does it have lots of waits?	0	None
2009-04-30	Performance bug: NOLOCK scans involving off-row LOB data	12	None
2009-04-26	MS announces support for 'lock pages in memory' for Standard Edition	0	None
2009-04-15	SQL 2005 SP2 maintenance plan bug masking corruption	0	None
2009-04-07	SQL Server 2008 SP1 has been released	0	None
2009-03-10	Couple of LOB corruption bugs fixed in the latest CUs for 2005	0	None
2009-02-24	Rolling upgrade using database mirroring (and a bug in 2008 RTM)	2	None
2009-02-23	Couple of nasty FILESTREAM bugs fixed in 2008 RTM CU1	0	None

Career (10)

Date	Title	Comments	Rating
2011-12-20	Video recording of PASS session on communication skills available	5	None
2011-12-08	December 15th PASS online lecture on communications skills	0	None
2011-11-11	SQLskills community mentoring	11	None
2011-08-04	RTFM. No seriously, R.T.F.M. Then ask your question.	31	None
2011-07-14	It depends. It really, really does.	22	None
2011-06-30	Ignorance is not stupidity	33	None
2011-05-20	The most important consulting skill is... effective communication	13	None
2011-05-04	Salary survey results - are YOU being paid enough?	5	None
2011-04-19	Anonymous survey: salaries in the SQL Server world	0	None
2011-04-19	Job security, loyalty, and employee retention: you need to take control	7	None

Change Data Capture (8)

Date	Title	Comments	Rating
2011-11-17	Vacation...	0	None
2009-12-09	What can cause log reads and other transaction log questions	8	None
2009-02-15	New whitepaper on tuning Change Data Capture performance	0	None
2008-12-03	SQL Server 2008: Using Change Data Capture with SSIS	2	None
2008-10-14	TechNet Magazine: Article on Tracking Changes in Your Enterprise Database	0	None
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	4	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-02-15	SQL Server 2008 JumpStart	0	None

CHECKDB From Every Angle (46)

Date	Title	Comments	Rating
2011-09-23	How does DBCC CHECKDB WITH ESTIMATEONLY work?	6	None
2011-03-29	(Not a) CHECKDB error "Unable to deallocate a kept page"	1	None
2010-04-27	A SQL Server DBA myth a day: (27/30) use BACKUP WITH CHECKSUM to replace DBCC CHECKDB	11	None
2010-04-02	A SQL Server DBA myth a day: (2/30) DBCC CHECKDB causes blocking	3	None
2010-02-26	Sample corrupt databases to play with	11	None
2010-01-25	DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6	2	None
2010-01-13	Diskeeper 10 Intelliwrite corruption bug	5	None
2009-09-26	TechNet Magazine: October 2009 SQL Q&A column	0	None
2009-09-23	DBCC CHECKFILEGROUP bug on SQL Server 2008	1	None
2009-08-19	CHECKDB From Every Angle: How to tell if data purity checks will be run?	6	None
2009-08-03	Importance of running regular consistency checks	4	None
2009-06-24	Weekly survey: how often do you run consistency checks?	0	None
2009-06-15	Issues around DBCC CHECKDB and the use of hidden database snapshots	1	None
2009-05-15	Misconceptions around database repair	5	None
2009-05-12	How to get all the corruption messages from CHECKDB	6	None
2009-05-04	Do transactions rollback when DBCC CHECKDB runs?	2	None
2009-03-27	Importance of how you run consistency checks	3	None
2009-03-25	Is running repair on msdb safe?	2	None
2009-03-22	IAM page corruption examples	1	None
2009-03-11	Our book has been published!	1	None
2009-03-11	TechNet Magazine: April 2009 SQL Q&A column	0	None
2009-03-10	CHECKDB From Every Angle: SQL and Windows bugs around database snapshots	0	None
2009-02-13	Corruption errors: Msg 5242, Level 22	0	None
2008-12-17	TechEd demo: nonclustered index corruption	1	None
2008-12-05	TechEd: 80 minute video of Corruption Survival Techniques presentation	0	None
2008-11-30	TechEd demo: corruptions fatal to DBCC CHECKDB	0	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-11-06	Corruption bug that people are hitting: Msg 8914 - PFS free space	6	None
2008-10-19	SQL Server 2008 Internals available to pre-order on Amazon.com	2	None
2008-08-29	Creating, detaching, re-attaching, and fixing a suspect database	15	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	2	None
2008-06-12	Using the Dedicated Admin Connection to fix Msg 8992: corrupt system tables	13	None
2008-06-09	CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete	6	None
2008-05-22	CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216	6	None
2008-03-13	CHECKDB From Every Angle: When did DBCC CHECKDB last run successfully?	5	None
2008-02-12	CHECKDB From Every Angle: Example DBCC CHECKDB run-times	0	None
2008-02-04	Search Engine Q&A #14: Beware 3rd party file-system drivers with DBCC CHECKDB	1	None
2007-11-19	CHECKDB From Every Angle: Consistency Checking Options for a VLDB	9	None
2007-11-16	CHECKDB From Every Angle: Can CHECKDB repair everything?	1	None
2007-11-15	CHECKDB From Every Angle: How long will CHECKDB take to run?	3	None
2007-11-14	CHECKDB From Every Angle: Tips and tricks for interpreting CHECKDB output	2	None
2007-11-06	CHECKDB From Every Angle: Why would CHECKDB run out of space?	1	None
2007-10-02	CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort	23	None
2007-09-22	CHECKDB From Every Angle: Automate your database integrity checks with SMO	7	None
2007-09-15	CHECKDB From Every Angle: Complete description of all CHECKDB stages	2	None
2007-09-15	Corruption: Last resorts that people try first...	0	None

Checkpoint (5)

Date	Title	Comments	Rating
2010-04-15	A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions	3	None
2010-01-18	Interesting case of watching log file growth during a perf test	4	None
2009-12-09	What can cause log reads and other transaction log questions	8	None
2009-10-07	What does checkpoint do for tempdb?	2	None
2009-09-27	How do checkpoints work and what gets logged	6	None

Classes (40)

Date	Title	Comments	Rating
2011-12-07	Training budget: use it or lose it - prepaid seats offer	0	None
2011-12-01	Four new Spring 2012 classes in Chicago, IL open for registration	0	None
2011-10-06	Spring 2012 classes in Tampa, FL open for registration	0	None
2011-07-13	New DBA, dev, BI classes for Fall in Chicago and Atlanta	0	None
2011-03-14	London class in June open for public registration	0	None
2011-03-07	Internals, Design, and Performance class in Chicago in May	1	None
2011-02-19	London calling...	6	None
2011-02-17	Leaving the Land of Confusion...	6	None
2011-02-10	My name is Kyle, and I've got SQLskills	3	None
2011-01-20	Competition: win a free place in our class in February!	40	None
2011-01-04	All MCM free training videos now available	6	None
2010-12-16	2011 comprehensive training curriculum, schedule, and details announced	0	None
2010-11-11	Configuring SSMS for presenting	10	None
2010-10-06	Last call for the 5 day comprehensive BI course in two weeks!	0	None
2010-09-17	SQL Immersion Event in San Diego, CA in December!	0	None
2010-08-24	BI Immersion Event in Bellevue, WA in October!	0	None
2010-08-15	Student comments from our class last week	5	None
2010-07-09	August SQL class filling up fast - space still available!	0	None
2010-06-23	Last call for Ireland SQL classes next week	4	None
2010-06-03	Presenting for PASS DBA virtual chapter June 9th	1	None
2010-05-20	SQL Immersion Event in Bellevue, WA in August!	0	None
2010-05-16	Special one day SQL MasterClass in London June 17th	2	None
2010-04-20	Three public classes in Dublin in June and July, with testimonials	2	None
2010-03-03	Still some spots available on the 5-day class in Boston in 3 weeks	5	None
2010-01-04	Date changes for SQL Connections and Boston public class	0	None
2009-12-09	Paul and Kimberly public class in Boston April 2010	1	None
2009-10-07	Australian classes start next week, and the Fall conferences	0	None
2009-10-07	Demo scripts from Ireland SQL Immersion Event uploaded	0	None
2009-09-01	Ireland SQL User Group September 23rd	1	None
2009-08-19	Fall line-up of classes and conferences	2	None
2009-07-10	Public SQL Server Immersion Event in Dublin in September	2	None
2009-01-29	Coming up fast: SQL Connections Spring 2009 - indexes!	0	None
2008-11-25	SQLskills.com.au and classes in Australia 2009	0	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-09-01	Last chance to register for our class in Scotland next week	0	None
2008-08-11	BI classes in Iceland in September	0	None
2008-08-11	User groups and classes in August and September	0	None
2008-07-10	2008 Conferences: TechEd EMEA, SQL Connections, PASS Community Summit	0	None
2008-07-10	Dev Connections SQL Power Workshop on SQL Server 2008, October, San Francisco	0	None
2008-06-23	Public classes in the UK in September	0	None

Compression (9)

Date	Title	Comments	Rating
2010-11-09	Big changes to the MCM program and how SQLskills can help you	17	None
2010-11-07	San Diego SQL Immersion class has only ten seats left	0	None
2009-05-29	SQL Server 2008 Data Compression whitepaper published	0	None
2008-11-26	Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup	6	None
2008-11-11	Conference Questions Pot-Pourri #9: Q&A around compression features	2	None
2008-09-10	Dev Connections newsletter	0	None
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	4	None
2008-02-15	SQL Server 2008 JumpStart	0	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None

Conference Questions Pot-Pourri (10)

Date	Title	Comments	Rating
2008-11-26	Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup	6	None
2008-11-11	Conference Questions Pot-Pourri #9: Q&A around compression features	2	None
2008-11-10	Conference Questions Pot-Pourri #8: How to move constraint indexes?	1	None
2008-04-19	Conference Questions Pot-Pourri #7: How to create Agent alerts	0	None
2007-11-16	Conference Questions Pot-Pourri #6: How to cope with losing the mirror AND the witness in a mirroring session?	2	None
2007-11-14	Conference Questions Pot-Pourri #5: Database snapshots, and creating a snapshot of a single filegroup	2	None
2007-11-09	Conference Questions Pot-Pourri #4: How many databases can you really mirror per instance?	1	None
2007-11-06	Conference Questions Pot-Pourri #3: unexpected index rebuild results and bulk-logged operations	3	None
2007-11-05	Conference Questions Pot-Pourri #2: Database mirroring	0	None
2007-11-05	Conference Questions Pot-Pourri #1: Indexes, stats, corruption, and Enterprise-only features	1	None

Conferences (51)

Date	Title	Comments	Rating
2011-07-24	SQLskills at PASS and Connections in October	0	None
2011-05-14	Connections conferences in Germany and UK in June	2	None
2011-01-19	PASS Performance VC recording and slides on index fragmentation available	0	None
2011-01-19	SQLskills.com takes 5 of the top-10 sessions at PASS 2010	3	None
2011-01-17	SQLskills crew at SQL Connections in March	0	None
2010-11-11	Configuring SSMS for presenting	10	None
2010-10-13	SQL Connections Spring 2011: Call for Abstracts	0	None
2010-07-09	We'll be at PASS in November - will you?	2	None
2010-04-19	SQL Connections Fall 2010: Call for Abstracts	0	None
2010-01-04	Date changes for SQL Connections and Boston public class	0	None
2009-12-03	SQLskills crew at Spring conferences	0	None
2009-11-16	SQL PASS interview with Jen and Sean McCown	2	None
2009-11-14	SQL Connections Fall resources uploaded	0	None
2009-11-10	Australia and PASS resources and wrapup	1	None
2009-11-01	Busy week coming up at the 2009 PASS Summit	1	None
2009-10-07	Australian classes start next week, and the Fall conferences	0	None
2009-08-19	Fall line-up of classes and conferences	2	None
2009-05-28	Paul and Kimberly will be at PASS in November	1	None
2009-03-15	SQL Connections Fall 2009: Call for Abstracts	2	None
2009-01-29	Coming up fast: SQL Connections Spring 2009 - indexes!	0	None
2008-12-17	TechEd demo: nonclustered index corruption	1	None
2008-12-05	TechEd: 80 minute video of Corruption Survival Techniques presentation	0	None
2008-11-30	TechEd demo: corruptions fatal to DBCC CHECKDB	0	None
2008-11-25	Paul and Kimberly TechNet Radio interview from PASS	0	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-11-24	Conference season over and all the scripts are posted	0	None
2008-09-10	Dev Connections newsletter	0	None
2008-08-13	SQL Connections Spring 2009: Call for Abstracts	0	None
2008-07-21	TechEd Online Panel Video: Building a Solid High-Availability Strategy	0	None
2008-07-10	2008 Conferences: TechEd EMEA, SQL Connections, PASS Community Summit	0	None
2008-07-10	Dev Connections SQL Power Workshop on SQL Server 2008, October, San Francisco	0	None
2008-06-19	Another year, another TechEd over...	0	None
2008-06-12	Using the Dedicated Admin Connection to fix Msg 8992: corrupt system tables	13	None
2008-06-05	Off to TechEd US ITPro tomorrow!	0	None
2008-04-23	Feedback on SQL Connections?	0	None
2008-03-10	SQL Server Magazine Connections Fall 2008 Call For Abstracts	0	None
2008-02-25	Conferences coming up: SQL Connections in April and TechEd US in June	0	None
2008-02-15	SQL Server 2008 JumpStart	0	None
2008-01-03	Coming up soon: SQL Server Magazine Spring 2008 Conference	0	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-11-20	Downtime...	2	None
2007-11-18	Conference season over again - phew!	0	None
2007-11-18	Kimberly & Paul interview with SSWUG TV	0	None
2007-11-13	Kimberly & Paul interview from TechEd IT Forum	0	None
2007-11-05	Conference Questions Pot-Pourri #1: Indexes, stats, corruption, and Enterprise-only features	1	None
2007-11-03	And we're off - Fall conference season begins!	1	None
2007-10-21	Conferences: updated events page listing *ALL* the team's sessions for November	3	None
2007-10-05	SQL Server Magazine Connections Spring 2008 Call For Presentations	0	None
2007-10-04	Coming to Connections in November? Send us your questions and win a prize!	0	None
2007-10-03	Coming up soon: TechEd IT Forum 2007	0	None
2007-09-19	Coming up soon: SQL Server Magazine Connections conference	0	None

Constraints (4)

Date	Title	Comments	Rating
2010-10-07	Programmatically picking apart foreign-key constraints	6	None
2009-03-22	How to change a default constraint	3	None
2008-11-10	Conference Questions Pot-Pourri #8: How to move constraint indexes?	1	None
2007-12-05	Search Engine Q&A #9: How to update constraints?	0	None

Consulting (7)

Date	Title	Comments	Rating
2011-12-20	Video recording of PASS session on communication skills available	5	None
2011-09-30	SQLskills hires deep technical expert Joseph Sack	18	None
2011-09-28	Who is watching over your precious SQL Servers while you're busy?	1	None
2011-05-20	The most important consulting skill is... effective communication	13	None
2010-12-20	Holiday special offer on maintenance+operations audits	0	None
2010-06-29	Brent Ozar joining SQLskills.com	22	None
2010-01-19	Remote DB maintenance auditing promotion	3	None

Corruption (63)

Date	Title	Comments	Rating
2011-03-10	Disaster recovery 101: fixing metadata corruption without a backup	0	None
2011-02-16	Unbelievable tale of disaster and recovery	34	None
2010-05-09	TechNet Magazine: May 2010 SQL Q&A column	4	None
2010-04-27	A SQL Server DBA myth a day: (27/30) use BACKUP WITH CHECKSUM to replace DBCC CHECKDB	11	None
2010-04-21	A SQL Server DBA myth a day: (21/30) corruption can be fixed by restarting SQL Server	5	None
2010-04-17	A SQL Server DBA myth a day: (17/30) page checksums	1	None
2010-04-16	A SQL Server DBA myth a day: (16/30) corruptions and repairs	2	None
2010-02-26	Sample corrupt databases to play with	11	None
2010-01-13	Diskeeper 10 Intelliwrite corruption bug	5	None
2009-12-02	2005 corruption bug with XML index rebuild fixed in latest CU	1	None
2009-08-24	Don't confuse error 823 and error 832	7	None
2009-08-19	CHECKDB From Every Angle: How to tell if data purity checks will be run?	6	None
2009-07-17	TechNet Magazine: August 2009 SQL Q&A column	3	None
2009-06-24	Weekly survey: how often do you run consistency checks?	0	None
2009-05-15	Misconceptions around database repair	5	None
2009-05-12	A sad tale of mis-steps and corruption (from today)	8	None
2009-05-05	Misconceptions around corruptions: can they disappear?	0	None
2009-04-15	SQL 2005 SP2 maintenance plan bug masking corruption	0	None
2009-03-27	Importance of how you run consistency checks	3	None
2009-03-25	Is running repair on msdb safe?	2	None
2009-03-25	Msg 602, Level 21, State 50, Line 1	1	None
2009-03-22	IAM page corruption examples	1	None
2009-03-11	TechNet Magazine: April 2009 SQL Q&A column	0	None
2009-03-10	Couple of LOB corruption bugs fixed in the latest CUs for 2005	0	None
2009-03-07	How can a log backup fail but a full backup succeed?	3	None
2009-02-23	A little-known sign of impending doom: error 825	3	None
2009-02-13	Corruption errors: Msg 5242, Level 22	0	None
2009-01-12	TechNet Radio interview on database corruption	0	None
2008-12-17	TechEd demo: nonclustered index corruption	1	None
2008-12-05	TechEd: 80 minute video of Corruption Survival Techniques presentation	0	None
2008-11-30	TechEd demo: corruptions fatal to DBCC CHECKDB	0	None
2008-11-25	Corruption survival techniques - useless?	8	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-11-14	Corruption bug that people are hitting - Msg 2511 using DBCC DBREINDEX	0	None
2008-11-06	Corruption bug that people are hitting: Msg 8914 - PFS free space	6	None
2008-09-02	Can the hack-the-suspect-database-into-the-server trick work for corrupt file headers?	1	None
2008-09-02	Why does the buffer pool contain so many dirty tempdb pages?	2	None
2008-09-02	Better behavior with suspect databases in SQL Server 2008	0	None
2008-08-29	Creating, detaching, re-attaching, and fixing a suspect database	15	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	2	None
2008-08-11	Search Engine Q&A #22: Can all page types be single-page restored?	1	None
2008-07-25	Search Engine Q&A #21: File header pages, and file header corruption	1	None
2008-07-11	Search Engine Q&A #20: Boot pages, and boot page corruption	3	None
2008-07-08	TechNet Magazine: Effective Database Maintenance article and August SQL Q&A column	1	None
2008-06-12	Using the Dedicated Admin Connection to fix Msg 8992: corrupt system tables	13	None
2008-06-09	CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete	6	None
2008-05-22	CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216	6	None
2008-05-19	In Print: TechNet Magazine June 2008 SQL Q&A Column	4	None
2008-04-19	Conference Questions Pot-Pourri #7: How to create Agent alerts	0	None
2008-03-21	Inside The Storage Engine: Does turning on page checksums discard any torn-page protection?	0	None
2008-03-13	CHECKDB From Every Angle: When did DBCC CHECKDB last run successfully?	5	None
2008-02-04	Search Engine Q&A #14: Beware 3rd party file-system drivers with DBCC CHECKDB	1	None
2007-11-16	CHECKDB From Every Angle: Can CHECKDB repair everything?	1	None
2007-11-15	CHECKDB From Every Angle: How long will CHECKDB take to run?	3	None
2007-11-14	CHECKDB From Every Angle: Tips and tricks for interpreting CHECKDB output	2	None
2007-11-05	Conference Questions Pot-Pourri #1: Indexes, stats, corruption, and Enterprise-only features	1	None
2007-10-02	CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort	23	None
2007-10-02	Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database	5	None
2007-09-27	SQL Server 2008: Automatic Page Repair with Database Mirroring	3	None
2007-09-15	Corruption: Last resorts that people try first...	0	None
2007-09-13	Common bad advice around disaster recovery	0	None
2007-09-12	How to tell if the IO subsystem is causing corruptions?	1	None
2007-09-04	Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors	6	None

Database Maintenance (113)

Date	Title	Comments	Rating
2011-09-28	Who is watching over your precious SQL Servers while you're busy?	1	None
2011-08-22	SharePoint in a SQL Server environment	5	None
2011-08-04	Survey: do you have SharePoint in your SQL environment?	0	None
2011-07-26	SharePoint 2010 database maintenance whitepaper	7	None
2011-06-01	Performance issues from wasted buffer pool memory	9	None
2011-04-15	Survey: how much server memory is being wasted? (code to run)	108	None
2011-03-09	Tempdb configuration survey results and advice	8	None
2011-02-22	Updated database size survey results	1	None
2011-02-14	Survey: what's the largest SQL Server database at your company?	6	None
2011-02-08	Importance of network latency when using database mirroring	1	None
2011-01-19	PASS Performance VC recording and slides on index fragmentation available	0	None
2010-12-20	Holiday special offer on maintenance+operations audits	0	None
2010-11-01	TechNet Magazine Article: Top-10 Secrets of a SQL Server Expert	1	None
2010-05-09	TechNet Magazine: May 2010 SQL Q&A column	4	None
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2010-04-29	Paul and Kimberly interview from MVP Summit	1	None
2010-04-13	A DBA myth a day: (13/30) you cannot run DMVs when in the 80 compat mode (T-SQL Tuesday #005)	5	None
2010-04-12	Important things for DBAs to consider	3	None
2010-03-09	Inside sys.dm_db_index_physical_stats	6	None
2010-03-09	In the news: our maintenance audits get rave reviews	0	None
2009-10-07	New script: is that database REALLY in the FULL recovery mode?	2	None
2009-09-23	DBCC CHECKFILEGROUP bug on SQL Server 2008	1	None
2009-09-15	Survey: how do you create and maintain statistics	3	None
2009-08-19	CHECKDB From Every Angle: How to tell if data purity checks will be run?	6	None
2009-08-03	Importance of running regular consistency checks	4	None
2009-06-24	Weekly survey: how often do you run consistency checks?	0	None
2009-06-24	Importance of data file size management	4	None
2009-06-24	Why you should not shrink your data files	20	None
2009-06-15	Weekly survey: how do you manage your data file sizes?	0	None
2009-06-15	Issues around DBCC CHECKDB and the use of hidden database snapshots	1	None
2009-06-04	Backup monitoring and reporting	0	None
2009-05-30	Importance of defining and measuring SLAs	0	None
2009-05-25	Weekly survey: maximum allowable downtime - target and actual	0	None
2009-05-24	New script: how much data will the next log backup include?	0	None
2009-05-17	Weekly survey: have you ever tested your disaster recovery plan?	1	None
2009-05-14	Clustered or nonclustered index on a random GUID?	11	None
2009-05-12	A sad tale of mis-steps and corruption (from today)	8	None
2009-05-10	Importance of having a manageable environment	2	None
2009-05-05	Misconceptions around corruptions: can they disappear?	0	None
2009-05-04	Do transactions rollback when DBCC CHECKDB runs?	2	None
2009-05-02	Weekly survey: what's your largest database, and how many do you manage?	0	None
2009-05-02	Importance of having the right backups	9	None
2009-05-01	TechNet Magazine: June 2009 SQL Q&A column	0	None
2009-04-27	Weekly survey: what kind of backups do you take?	0	None
2009-04-27	Physical database layout vs. database size	5	None
2009-04-23	Misconceptions around TF 1118	14	None
2009-04-21	Why could restoring a log-shipping log backup be slow?	1	None
2009-04-21	Inside the Storage Engine: More on the circular nature of the log	4	None
2009-04-15	SQL 2005 SP2 maintenance plan bug masking corruption	0	None
2009-04-10	Weekly survey: does size really matter - or is it what you do with it?	12	None
2009-04-10	Importance of proper transaction log size management	10	None
2009-04-03	Weekly survey: transaction log size management	5	None
2009-04-03	Importance of choosing the right LOB storage technique	4	None
2009-03-27	Importance of how you run consistency checks	3	None
2009-03-27	Index rebuilds depend on stats, which are updated by index rebuilds?!?	0	None
2009-03-22	How to change a default constraint	3	None
2009-03-21	Weekly survey: method of running consistency checks	0	None
2009-03-21	Importance of index maintenance	2	None
2009-03-13	Weekly survey: index maintenance plan	2	None
2009-03-13	Importance of validating backups	7	None
2009-03-13	Great script for automating database maintenance	0	None
2009-03-11	TechNet Magazine: April 2009 SQL Q&A column	0	None
2009-03-10	CHECKDB From Every Angle: SQL and Windows bugs around database snapshots	0	None
2009-03-07	How can a log backup fail but a full backup succeed?	3	None
2009-03-05	Testing a new survey method: backup validation	0	None
2009-03-05	Database settings survey	0	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-02-23	Easy monitoring of high-severity errors: create Agent alerts	3	None
2009-02-23	A little-known sign of impending doom: error 825	3	None
2009-02-13	Corruption errors: Msg 5242, Level 22	0	None
2009-02-09	Performance impact of lots of VLFs in the transaction log	0	None
2009-01-16	TechNet Magazine: feature article on understanding logging and recovery	1	None
2009-01-16	Comprehensive tempdb blog post series	0	None
2009-01-12	TechNet Radio interview on database corruption	0	None
2008-12-17	TechEd demo: nonclustered index corruption	1	None
2008-12-05	TechEd: 80 minute video of Corruption Survival Techniques presentation	0	None
2008-11-26	Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup	6	None
2008-11-25	SQLskills.com.au and classes in Australia 2009	0	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-09-23	TechNet Magazine: October SQL Q&A column	4	None
2008-08-30	Follow-on from instant initialization privilege checking	6	None
2008-08-28	RunAs Radio interview on being an "involuntary DBA"	0	None
2008-08-26	Should Microsoft provide a transaction log reader tool?	10	None
2008-08-25	Search Engine Q&A #25: Why isn't my log backup the same size as my log?	1	None
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	4	None
2008-08-20	Search Engine Q&A #24: Why can't the transaction log use instant initialization?	5	None
2008-08-20	Can GUID cluster keys cause non-clustered index fragmentation?	5	None
2008-08-14	Search Engine Q&A #23: My transaction log is full - now what?	0	None
2008-08-11	Search Engine Q&A #22: Can all page types be single-page restored?	1	None
2008-08-11	How to tell if you have instant initialization enabled?	4	None
2008-07-08	TechNet Magazine: Effective Database Maintenance article and August SQL Q&A column	1	None
2008-06-08	Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)	6	None
2008-05-19	In Print: TechNet Magazine June 2008 SQL Q&A Column	4	None
2008-04-19	Conference Questions Pot-Pourri #7: How to create Agent alerts	0	None
2008-04-08	New script: How much of the database has changed since the last full backup?	9	None
2008-03-13	CHECKDB From Every Angle: When did DBCC CHECKDB last run successfully?	5	None
2008-03-13	Search Engine Q&A #17: Split a VLDB into filegroups or smaller databases for backups?	0	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-02-12	CHECKDB From Every Angle: Example DBCC CHECKDB run-times	0	None
2008-01-27	Search Engine Q&A #10: Rebuilding Indexes and Updating Statistics	10	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-11-19	CHECKDB From Every Angle: Consistency Checking Options for a VLDB	9	None
2007-11-15	CHECKDB From Every Angle: How long will CHECKDB take to run?	3	None
2007-11-14	Conference Questions Pot-Pourri #5: Database snapshots, and creating a snapshot of a single filegroup	2	None
2007-11-14	CHECKDB From Every Angle: Tips and tricks for interpreting CHECKDB output	2	None
2007-11-13	Auto-shrink – turn it OFF!	12	None
2007-11-05	Conference Questions Pot-Pourri #1: Indexes, stats, corruption, and Enterprise-only features	1	None
2007-10-25	Search Engine Q&A #8: How can defragging an index break synchronous mirroring? And what happens?	0	None
2007-10-20	Indexes From Every Angle: Using CROSS APPLY with sys.dm_db_index_physical_stats	2	None
2007-10-19	More on Database Mirroring performance and index maintenance	1	None
2007-10-12	BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it	22	None
2007-10-05	Indexes From Every Angle: How can you tell if an index is being used?	4	None
2007-09-28	Search Engine Q&A #2: Moving a database while Database Mirroring is running	1	None

Database Mirroring (41)

Date	Title	Comments	Rating
2011-07-21	TechNet Magazine: July 2011 SQL Q&A column	0	None
2011-02-08	Importance of network latency when using database mirroring	1	None
2011-01-31	Importance of monitoring a database mirroring session	4	None
2011-01-30	Survey: database mirroring latency between servers	0	None
2011-01-24	Survey: monitoring database mirroring	1	None
2010-06-04	Whitepaper on high-availability architectures published	3	None
2010-05-09	TechNet Magazine: May 2010 SQL Q&A column	4	None
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2010-04-11	A SQL Server DBA myth a day: (11/30) database mirroring failover is instantaneous	1	None
2010-04-10	A SQL Server DBA myth a day: (10/30) database mirroring detects failures immediately	1	None
2010-04-07	A SQL Server DBA myth a day: (7/30) multiple mirrors and log shipping load delays	3	None
2010-03-05	TechNet Magazine: March 2010 SQL Q&A column	0	None
2009-12-09	What can cause log reads and other transaction log questions	8	None
2009-10-14	Things to consider when setting up database mirroring	1	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-09-26	TechNet Magazine: October 2009 SQL Q&A column	0	None
2009-08-26	Adding geo-redundancy to failover clustering	2	None
2009-08-21	SQL Quiz #5: SANs and mirroring	5	None
2009-05-01	TechNet Magazine: June 2009 SQL Q&A column	0	None
2009-02-24	Rolling upgrade using database mirroring (and a bug in 2008 RTM)	2	None
2009-01-16	TechNet Magazine: February 2009 SQL Q&A column	0	None
2008-11-12	TechNet Magazine: December 2008 SQL Q&A column	0	None
2008-11-11	Conference Questions Pot-Pourri #9: Q&A around compression features	2	None
2008-09-23	TechNet Magazine: October SQL Q&A column	4	None
2008-09-02	SQL Server2008: New whitepaper on combining transactional replication and database mirroring	0	None
2008-05-19	In Print: TechNet Magazine June 2008 SQL Q&A Column	4	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-03-05	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 1	0	None
2008-02-15	SQL Server 2008 JumpStart	0	None
2008-01-11	More new whitepapers: Database Mirroring and Log Shipping	0	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-11-16	Conference Questions Pot-Pourri #6: How to cope with losing the mirror AND the witness in a mirroring session?	2	None
2007-11-09	Conference Questions Pot-Pourri #4: How many databases can you really mirror per instance?	1	None
2007-11-05	Conference Questions Pot-Pourri #2: Database mirroring	0	None
2007-10-25	Search Engine Q&A #8: How can defragging an index break synchronous mirroring? And what happens?	0	None
2007-10-19	More on Database Mirroring performance and index maintenance	1	None
2007-10-11	SQL Server 2008: Performance boost for Database Mirroring	1	None
2007-10-01	Search Engine Q&A #3: Database mirroring failover types and partner timeouts	0	None
2007-10-01	SQL Server 2008: New Performance Counters for Database Mirroring	3	None
2007-09-28	Search Engine Q&A #2: Moving a database while Database Mirroring is running	1	None
2007-09-27	SQL Server 2008: Automatic Page Repair with Database Mirroring	3	None

Database Snapshots (16)

Date	Title	Comments	Rating
2011-07-26	Using database snapshots	2	None
2011-07-04	Survey: do you use database snapshots?	0	None
2010-05-09	TechNet Magazine: May 2010 SQL Q&A column	4	None
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2010-04-02	A SQL Server DBA myth a day: (2/30) DBCC CHECKDB causes blocking	3	None
2010-01-07	Misconceptions around database snapshots and transaction rollbacks	9	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-06-15	Issues around DBCC CHECKDB and the use of hidden database snapshots	1	None
2009-05-04	Do transactions rollback when DBCC CHECKDB runs?	2	None
2009-03-10	CHECKDB From Every Angle: SQL and Windows bugs around database snapshots	0	None
2009-02-15	New whitepaper on database snapshots	0	None
2008-05-22	CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216	6	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-02-04	Search Engine Q&A #14: Beware 3rd party file-system drivers with DBCC CHECKDB	1	None
2008-01-30	Database snapshots - when things go wrong	4	None
2007-11-14	Conference Questions Pot-Pourri #5: Database snapshots, and creating a snapshot of a single filegroup	2	None

DBCC (48)

Date	Title	Comments	Rating
2011-08-25	SQL Server Magazine: feature article on using database repair	0	None
2011-03-29	(Not a) CHECKDB error "Unable to deallocate a kept page"	1	None
2011-03-10	Disaster recovery 101: fixing metadata corruption without a backup	0	None
2010-04-27	A SQL Server DBA myth a day: (27/30) use BACKUP WITH CHECKSUM to replace DBCC CHECKDB	11	None
2010-04-02	A SQL Server DBA myth a day: (2/30) DBCC CHECKDB causes blocking	3	None
2010-02-26	Sample corrupt databases to play with	11	None
2009-08-19	CHECKDB From Every Angle: How to tell if data purity checks will be run?	6	None
2009-06-24	Weekly survey: how often do you run consistency checks?	0	None
2009-06-24	Why you should not shrink your data files	20	None
2009-06-15	Issues around DBCC CHECKDB and the use of hidden database snapshots	1	None
2009-05-15	Misconceptions around database repair	5	None
2009-05-12	A sad tale of mis-steps and corruption (from today)	8	None
2009-05-12	How to get all the corruption messages from CHECKDB	6	None
2009-05-05	Misconceptions around corruptions: can they disappear?	0	None
2009-05-04	Do transactions rollback when DBCC CHECKDB runs?	2	None
2009-03-27	Importance of how you run consistency checks	3	None
2009-03-25	Is running repair on msdb safe?	2	None
2009-03-24	DBCC PINTABLE	4	None
2009-03-22	IAM page corruption examples	1	None
2009-03-11	Our book has been published!	1	None
2009-03-11	TechNet Magazine: April 2009 SQL Q&A column	0	None
2009-03-10	CHECKDB From Every Angle: SQL and Windows bugs around database snapshots	0	None
2009-02-13	Corruption errors: Msg 5242, Level 22	0	None
2008-12-17	TechEd demo: nonclustered index corruption	1	None
2008-12-05	TechEd: 80 minute video of Corruption Survival Techniques presentation	0	None
2008-11-30	TechEd demo: corruptions fatal to DBCC CHECKDB	0	None
2008-11-25	Corruption survival techniques - useless?	8	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-10-19	SQL Server 2008 Internals available to pre-order on Amazon.com	2	None
2008-08-29	Creating, detaching, re-attaching, and fixing a suspect database	15	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	2	None
2008-07-25	Search Engine Q&A #21: File header pages, and file header corruption	1	None
2008-07-10	We're writing a book - finally!	1	None
2008-06-12	Using the Dedicated Admin Connection to fix Msg 8992: corrupt system tables	13	None
2008-06-09	CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete	6	None
2008-05-22	CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216	6	None
2008-03-13	CHECKDB From Every Angle: When did DBCC CHECKDB last run successfully?	5	None
2007-12-23	Patents and parties	0	None
2007-11-19	CHECKDB From Every Angle: Consistency Checking Options for a VLDB	9	None
2007-11-16	CHECKDB From Every Angle: Can CHECKDB repair everything?	1	None
2007-11-15	CHECKDB From Every Angle: How long will CHECKDB take to run?	3	None
2007-11-14	CHECKDB From Every Angle: Tips and tricks for interpreting CHECKDB output	2	None
2007-11-13	Auto-shrink – turn it OFF!	12	None
2007-10-02	CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort	23	None
2007-10-01	Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back	3	None
2007-09-22	CHECKDB From Every Angle: Automate your database integrity checks with SMO	7	None
2007-09-15	CHECKDB From Every Angle: Complete description of all CHECKDB stages	2	None
2007-09-15	Corruption: Last resorts that people try first...	0	None

Disaster Recovery (68)

Date	Title	Comments	Rating
2011-08-25	SQL Server Magazine: feature article on using database repair	0	None
2011-04-06	TechNet Magazine article: data protection and the corporate jigsaw puzzle	1	None
2011-03-23	Human nature is a significant hurdle to successful disaster recovery	8	None
2011-03-11	Surveys: DR plan testing and considering human nature	3	None
2011-03-10	Disaster recovery 101: fixing metadata corruption without a backup	0	None
2011-02-22	Updated database size survey results	1	None
2011-02-16	Unbelievable tale of disaster and recovery	34	None
2010-06-18	Disaster recovery 101: hack-attach a damaged database	6	None
2010-06-18	Disaster recovery 101: backing up the tail of the log	7	None
2010-06-04	Whitepaper on high-availability architectures published	3	None
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2010-04-12	Important things for DBAs to consider	3	None
2010-02-26	Sample corrupt databases to play with	11	None
2009-11-05	TechNet Magazine: feature article on recovering from disasters using backups	2	None
2009-09-15	Importance of having a good disaster recovery plan	5	None
2009-08-26	Survey: what kind of disaster recovery guide do you have?	0	None
2009-05-30	Importance of defining and measuring SLAs	0	None
2009-05-25	Weekly survey: maximum allowable downtime - target and actual	0	None
2009-05-25	Importance of testing your disaster recovery plan	3	None
2009-05-17	Weekly survey: have you ever tested your disaster recovery plan?	1	None
2009-05-15	Misconceptions around database repair	5	None
2009-05-12	A sad tale of mis-steps and corruption (from today)	8	None
2009-05-12	How to get all the corruption messages from CHECKDB	6	None
2009-05-02	Importance of having the right backups	9	None
2009-04-27	Weekly survey: what kind of backups do you take?	0	None
2009-04-27	Physical database layout vs. database size	5	None
2009-04-10	Weekly survey: does size really matter - or is it what you do with it?	12	None
2009-03-25	Is running repair on msdb safe?	2	None
2009-03-13	Importance of validating backups	7	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-01-12	TechNet Radio interview on database corruption	0	None
2008-12-17	TechEd demo: nonclustered index corruption	1	None
2008-12-05	TechEd: 80 minute video of Corruption Survival Techniques presentation	0	None
2008-11-30	TechEd demo: corruptions fatal to DBCC CHECKDB	0	None
2008-11-25	Corruption survival techniques - useless?	8	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-10-26	Planning a backup strategy - where to start?	0	None
2008-10-19	Reminder of why hardware redundancy is a good thing	0	None
2008-09-02	Can the hack-the-suspect-database-into-the-server trick work for corrupt file headers?	1	None
2008-09-02	Better behavior with suspect databases in SQL Server 2008	0	None
2008-08-29	Creating, detaching, re-attaching, and fixing a suspect database	15	None
2008-08-29	SQL Server 2008: How to rebuild the system databases?	1	None
2008-08-26	Should Microsoft provide a transaction log reader tool?	10	None
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	4	None
2008-08-11	Search Engine Q&A #22: Can all page types be single-page restored?	1	None
2008-08-11	How to tell if you have instant initialization enabled?	4	None
2008-06-12	Using the Dedicated Admin Connection to fix Msg 8992: corrupt system tables	13	None
2008-06-09	CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete	6	None
2008-05-18	Do backups apply to just digital data? And how many backups should you have?	4	None
2008-03-13	HA: Where do you start when choosing a high-availability solution?	1	None
2008-03-13	Search Engine Q&A #17: Split a VLDB into filegroups or smaller databases for backups?	0	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-02-12	CHECKDB From Every Angle: Example DBCC CHECKDB run-times	0	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-11-16	Conference Questions Pot-Pourri #6: How to cope with losing the mirror AND the witness in a mirroring session?	2	None
2007-11-16	CHECKDB From Every Angle: Can CHECKDB repair everything?	1	None
2007-11-15	CHECKDB From Every Angle: How long will CHECKDB take to run?	3	None
2007-11-14	CHECKDB From Every Angle: Tips and tricks for interpreting CHECKDB output	2	None
2007-10-15	BACKUP WITH COPY_ONLY - how to avoid breaking the backup chain	7	None
2007-10-12	BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it	22	None
2007-10-11	SQL Server 2008: Performance boost for Database Mirroring	1	None
2007-10-10	Search Engine Q&A #7: Restoring from a backup file containing multiple database backups	0	None
2007-10-06	How does daylight savings time affect disaster recovery?	4	None
2007-10-02	CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort	23	None
2007-10-02	Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database	5	None
2007-09-15	Corruption: Last resorts that people try first...	0	None
2007-09-13	Common bad advice around disaster recovery	0	None
2007-09-04	Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors	6	None

Electronics (2)

Date	Title	Comments	Rating
2011-03-07	Nixie tube clock	3	None
2009-06-02	I like it when people send me electronics	1	None

Encryption (6)

Date	Title	Comments	Rating
2009-04-03	TechNet Magazine: feature article on Common SQL Server Security Issues and Solutions	0	None
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	4	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-03-05	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 1	0	None
2008-02-15	SQL Server 2008 JumpStart	0	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None

Example Scripts (60)

Date	Title	Comments	Rating
2011-11-02	Code to list index counts per table	3	None
2011-07-11	Capturing wait stats for a single operation	5	None
2011-06-01	Performance issues from wasted buffer pool memory	9	None
2011-04-13	Advanced performance troubleshooting: waits, latches, spinlocks	7	None
2011-04-11	How to examine IO subsystem latencies from within SQL Server	9	None
2010-02-26	Sample corrupt databases to play with	11	None
2010-02-01	Script: open transactions with text and plans	18	None
2009-10-07	New script: is that database REALLY in the FULL recovery mode?	2	None
2009-10-07	Demo scripts from Ireland SQL Immersion Event uploaded	0	None
2009-08-10	Forwarding and forwarded records, and the back-pointer size	1	None
2009-06-16	Finding out who dropped a table using the transaction log	17	None
2009-05-29	Misconceptions around the log and log backups: how to convince yourself	8	None
2009-05-24	New script: how much data will the next log backup include?	0	None
2009-03-23	Measuring 'churn' in a SharePoint content database using SQL Server	0	None
2009-03-22	How to change a default constraint	3	None
2009-03-19	Ghost cleanup redux	4	None
2009-03-13	Great script for automating database maintenance	0	None
2009-03-11	FILESTREAM directory structure	3	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-02-23	Getting historical deadlock info using extended events	2	None
2009-01-16	TechNet Magazine: feature article on understanding logging and recovery	1	None
2009-01-16	Comprehensive tempdb blog post series	0	None
2008-12-17	TechEd demo: nonclustered index corruption	1	None
2008-12-05	TechEd: 80 minute video of Corruption Survival Techniques presentation	0	None
2008-11-30	TechEd demo: corruptions fatal to DBCC CHECKDB	0	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-11-10	Conference Questions Pot-Pourri #8: How to move constraint indexes?	1	None
2008-08-26	Inside the Storage Engine: What's in the buffer pool?	5	None
2008-08-25	Search Engine Q&A #25: Why isn't my log backup the same size as my log?	1	None
2008-08-11	How to tell if you have instant initialization enabled?	4	None
2008-06-12	Using the Dedicated Admin Connection to fix Msg 8992: corrupt system tables	13	None
2008-05-22	CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216	6	None
2008-04-28	SQL Server 2008: Sparse columns and XML COLUMN_SET	3	None
2008-04-08	New script: How much of the database has changed since the last full backup?	9	None
2008-03-12	Inside The Storage Engine: sp_AllocationMetadata - putting undocumented system catalog views to work	3	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-02-05	Search Engine Q&A #15: Mirrored backups	1	None
2008-01-30	Database snapshots - when things go wrong	4	None
2008-01-14	SQL Server 2008: Partition-level lock escalation details and examples	10	None
2008-01-04	Katmai bug: SSMS doesn't drop database locks when leaving the context of a database	0	None
2007-12-31	Inside the Storage Engine: When do versioning tags get added?	0	None
2007-12-05	Search Engine Q&A #10: When are pages from a truncated table reused?	4	None
2007-11-13	Auto-shrink – turn it OFF!	12	None
2007-10-25	Debunking a couple of myths around full database backups	8	None
2007-10-20	Indexes From Every Angle: Using CROSS APPLY with sys.dm_db_index_physical_stats	2	None
2007-10-15	BACKUP WITH COPY_ONLY - how to avoid breaking the backup chain	7	None
2007-10-12	BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it	22	None
2007-10-10	Search Engine Q&A #7: Restoring from a backup file containing multiple database backups	0	None
2007-10-08	Inside the Storage Engine: Ghost cleanup in depth	11	None
2007-10-06	Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup	1	None
2007-10-05	Indexes From Every Angle: How can you tell if an index is being used?	4	None
2007-10-04	Inside the Storage Engine: Proof that records are not always physically stored in index key order	0	None
2007-10-02	CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort	23	None
2007-10-02	Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database	5	None
2007-10-01	Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back	3	None
2007-09-30	Inside the Storage Engine: Anatomy of a record	5	None
2007-09-28	Search Engine Q&A #2: Moving a database while Database Mirroring is running	1	None
2007-09-24	Search Engine Q&A #1: Running out of transaction log space	5	None
2007-09-22	CHECKDB From Every Angle: Automate your database integrity checks with SMO	7	None
2007-09-04	Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors	6	None

Extended Events (8)

Date	Title	Comments	Rating
2011-07-11	Capturing wait stats for a single operation	5	None
2011-04-13	How to download a sqlservr.pdb symbol file	2	None
2009-10-15	Tracking expensive queries with extended events in SQL 2008	3	None
2009-02-23	Getting historical deadlock info using extended events	2	None
2009-02-15	New whitepaper on tuning Change Data Capture performance	0	None
2008-12-05	TechNet Magazine: feature article on Advanced Troubleshooting with Extended Events	1	None
2008-03-11	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 2	0	None
2008-02-15	SQL Server 2008 JumpStart	0	None

Failover Clusters (5)

Date	Title	Comments	Rating
2010-06-04	Whitepaper on high-availability architectures published	3	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-08-26	Adding geo-redundancy to failover clustering	2	None
2009-08-03	Survey: How do you provide geo-redundancy with clustering?	0	None
2009-07-23	New whitepaper on SQL Server 2008 failover clustering	1	None

FILESTREAM (17)

Date	Title	Comments	Rating
2010-04-18	A SQL Server DBA myth a day: (18/30) FILESTREAM storage, garbage collection, and more	1	None
2009-05-06	What is FSAgent.exe and why does it have lots of waits?	0	None
2009-05-06	Misconceptions around FILESTREAM storage	0	None
2009-04-21	FILESTREAM garbage collection	0	None
2009-03-17	FILESTREAM directory structure - where do the GUIDs come from?	4	None
2009-03-11	FILESTREAM directory structure	3	None
2009-03-11	TechNet Magazine: April 2009 SQL Q&A column	0	None
2009-02-23	Couple of nasty FILESTREAM bugs fixed in 2008 RTM CU1	0	None
2008-10-10	SQL Server 2008 FILESTREAM whitepaper published on MSDN	5	None
2008-09-10	RunAs Radio interview on FILESTREAM	0	None
2008-08-25	High-performance FILESTREAM tips and tricks	5	None
2008-04-07	SQL Server 2008: How to get FILESTREAM and partitioning to work	0	None
2008-03-09	SQL Server 2008: FILESTREAM performance	4	None
2008-03-07	SQL Server 2008: Changes to enabling FILESTREAM from CTP-6 onwards	0	None
2008-02-15	SQL Server 2008 JumpStart	0	None
2008-02-04	SQL Server 2008: Enabling FILESTREAM through T-SQL and SSMS	0	None
2008-01-25	SQL Server 2008: FILESTREAM	0	None

Fragmentation (16)

Date	Title	Comments	Rating
2011-09-14	TechNet Magazine: September 2011 SQL Q&A column	0	None
2011-06-01	Performance issues from wasted buffer pool memory	9	None
2010-04-29	A SQL Server DBA myth a day: (29/30) fixing heap fragmentation	12	None
2010-03-09	Inside sys.dm_db_index_physical_stats	6	None
2009-12-08	Where do the Books Online index fragmentation thresholds come from?	12	None
2009-05-20	An example of a nasty cluster key	14	None
2009-05-14	Clustered or nonclustered index on a random GUID?	11	None
2009-05-12	How expensive are page splits in terms of transaction log?	7	None
2009-04-03	Importance of choosing the right LOB storage technique	4	None
2009-03-27	Index rebuilds depend on stats, which are updated by index rebuilds?!?	0	None
2009-03-22	How to change a default constraint	3	None
2009-03-21	Importance of index maintenance	2	None
2009-03-13	Weekly survey: index maintenance plan	2	None
2009-03-11	TechNet Magazine: April 2009 SQL Q&A column	0	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2008-08-20	Can GUID cluster keys cause non-clustered index fragmentation?	5	None

Fusion-io (2)

Date	Title	Comments	Rating
2010-08-10	Benchmarking: Introducing SSDs (Part 3: random inserts with wait stats details)	1	None
2010-03-03	New hardware to play with: Fusion-io SSDs	20	None

General (78)

Date	Title	Comments	Rating
2011-11-17	Vacation...	0	None
2011-11-11	SQLskills community mentoring	11	None
2011-09-30	SQLskills hires deep technical expert Joseph Sack	18	None
2011-08-11	Do yourself a favor... Trust No One	36	None
2011-08-04	RTFM. No seriously, R.T.F.M. Then ask your question.	31	None
2011-08-02	OT survey results: browsers and email clients	6	None
2011-07-20	OT Survey: internet browsers and mail readers	6	None
2011-07-14	It depends. It really, really does.	22	None
2011-07-06	Survey results on rebooting - is it good or bad?	8	None
2011-06-30	Ignorance is not stupidity	33	None
2011-06-22	The Golden Rule - maybe just optional now?	45	None
2011-05-20	The most important consulting skill is... effective communication	13	None
2011-04-23	Patent surprise	6	None
2011-04-19	Job security, loyalty, and employee retention: you need to take control	7	None
2011-04-06	Surveys: what's your company doing for you, and vice versa?	14	None
2011-03-23	Are you smart?	0	None
2011-03-20	Want a cool blue laptop sticker?	2	None
2011-02-24	Better together - the importance of great inter-team relationships	2	None
2011-02-23	SQLskills hires deep technical expert Jonathan Kehayias	22	None
2011-02-23	RunAs Radio show #200... not our most technical show...	0	None
2011-02-14	Community, community, community, community...	2	None
2011-01-30	Survey: inter-team relationships	6	None
2011-01-28	Do you run a SQL Server User Group?	1	None
2011-01-24	What's in a job title?	4	None
2011-01-08	So you want to blog about SQL Server?	30	None
2010-12-24	Our Christmas Gift To You: Paul and Kimberly Singing!	20	None
2010-12-21	Survey: what's in a job title?	40	None
2010-11-10	T-SQL Tuesday #012 : Summary of why DBA skills are necessary	2	None
2010-10-25	Invitation to participate in T-SQL Tuesday #12 – Why are DBA skills necessary?	50	None
2010-10-06	Programmatic detection of configuration options	4	None
2010-07-13	T-SQL Tuesday #008: Top ten mistakes to make when attending a class	26	None
2010-06-29	Brent Ozar joining SQLskills.com	22	None
2010-05-10	What 5 things should SQL Server get rid of?	20	None
2010-04-12	Important things for DBAs to consider	3	None
2009-12-18	So you want to write a Storage Engine...	17	None
2009-10-08	SQL Server MVP Deep Dives book available to order	1	None
2009-08-25	SQL Server 2008 R2 bumps the database version	4	None
2009-08-21	Goals, obsessions, and aspirations: becoming an MVP	8	None
2009-08-10	Comments are moderated now	1	None
2009-06-05	Desert Island Disks	4	None
2009-05-30	Blog post 350 on this blog - vive la communite!	6	None
2009-05-17	Importance of choosing the right architecture and SQL Server Edition	0	None
2009-05-13	Cool way to visualize word distribution in text - wordle	1	None
2009-05-13	How Twitter and social networking changed my life...	6	None
2009-05-05	Why did the Windows 7 RC download failure happen?	13	None
2009-04-29	Why isn't there automatic in SQL Server?	6	None
2009-04-29	How to find me on Twitter	0	None
2009-04-29	Ok, I caved - I'm on Twitter	6	None
2009-04-16	Are we too obsessed with rankings?	9	None
2009-04-01	Kimberly and Paul awarded MVP status again	0	None
2009-03-27	Quickie on programming equality tests	0	None
2009-03-23	New Microsoft Regional Director - Paul Randal	11	None
2009-03-15	Things you know now	4	None
2009-03-08	What's a valid question for a DBA interview?	4	None
2009-03-05	Is SQL Server 'just plumbing'?	2	None
2009-03-04	Mandatory SQL breathalyzer test	4	None
2009-03-03	Common questions from newsgroups and forums	0	None
2009-03-03	Website/blog problems	0	None
2009-02-14	Public Speaking: A Primer	6	None
2008-10-14	Admin: Blog engine has been updated	0	None
2008-10-06	Admin: Our blogs are moving to a new engine 10/8 - 10/10	0	None
2008-04-17	Search Engine Q&A #18: What's the current uptime of SQL Server?	7	None
2008-04-01	Paul Randal awarded SQL Server MVP for 2008	9	None
2008-04-01	SQLskills.com Announces Time-Setback Technology for DBAs	2	None
2008-03-31	RSS feed refresh - please back off a bit (Brazil and Korea)	2	None
2008-02-19	Administrivia	1	None
2008-02-14	Wow - so many blogs!	0	None
2008-02-07	Updated aggregated feeds	0	None
2008-01-29	Search Engine Q&A #13: Difference between database version and database compatibility level	0	None
2008-01-29	The frustration of sweeping generalizations - follow on from Search Engine Q&A #12	5	None
2008-01-28	Search Engine Q&A #11: How to design a global-ready database?	2	None
2008-01-17	See? We *can* all get along...	0	None
2007-10-25	Just how long should you make character fields? What's the longest word?	6	None
2007-10-18	Admin: Comments are fixed now	0	None
2007-10-11	New additions to the SQLskills team	0	None
2007-10-10	SQL injection attacks can happen anywhere...	1	None
2007-10-09	New aggregate feeds for SQLskills blogs	0	None
2007-09-01	It's official!	5	None

Hardware (12)

Date	Title	Comments	Rating
2011-01-16	Results of CPU power saving survey	4	None
2010-11-10	T-SQL Tuesday #012 : Summary of why DBA skills are necessary	2	None
2010-08-10	Benchmarking: Introducing SSDs (Part 3: random inserts with wait stats details)	1	None
2010-03-25	Benchmarking: 1-TB table population (part 5: network optimization again)	8	None
2010-03-08	Benchmarking: 1-TB table population (part 4: network optimization)	6	None
2010-03-03	New hardware to play with: Fusion-io SSDs	20	None
2009-09-08	When was the last time you saw one of these?	3	None
2009-08-24	Don't confuse error 823 and error 832	7	None
2009-06-02	I like it when people send me electronics	1	None
2009-05-17	Importance of choosing the right architecture and SQL Server Edition	0	None
2009-05-13	Are your disk partition offsets, RAID stripe sizes, and NTFS allocation units set correctly?	1	None
2009-04-13	New research paper: Migrating Server Storage to SSDs: Analysis of Tradeoffs	3	None

High Availability (32)

Date	Title	Comments	Rating
2011-04-06	TechNet Magazine article: data protection and the corporate jigsaw puzzle	1	None
2011-02-08	Importance of network latency when using database mirroring	1	None
2011-01-31	Importance of monitoring a database mirroring session	4	None
2011-01-30	Survey: database mirroring latency between servers	0	None
2011-01-24	Survey: monitoring database mirroring	1	None
2010-11-03	In defense of transactional replication as an HA technology	13	None
2010-06-04	Whitepaper on high-availability architectures published	3	None
2010-04-12	Important things for DBAs to consider	3	None
2010-04-07	A SQL Server DBA myth a day: (7/30) multiple mirrors and log shipping load delays	3	None
2010-04-01	A SQL Server DBA myth a day: (1/30) in-flight transactions continue after a failover	7	None
2009-10-14	Things to consider when setting up database mirroring	1	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-08-26	Adding geo-redundancy to failover clustering	2	None
2009-08-03	Survey: How do you provide geo-redundancy with clustering?	0	None
2009-05-30	Importance of defining and measuring SLAs	0	None
2009-05-25	Weekly survey: maximum allowable downtime - target and actual	0	None
2009-05-17	Weekly survey: have you ever tested your disaster recovery plan?	1	None
2009-05-02	Weekly survey: what's your largest database, and how many do you manage?	0	None
2009-04-27	Physical database layout vs. database size	5	None
2009-04-21	Why could restoring a log-shipping log backup be slow?	1	None
2009-04-10	Weekly survey: does size really matter - or is it what you do with it?	12	None
2009-03-13	Importance of validating backups	7	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-02-24	Rolling upgrade using database mirroring (and a bug in 2008 RTM)	2	None
2009-01-16	TechNet Magazine: February 2009 SQL Q&A column	0	None
2008-11-12	TechNet Magazine: December 2008 SQL Q&A column	0	None
2008-10-26	Planning a backup strategy - where to start?	0	None
2008-10-19	Reminder of why hardware redundancy is a good thing	0	None
2008-09-02	SQL Server2008: New whitepaper on combining transactional replication and database mirroring	0	None
2008-08-11	How to tell if you have instant initialization enabled?	4	None
2008-07-21	TechEd Online Panel Video: Building a Solid High-Availability Strategy	0	None
2008-03-13	HA: Where do you start when choosing a high-availability solution?	1	None

Indexes From Every Angle (44)

Date	Title	Comments	Rating
2012-01-02	Survey results: How cluster key size can lead to GBs of wasted space	4	None
2011-11-08	Survey: wasted space from cluster keys (code to run)	43	None
2011-11-02	Code to list index counts per table	3	None
2011-11-01	Over and under indexing - how bad is it out there?	5	None
2011-09-14	TechNet Magazine: September 2011 SQL Q&A column	0	None
2011-08-04	Survey: nonclustered index counts (code to run)	82	None
2011-04-04	Beware of advice from 3rd-party tools around dropping indexes	2	None
2011-02-25	Do changes to index keys really do in-place updates?	0	None
2011-01-19	PASS Performance VC recording and slides on index fragmentation available	0	None
2010-05-01	Missing index DMVs bug that could cost your sanity...	18	None
2010-04-29	A SQL Server DBA myth a day: (29/30) fixing heap fragmentation	12	None
2010-04-25	A SQL Server DBA myth a day: (25/30) fill factor	7	None
2010-04-08	A SQL Server DBA myth a day: (8/30) unicorns, rainbows, and online index operations	3	None
2010-03-09	Inside sys.dm_db_index_physical_stats	6	None
2009-12-08	Where do the Books Online index fragmentation thresholds come from?	12	None
2009-07-17	TechNet Magazine: August 2009 SQL Q&A column	3	None
2009-05-20	An example of a nasty cluster key	14	None
2009-05-14	Clustered or nonclustered index on a random GUID?	11	None
2009-05-12	How expensive are page splits in terms of transaction log?	7	None
2009-03-27	Index rebuilds depend on stats, which are updated by index rebuilds?!?	0	None
2009-03-21	Importance of index maintenance	2	None
2009-03-13	Weekly survey: index maintenance plan	2	None
2009-03-11	TechNet Magazine: April 2009 SQL Q&A column	0	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2008-12-17	TechEd demo: nonclustered index corruption	1	None
2008-11-14	Corruption bug that people are hitting - Msg 2511 using DBCC DBREINDEX	0	None
2008-11-10	Conference Questions Pot-Pourri #8: How to move constraint indexes?	1	None
2008-09-30	RunAs Radio interview on indexes (and future projects...)	0	None
2008-09-10	Dev Connections newsletter	0	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	2	None
2008-08-20	Can GUID cluster keys cause non-clustered index fragmentation?	5	None
2008-08-11	User groups and classes in August and September	0	None
2008-07-10	We're writing a book - finally!	1	None
2008-06-08	Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)	6	None
2008-05-14	How hard is it to pick the right non-clustered indexes?	7	None
2008-01-27	Search Engine Q&A #10: Rebuilding Indexes and Updating Statistics	10	None
2008-01-17	SQL Server 2008: Spatial indexes	1	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-11-13	Auto-shrink – turn it OFF!	12	None
2007-11-06	Conference Questions Pot-Pourri #3: unexpected index rebuild results and bulk-logged operations	3	None
2007-11-01	Indexes From Every Angle: What indexes are necessary when using SWITCH PARTITION?	1	None
2007-10-20	Indexes From Every Angle: Using CROSS APPLY with sys.dm_db_index_physical_stats	2	None
2007-10-05	Indexes From Every Angle: How can you tell if an index is being used?	4	None
2007-10-05	Indexes From Every Angle: What happens to non-clustered indexes when the table structure is changed?	1	None

Inside the Storage Engine (48)

Date	Title	Comments	Rating
2011-09-23	How does DBCC CHECKDB WITH ESTIMATEONLY work?	6	None
2011-09-13	Initial VLF sequence numbers and default log file size	5	None
2011-02-25	Do changes to index keys really do in-place updates?	0	None
2010-04-29	A SQL Server DBA myth a day: (29/30) fixing heap fragmentation	12	None
2010-04-25	A SQL Server DBA myth a day: (25/30) fill factor	7	None
2010-04-19	A SQL Server DBA myth a day: (19/30) TRUNCATE TABLE is non-logged	7	None
2010-04-06	A SQL Server DBA myth a day: (6/30) three null bitmap myths	4	None
2010-03-09	Inside sys.dm_db_index_physical_stats	6	None
2010-01-08	Turning off the ghost cleanup task for a performance gain	12	None
2009-11-13	Lock logging and fast recovery	7	None
2009-10-07	What does checkpoint do for tempdb?	2	None
2009-09-27	How do checkpoints work and what gets logged	6	None
2009-09-08	Memory: Large Pages and MemToLeave	2	None
2009-08-19	CHECKDB From Every Angle: How to tell if data purity checks will be run?	6	None
2009-08-10	Forwarding and forwarded records, and the back-pointer size	1	None
2009-05-30	Investigating locking and deadlocking with %%lockres%%	0	None
2009-05-12	How expensive are page splits in terms of transaction log?	7	None
2009-05-04	Misconceptions around null bitmap size	5	None
2009-04-30	Performance bug: NOLOCK scans involving off-row LOB data	12	None
2009-04-23	Misconceptions around TF 1118	14	None
2009-04-21	FILESTREAM garbage collection	0	None
2009-04-21	Inside the Storage Engine: More on the circular nature of the log	4	None
2009-03-19	Ghost cleanup redux	4	None
2009-03-11	FILESTREAM directory structure	3	None
2009-03-10	Misconceptions around instant file initialization	12	None
2009-03-01	Search Engine Q&A #27: How does the storage engine find variable-length columns?	1	None
2009-01-16	TechNet Magazine: feature article on understanding logging and recovery	1	None
2009-01-16	Comprehensive tempdb blog post series	0	None
2008-11-06	Corruption bug that people are hitting: Msg 8914 - PFS free space	6	None
2008-10-19	SQL Server 2008 Internals available to pre-order on Amazon.com	2	None
2008-09-02	Why does the buffer pool contain so many dirty tempdb pages?	2	None
2008-08-26	Inside the Storage Engine: What's in the buffer pool?	5	None
2008-07-25	Search Engine Q&A #21: File header pages, and file header corruption	1	None
2008-07-11	Search Engine Q&A #20: Boot pages, and boot page corruption	3	None
2008-03-21	Inside The Storage Engine: Does turning on page checksums discard any torn-page protection?	0	None
2008-03-20	SQL Server 2008: New (undocumented) physical row locator function	10	None
2008-03-14	Inside The Storage Engine: GAM, SGAM, PFS and other allocation maps	5	None
2008-03-12	Inside The Storage Engine: sp_AllocationMetadata - putting undocumented system catalog views to work	3	None
2008-01-31	More on how much transaction log a full backup includes	4	None
2007-12-31	Inside the Storage Engine: When do versioning tags get added?	0	None
2007-12-05	Search Engine Q&A #10: When are pages from a truncated table reused?	4	None
2007-10-08	Inside the Storage Engine: Ghost cleanup in depth	11	None
2007-10-04	Inside the Storage Engine: Proof that records are not always physically stored in index key order	0	None
2007-10-04	Inside the Storage Engine: IAM pages, IAM chains, and allocation units	2	None
2007-10-03	Inside the Storage Engine: Anatomy of an extent	1	None
2007-10-03	Inside the Storage Engine: Anatomy of a page	19	None
2007-10-01	Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back	3	None
2007-09-30	Inside the Storage Engine: Anatomy of a record	5	None

Install / Setup (5)

Date	Title	Comments	Rating
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-02-24	Rolling upgrade using database mirroring (and a bug in 2008 RTM)	2	None
2009-02-23	Couple of nasty FILESTREAM bugs fixed in 2008 RTM CU1	0	None
2008-09-30	SQL Server 2008 patching has begun - and the PSS blog	0	None
2007-09-21	SQL Server 2008: On installing the latest CTP...	0	None

Instant Initialization (6)

Date	Title	Comments	Rating
2010-04-14	A SQL Server DBA myth a day: (14/30) clearing the log zeroes out log records	1	None
2010-04-03	A SQL Server DBA myth a day: (3/30) instant file initialization can be controlled from within SQL Server	3	None
2009-06-24	Importance of data file size management	4	None
2009-03-10	Misconceptions around instant file initialization	12	None
2008-08-20	Search Engine Q&A #24: Why can't the transaction log use instant initialization?	5	None
2008-08-11	How to tell if you have instant initialization enabled?	4	None

Interviews (20)

Date	Title	Comments	Rating
2011-02-23	RunAs Radio show #200... not our most technical show...	0	None
2010-07-22	RunAs Radio interview with Paul and Kimberly	0	None
2010-04-29	Paul and Kimberly interview from MVP Summit	1	None
2009-11-16	SQL PASS interview with Jen and Sean McCown	2	None
2009-09-11	10-minute TV interview with me and Kimberly, plus a big announcement	0	None
2009-06-16	Paul on .NET Rocks! again	1	None
2009-06-09	New interview of me	0	None
2009-01-16	TechNet Radio interview on partitioning (Kimberly)	0	None
2009-01-12	TechNet Radio interview on database corruption	0	None
2008-11-25	Paul and Kimberly TechNet Radio interview from PASS	0	None
2008-11-25	Life on SQL Server 2008 - PASS interview with a large-scale user	0	None
2008-09-30	RunAs Radio interview on indexes (and future projects...)	0	None
2008-09-10	RunAs Radio interview on FILESTREAM	0	None
2008-08-28	RunAs Radio interview on being an "involuntary DBA"	0	None
2008-07-21	TechEd Online Panel Video: Building a Solid High-Availability Strategy	0	None
2008-03-11	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 2	0	None
2008-03-05	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 1	0	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-11-18	Kimberly & Paul interview with SSWUG TV	0	None
2007-11-13	Kimberly & Paul interview from TechEd IT Forum	0	None

Involuntary DBA (60)

Date	Title	Comments	Rating
2011-09-28	Who is watching over your precious SQL Servers while you're busy?	1	None
2011-03-09	Tempdb configuration survey results and advice	8	None
2011-02-10	My name is Kyle, and I've got SQLskills	3	None
2011-01-19	PASS Performance VC recording and slides on index fragmentation available	0	None
2010-11-10	T-SQL Tuesday #012 : Summary of why DBA skills are necessary	2	None
2010-11-01	TechNet Magazine Article: Top-10 Secrets of a SQL Server Expert	1	None
2010-04-29	Paul and Kimberly interview from MVP Summit	1	None
2010-04-12	Important things for DBAs to consider	3	None
2010-03-09	In the news: our maintenance audits get rave reviews	0	None
2009-11-05	TechNet Magazine: feature article on recovering from disasters using backups	2	None
2009-10-07	New script: is that database REALLY in the FULL recovery mode?	2	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-09-15	Survey: how do you create and maintain statistics	3	None
2009-09-15	Importance of having a good disaster recovery plan	5	None
2009-08-26	Survey: what kind of disaster recovery guide do you have?	0	None
2009-08-03	Importance of running regular consistency checks	4	None
2009-06-24	Weekly survey: how often do you run consistency checks?	0	None
2009-06-24	Importance of data file size management	4	None
2009-06-24	Why you should not shrink your data files	20	None
2009-06-15	Weekly survey: how do you manage your data file sizes?	0	None
2009-06-15	Becoming an involuntary DBA - you're not alone	4	None
2009-06-07	Weekly Survey: what's the hardest part of becoming an involuntary DBA?	0	None
2009-06-04	Backup monitoring and reporting	0	None
2009-05-30	Importance of defining and measuring SLAs	0	None
2009-05-25	Weekly survey: maximum allowable downtime - target and actual	0	None
2009-05-25	Importance of testing your disaster recovery plan	3	None
2009-05-17	Weekly survey: have you ever tested your disaster recovery plan?	1	None
2009-05-14	Clustered or nonclustered index on a random GUID?	11	None
2009-05-12	A sad tale of mis-steps and corruption (from today)	8	None
2009-05-12	How to get all the corruption messages from CHECKDB	6	None
2009-05-10	Importance of having a manageable environment	2	None
2009-05-05	Misconceptions around corruptions: can they disappear?	0	None
2009-05-04	Do transactions rollback when DBCC CHECKDB runs?	2	None
2009-05-02	Weekly survey: what's your largest database, and how many do you manage?	0	None
2009-05-01	TechNet Magazine: June 2009 SQL Q&A column	0	None
2009-04-15	SQL 2005 SP2 maintenance plan bug masking corruption	0	None
2009-04-10	Importance of proper transaction log size management	10	None
2009-04-03	TechNet Magazine: feature article on Common SQL Server Security Issues and Solutions	0	None
2009-03-27	Importance of how you run consistency checks	3	None
2009-03-27	Index rebuilds depend on stats, which are updated by index rebuilds?!?	0	None
2009-03-25	Is running repair on msdb safe?	2	None
2009-03-25	Msg 602, Level 21, State 50, Line 1	1	None
2009-03-21	Importance of index maintenance	2	None
2009-03-13	Weekly survey: index maintenance plan	2	None
2009-03-13	Importance of validating backups	7	None
2009-03-13	Great script for automating database maintenance	0	None
2009-03-07	How can a log backup fail but a full backup succeed?	3	None
2009-03-05	Database settings survey	0	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-02-23	Easy monitoring of high-severity errors: create Agent alerts	3	None
2009-02-23	A little-known sign of impending doom: error 825	3	None
2009-02-09	Performance impact of lots of VLFs in the transaction log	0	None
2009-01-16	TechNet Magazine: February 2009 SQL Q&A column	0	None
2009-01-16	TechNet Magazine: feature article on understanding logging and recovery	1	None
2009-01-12	TechNet Radio interview on database corruption	0	None
2008-11-26	Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup	6	None
2008-08-30	Follow-on from instant initialization privilege checking	6	None
2008-08-29	Creating, detaching, re-attaching, and fixing a suspect database	15	None
2008-08-28	RunAs Radio interview on being an "involuntary DBA"	0	None
2008-07-08	TechNet Magazine: Effective Database Maintenance article and August SQL Q&A column	1	None

IO Subsystems (27)

Date	Title	Comments	Rating
2011-06-01	Performance issues from wasted buffer pool memory	9	None
2011-04-11	How to examine IO subsystem latencies from within SQL Server	9	None
2011-02-16	Unbelievable tale of disaster and recovery	34	None
2011-01-19	TechNet Magazine: January 2011 SQL Q&A column	0	None
2010-07-23	Survey results around purchase and use of SSDs	5	None
2010-06-22	Benchmarking: do multiple data files make a difference?	14	None
2010-03-05	TechNet Magazine: March 2010 SQL Q&A column	0	None
2010-03-03	New hardware to play with: Fusion-io SSDs	20	None
2010-02-28	Using diskpart and wmic to check disk partition alignment	15	None
2010-01-21	Benchmarking: 1-TB table population (part 1: the baseline)	30	None
2009-08-26	Adding geo-redundancy to failover clustering	2	None
2009-08-21	SQL Quiz #5: SANs and mirroring	5	None
2009-06-24	Weekly survey: how often do you run consistency checks?	0	None
2009-06-15	Issues around DBCC CHECKDB and the use of hidden database snapshots	1	None
2009-05-13	Are your disk partition offsets, RAID stripe sizes, and NTFS allocation units set correctly?	1	None
2009-05-05	Misconceptions around corruptions: can they disappear?	0	None
2009-04-13	New research paper: Migrating Server Storage to SSDs: Analysis of Tradeoffs	3	None
2009-02-23	A little-known sign of impending doom: error 825	3	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	2	None
2008-04-19	Conference Questions Pot-Pourri #7: How to create Agent alerts	0	None
2008-03-21	Inside The Storage Engine: Does turning on page checksums discard any torn-page protection?	0	None
2008-02-04	Search Engine Q&A #14: Beware 3rd party file-system drivers with DBCC CHECKDB	1	None
2008-01-29	Search Engine Q&A #12: Should you create multiple files for a user DB on a multi-core box?	5	None
2008-01-10	Whitepaper on Predeployment I/O Best Practices, plus a few urban legends around SQL Server IO	0	None
2007-09-27	SQL Server 2008: Automatic Page Repair with Database Mirroring	3	None
2007-09-12	How to tell if the IO subsystem is causing corruptions?	1	None
2007-09-04	Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors	6	None

Jokes (8)

Date	Title	Comments	Rating
2010-04-01	April Fools Day joke from my years at Microsoft	2	None
2009-08-21	SQL Quiz #5: SANs and mirroring	5	None
2009-05-29	Quick joke	0	None
2009-05-07	OT: Excellent funny videos	1	None
2009-04-07	Off-topic: What would Facebook be like in real-life?	0	None
2008-08-28	RunAs Radio interview on being an "involuntary DBA"	0	None
2008-04-01	SQLskills.com Announces Time-Setback Technology for DBAs	2	None
2008-01-30	Tales from the women's bathroom in the Microsoft office in Beijing	0	None

Latches (3)

Date	Title	Comments	Rating
2011-07-01	New whitepapers on latches and spinlocks published	1	None
2011-04-13	Advanced performance troubleshooting: waits, latches, spinlocks	7	None
2010-05-09	TechNet Magazine: May 2010 SQL Q&A column	4	None

LOB data (7)

Date	Title	Comments	Rating
2010-08-09	TechNet Magazine: July 2010 SQL Q&A column	0	None
2010-05-11	Why LOB data makes shrink run slooooowly (T-SQL Tuesday #006)	1	None
2009-12-02	2005 corruption bug with XML index rebuild fixed in latest CU	1	None
2009-04-30	Performance bug: NOLOCK scans involving off-row LOB data	12	None
2009-04-03	Importance of choosing the right LOB storage technique	4	None
2009-03-27	Weekly survey: large-value character storage	4	None
2009-03-10	Couple of LOB corruption bugs fixed in the latest CUs for 2005	0	None

Locking (12)

Date	Title	Comments	Rating
2011-04-26	SOS_SCHEDULER_YIELD waits and the LOCK_HASH spinlock	10	None
2010-04-23	A SQL Server DBA myth a day: (23/30) lock escalation	1	None
2010-04-08	A SQL Server DBA myth a day: (8/30) unicorns, rainbows, and online index operations	3	None
2009-11-13	Lock logging and fast recovery	7	None
2009-05-30	Investigating locking and deadlocking with %%lockres%%	0	None
2009-02-23	Getting historical deadlock info using extended events	2	None
2009-01-16	TechNet Magazine: February 2009 SQL Q&A column	0	None
2008-06-08	Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)	6	None
2008-02-15	SQL Server 2008 JumpStart	0	None
2008-01-14	SQL Server 2008: Partition-level lock escalation details and examples	10	None
2007-12-05	Search Engine Q&A #10: When are pages from a truncated table reused?	4	None
2007-10-02	SQL Server 2008: Lock escalation changes	1	None

Log Shipping (9)

Date	Title	Comments	Rating
2010-06-04	Whitepaper on high-availability architectures published	3	None
2010-04-07	A SQL Server DBA myth a day: (7/30) multiple mirrors and log shipping load delays	3	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-08-26	Adding geo-redundancy to failover clustering	2	None
2009-07-17	TechNet Magazine: August 2009 SQL Q&A column	3	None
2009-04-21	Why could restoring a log-shipping log backup be slow?	1	None
2008-11-11	Conference Questions Pot-Pourri #9: Q&A around compression features	2	None
2008-09-23	TechNet Magazine: October SQL Q&A column	4	None
2008-01-11	More new whitepapers: Database Mirroring and Log Shipping	0	None

MCM (5)

Date	Title	Comments	Rating
2011-03-07	Internals, Design, and Performance class in Chicago in May	1	None
2011-02-25	Do changes to index keys really do in-place updates?	0	None
2011-01-04	All MCM free training videos now available	6	None
2010-12-16	2011 comprehensive training curriculum, schedule, and details announced	0	None
2010-11-09	Big changes to the MCM program and how SQLskills can help you	17	None

Memory (7)

Date	Title	Comments	Rating
2011-06-01	Performance issues from wasted buffer pool memory	9	None
2010-04-05	A SQL Server DBA myth a day: (5/30) AWE must be enabled on 64-bit servers	8	None
2009-09-26	TechNet Magazine: October 2009 SQL Q&A column	0	None
2009-09-08	Memory: Large Pages and MemToLeave	2	None
2009-08-24	Don't confuse error 823 and error 832	7	None
2009-04-30	Blog series on computer memory architectures	1	None
2009-04-26	MS announces support for 'lock pages in memory' for Standard Edition	0	None

Misconceptions (47)

Date	Title	Comments	Rating
2011-02-17	Leaving the Land of Confusion...	6	None
2010-10-19	Myths and misconceptions: 60-page PDF of blog posts	12	None
2010-10-12	T-SQL Tuesday #11: Misconceptions about.... EVERYTHING!!	4	None
2010-05-06	Benchmarking: Introducing SSDs (Part 1: not overloaded log file array)	12	None
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2010-04-29	A SQL Server DBA myth a day: (29/30) fixing heap fragmentation	12	None
2010-04-28	A SQL Server DBA myth a day: (28/30) BULK_LOGGED recovery model	3	None
2010-04-27	A SQL Server DBA myth a day: (27/30) use BACKUP WITH CHECKSUM to replace DBCC CHECKDB	11	None
2010-04-26	A SQL Server DBA myth a day: (26/30) nested transactions are real	9	None
2010-04-25	A SQL Server DBA myth a day: (25/30) fill factor	7	None
2010-04-24	A SQL Server DBA myth a day: (24/30) twenty six restore myths	8	None
2010-04-23	A SQL Server DBA myth a day: (23/30) lock escalation	1	None
2010-04-22	A SQL Server DBA myth a day: (22/30) resource governor allows IO governing	2	None
2010-04-21	A SQL Server DBA myth a day: (21/30) corruption can be fixed by restarting SQL Server	5	None
2010-04-20	A SQL Server DBA myth a day: (20/30) restarting a log backup chain requires a full database backup	4	None
2010-04-19	A SQL Server DBA myth a day: (19/30) TRUNCATE TABLE is non-logged	7	None
2010-04-18	A SQL Server DBA myth a day: (18/30) FILESTREAM storage, garbage collection, and more	1	None
2010-04-17	A SQL Server DBA myth a day: (17/30) page checksums	1	None
2010-04-16	A SQL Server DBA myth a day: (16/30) corruptions and repairs	2	None
2010-04-15	A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions	3	None
2010-04-14	A SQL Server DBA myth a day: (14/30) clearing the log zeroes out log records	1	None
2010-04-13	A DBA myth a day: (13/30) you cannot run DMVs when in the 80 compat mode (T-SQL Tuesday #005)	5	None
2010-04-12	Important things for DBAs to consider	3	None
2010-04-12	A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core	15	None
2010-04-11	A SQL Server DBA myth a day: (11/30) database mirroring failover is instantaneous	1	None
2010-04-10	A SQL Server DBA myth a day: (10/30) database mirroring detects failures immediately	1	None
2010-04-09	A SQL Server DBA myth a day: (9/30) data file shrink does not affect performance	8	None
2010-04-08	A SQL Server DBA myth a day: (8/30) unicorns, rainbows, and online index operations	3	None
2010-04-07	A SQL Server DBA myth a day: (7/30) multiple mirrors and log shipping load delays	3	None
2010-04-06	A SQL Server DBA myth a day: (6/30) three null bitmap myths	4	None
2010-04-05	A SQL Server DBA myth a day: (5/30) AWE must be enabled on 64-bit servers	8	None
2010-04-04	A SQL Server DBA myth a day: (4/30) DDL triggers are INSTEAD OF triggers	3	None
2010-04-03	A SQL Server DBA myth a day: (3/30) instant file initialization can be controlled from within SQL Server	3	None
2010-04-02	A SQL Server DBA myth a day: (2/30) DBCC CHECKDB causes blocking	3	None
2010-04-01	A SQL Server DBA myth a day: (1/30) in-flight transactions continue after a failover	7	None
2010-01-07	Misconceptions around database snapshots and transaction rollbacks	9	None
2009-06-24	Why you should not shrink your data files	20	None
2009-06-16	Misconceptions about running DMVs on databases with lower compatibility levels	6	None
2009-05-29	Misconceptions around the log and log backups: how to convince yourself	8	None
2009-05-15	Misconceptions around database repair	5	None
2009-05-06	Misconceptions around adding columns to a table	3	None
2009-05-06	Misconceptions around FILESTREAM storage	0	None
2009-05-05	Misconceptions around corruptions: can they disappear?	0	None
2009-05-04	Misconceptions around null bitmap size	5	None
2009-04-23	Misconceptions around TF 1118	14	None
2009-03-10	Misconceptions around instant file initialization	12	None
2008-06-08	Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)	6	None

On-Disk Structures (45)

Date	Title	Comments	Rating
2011-09-13	Initial VLF sequence numbers and default log file size	5	None
2011-06-01	Performance issues from wasted buffer pool memory	9	None
2011-04-15	Survey: how much server memory is being wasted? (code to run)	108	None
2011-02-25	Do changes to index keys really do in-place updates?	0	None
2010-04-25	A SQL Server DBA myth a day: (25/30) fill factor	7	None
2010-02-26	Sample corrupt databases to play with	11	None
2009-11-13	Lock logging and fast recovery	7	None
2009-09-27	How do checkpoints work and what gets logged	6	None
2009-08-19	CHECKDB From Every Angle: How to tell if data purity checks will be run?	6	None
2009-08-10	Forwarding and forwarded records, and the back-pointer size	1	None
2009-05-12	How expensive are page splits in terms of transaction log?	7	None
2009-05-06	Misconceptions around adding columns to a table	3	None
2009-05-04	Misconceptions around null bitmap size	5	None
2009-04-23	Misconceptions around TF 1118	14	None
2009-04-21	Inside the Storage Engine: More on the circular nature of the log	4	None
2009-03-25	Msg 602, Level 21, State 50, Line 1	1	None
2009-03-22	IAM page corruption examples	1	None
2009-03-19	Ghost cleanup redux	4	None
2009-03-11	FILESTREAM directory structure	3	None
2009-03-01	Search Engine Q&A #27: How does the storage engine find variable-length columns?	1	None
2009-02-13	Corruption errors: Msg 5242, Level 22	0	None
2009-01-16	TechNet Magazine: feature article on understanding logging and recovery	1	None
2008-11-06	Corruption bug that people are hitting: Msg 8914 - PFS free space	6	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	2	None
2008-08-20	Search Engine Q&A #24: Why can't the transaction log use instant initialization?	5	None
2008-07-25	Search Engine Q&A #21: File header pages, and file header corruption	1	None
2008-07-11	Search Engine Q&A #20: Boot pages, and boot page corruption	3	None
2008-06-09	CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete	6	None
2008-04-08	New script: How much of the database has changed since the last full backup?	9	None
2008-03-21	Inside The Storage Engine: Does turning on page checksums discard any torn-page protection?	0	None
2008-03-20	SQL Server 2008: New (undocumented) physical row locator function	10	None
2008-03-14	Inside The Storage Engine: GAM, SGAM, PFS and other allocation maps	5	None
2008-03-12	Inside The Storage Engine: sp_AllocationMetadata - putting undocumented system catalog views to work	3	None
2007-12-31	Inside the Storage Engine: When do versioning tags get added?	0	None
2007-12-05	Search Engine Q&A #10: When are pages from a truncated table reused?	4	None
2007-11-09	How can data-type choice affect performance?	3	None
2007-10-19	Tool for estimating the size of a database	0	None
2007-10-08	Inside the Storage Engine: Ghost cleanup in depth	11	None
2007-10-05	Indexes From Every Angle: What happens to non-clustered indexes when the table structure is changed?	1	None
2007-10-04	Inside the Storage Engine: Proof that records are not always physically stored in index key order	0	None
2007-10-04	Inside the Storage Engine: IAM pages, IAM chains, and allocation units	2	None
2007-10-03	Inside the Storage Engine: Anatomy of an extent	1	None
2007-10-03	Inside the Storage Engine: Anatomy of a page	19	None
2007-10-01	Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back	3	None
2007-09-30	Inside the Storage Engine: Anatomy of a record	5	None

Page Checksums (14)

Date	Title	Comments	Rating
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2010-04-17	A SQL Server DBA myth a day: (17/30) page checksums	1	None
2009-08-24	Don't confuse error 823 and error 832	7	None
2009-05-05	Misconceptions around corruptions: can they disappear?	0	None
2009-01-12	TechNet Radio interview on database corruption	0	None
2008-12-05	TechEd: 80 minute video of Corruption Survival Techniques presentation	0	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-04-19	Conference Questions Pot-Pourri #7: How to create Agent alerts	0	None
2008-03-21	Inside The Storage Engine: Does turning on page checksums discard any torn-page protection?	0	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-09-27	SQL Server 2008: Automatic Page Repair with Database Mirroring	3	None
2007-09-12	How to tell if the IO subsystem is causing corruptions?	1	None
2007-09-04	Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors	6	None

Partial Database Availability (6)

Date	Title	Comments	Rating
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-04-27	Physical database layout vs. database size	5	None
2009-04-10	Weekly survey: does size really matter - or is it what you do with it?	12	None
2008-07-25	Search Engine Q&A #21: File header pages, and file header corruption	1	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2007-11-14	Conference Questions Pot-Pourri #5: Database snapshots, and creating a snapshot of a single filegroup	2	None

Partitioning (18)

Date	Title	Comments	Rating
2010-01-25	DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6	2	None
2009-12-03	Interesting 2008 partitioned view perf bug fixed in SP1 CU4	1	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-09-23	DBCC CHECKFILEGROUP bug on SQL Server 2008	1	None
2009-04-27	Physical database layout vs. database size	5	None
2009-04-10	Weekly survey: does size really matter - or is it what you do with it?	12	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-01-16	TechNet Magazine: February 2009 SQL Q&A column	0	None
2009-01-16	TechNet Radio interview on partitioning (Kimberly)	0	None
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	4	None
2008-04-07	SQL Server 2008: How to get FILESTREAM and partitioning to work	0	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-02-15	SQL Server 2008 JumpStart	0	None
2008-01-14	SQL Server 2008: Partition-level lock escalation details and examples	10	None
2007-12-05	Search Engine Q&A #9: How to update constraints?	0	None
2007-11-01	Indexes From Every Angle: What indexes are necessary when using SWITCH PARTITION?	1	None
2007-10-04	Inside the Storage Engine: IAM pages, IAM chains, and allocation units	2	None
2007-10-03	SQL Server 2008: Parallelism improvements for partitioning	1	None

Performance Tuning (108)

Date	Title	Comments	Rating
2012-01-02	Survey results: How cluster key size can lead to GBs of wasted space	4	None
2011-11-08	Survey: wasted space from cluster keys (code to run)	43	None
2011-11-02	Code to list index counts per table	3	None
2011-11-01	Over and under indexing - how bad is it out there?	5	None
2011-10-19	Page Life Expectancy isn't what you think...	16	None
2011-07-11	Capturing wait stats for a single operation	5	None
2011-07-01	New whitepapers on latches and spinlocks published	1	None
2011-06-23	MAXDOP configuration survey results	4	None
2011-06-01	Performance issues from wasted buffer pool memory	9	None
2011-05-26	Survey: cores vs. MAXDOP	60	None
2011-05-24	Benchmarking: Multiple data files on SSDs (plus the latest Fusion-io driver)	19	None
2011-04-26	SOS_SCHEDULER_YIELD waits and the LOCK_HASH spinlock	10	None
2011-04-15	Survey: how much server memory is being wasted? (code to run)	108	None
2011-04-13	Advanced performance troubleshooting: waits, latches, spinlocks	7	None
2011-04-13	How to download a sqlservr.pdb symbol file	2	None
2011-04-11	How to examine IO subsystem latencies from within SQL Server	9	None
2011-04-06	Survey results: Common causes of performance problems	2	None
2011-03-24	Survey: have you ever used these DMVs?	7	None
2011-03-17	Survey: what are the most common causes of performance problems?	9	None
2011-03-16	Query plan analysis first steps	1	None
2011-03-13	Ever had poor performance saving files in SSMS over slow network?	0	None
2011-02-22	Survey: how is your tempdb configured?	72	None
2011-02-08	Importance of network latency when using database mirroring	1	None
2011-02-06	Survey: what's your plan for a plan?	0	None
2011-01-19	TechNet Magazine: January 2011 SQL Q&A column	0	None
2011-01-19	PASS Performance VC recording and slides on index fragmentation available	0	None
2011-01-16	Adventures in query tuning: non-seekable WHERE clause expressions	16	None
2011-01-16	Results of CPU power saving survey	4	None
2010-12-30	Are your CPUs running slowly? Tool tip and survey	9	None
2010-12-09	Wait statistics, or please tell me where it hurts	30	None
2010-10-25	Survey: what is the highest wait on your system?	35	None
2010-08-10	Benchmarking: Introducing SSDs (Part 3: random inserts with wait stats details)	1	None
2010-07-23	Survey results around purchase and use of SSDs	5	None
2010-07-09	Benchmarking: Introducing SSDs (Part 2: sequential inserts)	10	None
2010-06-22	Benchmarking: do multiple data files make a difference?	14	None
2010-05-10	Benchmarking: Introducing SSDs (Part 1b: not overloaded log file array)	10	None
2010-05-06	Benchmarking: Introducing SSDs (Part 1: not overloaded log file array)	12	None
2010-05-01	Adventures in query tuning: unexpected key lookups	10	None
2010-05-01	Missing index DMVs bug that could cost your sanity...	18	None
2010-04-28	A SQL Server DBA myth a day: (28/30) BULK_LOGGED recovery model	3	None
2010-04-26	A SQL Server DBA myth a day: (26/30) nested transactions are real	9	None
2010-04-23	Survey: how are your transaction logs configured?	26	None
2010-04-13	A DBA myth a day: (13/30) you cannot run DMVs when in the 80 compat mode (T-SQL Tuesday #005)	5	None
2010-04-12	A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core	15	None
2010-03-25	Benchmarking: 1-TB table population (part 5: network optimization again)	8	None
2010-03-09	Inside sys.dm_db_index_physical_stats	6	None
2010-03-08	Benchmarking: 1-TB table population (part 4: network optimization)	6	None
2010-02-28	Using diskpart and wmic to check disk partition alignment	15	None
2010-02-15	Benchmarking: 1-TB table population (part 3: separating data and log files)	10	None
2010-01-27	Benchmarking: 1-TB table population (part 2: optimizing log block IO size and how log IO works)	28	None
2010-01-21	Benchmarking: 1-TB table population (part 1: the baseline)	30	None
2010-01-18	Interesting case of watching log file growth during a perf test	4	None
2010-01-08	Turning off the ghost cleanup task for a performance gain	12	None
2009-12-03	Interesting 2008 partitioned view perf bug fixed in SP1 CU4	1	None
2009-12-01	Benchmarking hardware setup	14	None
2009-10-15	Tracking expensive queries with extended events in SQL 2008	3	None
2009-10-08	Which index will SQL Server use to count all rows	6	None
2009-09-15	Survey: how do you create and maintain statistics	3	None
2009-06-07	Important considerations when performance tuning	3	None
2009-05-30	Weekly survey: what's the most important thing when performance tuning?	8	None
2009-05-30	Investigating locking and deadlocking with %%lockres%%	0	None
2009-05-20	An example of a nasty cluster key	14	None
2009-05-14	Clustered or nonclustered index on a random GUID?	11	None
2009-05-13	Are your disk partition offsets, RAID stripe sizes, and NTFS allocation units set correctly?	1	None
2009-05-12	How expensive are page splits in terms of transaction log?	7	None
2009-05-06	What is FSAgent.exe and why does it have lots of waits?	0	None
2009-05-06	Misconceptions around adding columns to a table	3	None
2009-05-05	Why did the Windows 7 RC download failure happen?	13	None
2009-04-30	Performance bug: NOLOCK scans involving off-row LOB data	12	None
2009-04-27	Physical database layout vs. database size	5	None
2009-04-26	MS announces support for 'lock pages in memory' for Standard Edition	0	None
2009-04-23	Misconceptions around TF 1118	14	None
2009-04-21	Why could restoring a log-shipping log backup be slow?	1	None
2009-04-15	Updated whitepaper: Troubleshooting Performance Problems in SQL Server 2008	1	None
2009-04-13	New research paper: Migrating Server Storage to SSDs: Analysis of Tradeoffs	3	None
2009-04-10	Weekly survey: does size really matter - or is it what you do with it?	12	None
2009-04-03	Importance of choosing the right LOB storage technique	4	None
2009-03-24	DBCC PINTABLE	4	None
2009-03-11	TechNet Magazine: April 2009 SQL Q&A column	0	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-02-15	New whitepaper on tuning Change Data Capture performance	0	None
2009-02-09	Performance impact of lots of VLFs in the transaction log	0	None
2009-01-16	Comprehensive tempdb blog post series	0	None
2008-11-25	SQLskills.com.au and classes in Australia 2009	0	None
2008-11-12	TechNet Magazine: December 2008 SQL Q&A column	0	None
2008-10-28	New minimally-logged insert functionality in SQL Server 2008	0	None
2008-08-25	High-performance FILESTREAM tips and tricks	5	None
2008-08-20	Can GUID cluster keys cause non-clustered index fragmentation?	5	None
2008-08-11	User groups and classes in August and September	0	None
2008-05-14	How hard is it to pick the right non-clustered indexes?	7	None
2008-03-09	SQL Server 2008: FILESTREAM performance	4	None
2008-02-12	CHECKDB From Every Angle: Example DBCC CHECKDB run-times	0	None
2008-01-29	The frustration of sweeping generalizations - follow on from Search Engine Q&A #12	5	None
2008-01-29	Search Engine Q&A #12: Should you create multiple files for a user DB on a multi-core box?	5	None
2008-01-10	Whitepaper on Predeployment I/O Best Practices, plus a few urban legends around SQL Server IO	0	None
2008-01-10	SQL Server 2008: Hot-Add CPU (and affinity masks)	4	None
2008-01-09	SQL Server 2008: Backup Compression CPU Cost	7	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-11-15	CHECKDB From Every Angle: How long will CHECKDB take to run?	3	None
2007-11-13	Auto-shrink – turn it OFF!	12	None
2007-11-09	Conference Questions Pot-Pourri #4: How many databases can you really mirror per instance?	1	None
2007-11-09	How can data-type choice affect performance?	3	None
2007-10-19	More on Database Mirroring performance and index maintenance	1	None
2007-10-11	SQL Server 2008: Performance boost for Database Mirroring	1	None
2007-10-05	Search Engine Q&A #5: Do multi-core CPUs perform better than single-core CPUs?	4	None
2007-10-05	Indexes From Every Angle: How can you tell if an index is being used?	4	None
2007-10-03	SQL Server 2008: Parallelism improvements for partitioning	1	None
2007-10-01	SQL Server 2008: New Performance Counters for Database Mirroring	3	None

Personal (48)

Date	Title	Comments	Rating
2011-12-30	2011: the year in books	4	None
2011-11-17	Vacation...	0	None
2011-06-22	The Golden Rule - maybe just optional now?	45	None
2011-03-04	Recent Lego models gallery	7	None
2011-01-11	T-SQL Tuesday #14: Resolutions - continue having fun	1	None
2010-12-31	2010 review: the year by the numbers	13	None
2010-12-31	2010: the year in books	0	None
2010-08-12	Offline for four weeks...	1	None
2010-06-07	The Paul and Kimberly travel guide	3	None
2010-05-20	On vacation...	1	None
2010-04-22	Another unavoidable social network	0	None
2010-04-01	MVPs again - what does it mean?	10	None
2010-03-12	TGIF Time Warp	2	None
2010-01-17	New blog on SQLskills.com: Paul's Electronics	0	None
2010-01-16	What three events brought you here?	26	None
2009-12-30	Once in a lifetime: 100 books in a year	25	None
2009-08-21	Goals, obsessions, and aspirations: becoming an MVP	8	None
2009-07-06	Wasting time on vacation	10	None
2009-07-01	July Vacation	3	None
2009-05-30	Blog post 350 on this blog - vive la communite!	6	None
2009-05-29	We all do stupid things when we're young	4	None
2009-05-23	Garden flower close-up photos	1	None
2009-03-27	Photos: amazing wall paintings from the Imperial Palace in Bangkok	0	None
2009-03-23	New Microsoft Regional Director - Paul Randal	11	None
2009-03-12	Facebook, or how to lose productivity forever	6	None
2009-02-16	Diving in the Caribbean	1	None
2009-01-27	OT: Scottish fine arts	0	None
2008-12-17	Happy holidays!	1	None
2008-12-09	Manamana!	11	None
2008-11-24	Paul Randal named Contributing Editor of TechNet Magazine	1	None
2008-11-01	8-bit nostalgia time	1	None
2008-09-03	One year on...	2	None
2008-08-27	This had me in tears laughing...	0	None
2008-08-27	LEGO Olympics	1	None
2008-08-22	Weird Boeing test flight	0	None
2008-08-11	When Moray Eels get a little close for comfort...	0	None
2008-08-03	Nostalgia day	5	None
2008-05-18	Do backups apply to just digital data? And how many backups should you have?	4	None
2008-04-01	Paul Randal awarded SQL Server MVP for 2008	9	None
2008-02-03	Personal: Final day in Beijing sightseeing (lots of photos)	3	None
2008-01-30	Tales from the women's bathroom in the Microsoft office in Beijing	0	None
2008-01-27	Personal: And on to Beijing and the Great Wall...	1	None
2008-01-21	Personal: First trip of the year - China!	1	None
2007-12-23	Patents and parties	0	None
2007-12-03	Donald Wayne Tripp, August 6 1944 - November 28 2007	0	None
2007-11-20	Downtime...	2	None
2007-11-03	And we're off - Fall conference season begins!	1	None
2007-10-19	SQL Down Under podcast interview - CHECKDB, 2008, and what does Paul get up to when Kimberly's away?	1	None

Photography (9)

Date	Title	Comments	Rating
2012-01-08	Photos from first part of Indonesia trip	8	None
2011-12-13	Photos from Belize dive trip	10	None
2011-08-11	Photos: Illinois Railway Museum	3	None
2011-07-18	Photos: Japanese Garden at Seattle Arboretum	5	None
2011-05-10	Photos from Munich trip in April	4	None
2010-11-26	Bald eagles in Alaska (4th and final part)	7	None
2010-11-24	Bald eagles in Alaska (part 3)	6	None
2010-11-18	Bald eagles in Alaska (part 2)	11	None
2010-11-17	Bald eagles in Alaska (part 1)	16	None

Policy Based Management (4)

Date	Title	Comments	Rating
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-03-11	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 2	0	None
2008-02-15	SQL Server 2008 JumpStart	0	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None

Products (2)

Date	Title	Comments	Rating
2008-02-19	Administrivia	1	None
2007-12-05	Question for all of you.... interest in printouts of our workshops?	5	None

Query Processor (2)

Date	Title	Comments	Rating
2011-01-29	Two great blog series on joins and query plan operators	0	None
2009-10-08	Which index will SQL Server use to count all rows	6	None

Query Tuning (7)

Date	Title	Comments	Rating
2011-04-06	Survey results: Common causes of performance problems	2	None
2011-03-16	Query plan analysis first steps	1	None
2011-02-06	Survey: what's your plan for a plan?	0	None
2011-01-29	Two great blog series on joins and query plan operators	0	None
2011-01-16	Adventures in query tuning: non-seekable WHERE clause expressions	16	None
2010-05-01	Adventures in query tuning: unexpected key lookups	10	None
2010-05-01	Missing index DMVs bug that could cost your sanity...	18	None

Repair (19)

Date	Title	Comments	Rating
2011-08-25	SQL Server Magazine: feature article on using database repair	0	None
2010-04-16	A SQL Server DBA myth a day: (16/30) corruptions and repairs	2	None
2009-05-15	Misconceptions around database repair	5	None
2009-05-12	A sad tale of mis-steps and corruption (from today)	8	None
2009-03-25	Is running repair on msdb safe?	2	None
2008-12-17	TechEd demo: nonclustered index corruption	1	None
2008-12-05	TechEd: 80 minute video of Corruption Survival Techniques presentation	0	None
2008-11-25	Corruption survival techniques - useless?	8	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-09-23	TechNet Magazine: October SQL Q&A column	4	None
2008-08-29	Creating, detaching, re-attaching, and fixing a suspect database	15	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	2	None
2008-06-12	Using the Dedicated Admin Connection to fix Msg 8992: corrupt system tables	13	None
2008-06-09	CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete	6	None
2007-11-16	CHECKDB From Every Angle: Can CHECKDB repair everything?	1	None
2007-11-14	CHECKDB From Every Angle: Tips and tricks for interpreting CHECKDB output	2	None
2007-10-02	CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort	23	None
2007-09-15	Corruption: Last resorts that people try first...	0	None
2007-09-13	Common bad advice around disaster recovery	0	None

Replication (11)

Date	Title	Comments	Rating
2010-11-03	In defense of transactional replication as an HA technology	13	None
2010-06-04	Whitepaper on high-availability architectures published	3	None
2009-12-09	What can cause log reads and other transaction log questions	8	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-08-26	Adding geo-redundancy to failover clustering	2	None
2008-09-02	SQL Server2008: New whitepaper on combining transactional replication and database mirroring	0	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-03-05	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 1	0	None
2008-02-15	SQL Server 2008 JumpStart	0	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-12-07	SQL Server 2008: Configuring Peer-to-Peer Replication	0	None

Resource Governor (7)

Date	Title	Comments	Rating
2011-06-23	MAXDOP configuration survey results	4	None
2010-04-22	A SQL Server DBA myth a day: (22/30) resource governor allows IO governing	2	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-07-18	New whitepaper on Resource Governor	0	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-03-11	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 2	0	None
2008-02-15	SQL Server 2008 JumpStart	0	None

Search Engine Q and A (29)

Date	Title	Comments	Rating
2009-03-03	Common questions from newsgroups and forums	0	None
2009-03-01	Search Engine Q&A #27: How does the storage engine find variable-length columns?	1	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	2	None
2008-08-25	Search Engine Q&A #25: Why isn't my log backup the same size as my log?	1	None
2008-08-20	Search Engine Q&A #24: Why can't the transaction log use instant initialization?	5	None
2008-08-14	Search Engine Q&A #23: My transaction log is full - now what?	0	None
2008-08-11	Search Engine Q&A #22: Can all page types be single-page restored?	1	None
2008-07-25	Search Engine Q&A #21: File header pages, and file header corruption	1	None
2008-07-11	Search Engine Q&A #20: Boot pages, and boot page corruption	3	None
2008-06-08	Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)	6	None
2008-04-17	Search Engine Q&A #18: What's the current uptime of SQL Server?	7	None
2008-03-13	Search Engine Q&A #17: Split a VLDB into filegroups or smaller databases for backups?	0	None
2008-02-21	Search Engine Q&A #16: Concurrent log and full backups	4	None
2008-02-05	Search Engine Q&A #15: Mirrored backups	1	None
2008-02-04	Search Engine Q&A #14: Beware 3rd party file-system drivers with DBCC CHECKDB	1	None
2008-01-29	Search Engine Q&A #13: Difference between database version and database compatibility level	0	None
2008-01-29	The frustration of sweeping generalizations - follow on from Search Engine Q&A #12	5	None
2008-01-29	Search Engine Q&A #12: Should you create multiple files for a user DB on a multi-core box?	5	None
2008-01-28	Search Engine Q&A #11: How to design a global-ready database?	2	None
2008-01-27	Search Engine Q&A #10: Rebuilding Indexes and Updating Statistics	10	None
2007-12-05	Search Engine Q&A #9: How to update constraints?	0	None
2007-10-25	Search Engine Q&A #8: How can defragging an index break synchronous mirroring? And what happens?	0	None
2007-10-10	Search Engine Q&A #7: Restoring from a backup file containing multiple database backups	0	None
2007-10-06	Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup	1	None
2007-10-05	Search Engine Q&A #5: Do multi-core CPUs perform better than single-core CPUs?	4	None
2007-10-02	Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database	5	None
2007-10-01	Search Engine Q&A #3: Database mirroring failover types and partner timeouts	0	None
2007-09-28	Search Engine Q&A #2: Moving a database while Database Mirroring is running	1	None
2007-09-24	Search Engine Q&A #1: Running out of transaction log space	5	None

Security (8)

Date	Title	Comments	Rating
2010-04-04	A SQL Server DBA myth a day: (4/30) DDL triggers are INSTEAD OF triggers	3	None
2009-04-03	TechNet Magazine: feature article on Common SQL Server Security Issues and Solutions	0	None
2009-03-11	How to scan a network looking for SQL instances	0	None
2009-03-02	New whitepaper on SQL Server Audit in 2008	0	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2008-09-10	Dev Connections newsletter	0	None
2008-08-30	Follow-on from instant initialization privilege checking	6	None
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	4	None

Sharepoint (8)

Date	Title	Comments	Rating
2011-08-22	SharePoint in a SQL Server environment	5	None
2011-08-04	Survey: do you have SharePoint in your SQL environment?	0	None
2011-07-26	SharePoint 2010 database maintenance whitepaper	7	None
2011-03-23	TechNet Magazine: March 2011 SQL Q&A column	0	None
2010-04-29	Paul and Kimberly interview from MVP Summit	1	None
2009-03-23	Measuring 'churn' in a SharePoint content database using SQL Server	0	None
2009-03-10	Microsoft Certified Master - Database AND Sharepoint	3	None
2009-03-10	Couple of LOB corruption bugs fixed in the latest CUs for 2005	0	None

Shrink (13)

Date	Title	Comments	Rating
2010-08-09	TechNet Magazine: July 2010 SQL Q&A column	0	None
2010-05-11	Why LOB data makes shrink run slooooowly (T-SQL Tuesday #006)	1	None
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2010-04-09	A SQL Server DBA myth a day: (9/30) data file shrink does not affect performance	8	None
2010-03-05	TechNet Magazine: March 2010 SQL Q&A column	0	None
2010-01-04	TechNet Magazine: January 2010 SQL Q&A column	3	None
2009-06-24	Importance of data file size management	4	None
2009-06-24	Why you should not shrink your data files	20	None
2008-11-26	Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup	6	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	2	None
2008-07-08	TechNet Magazine: Effective Database Maintenance article and August SQL Q&A column	1	None
2008-05-19	In Print: TechNet Magazine June 2008 SQL Q&A Column	4	None
2007-11-13	Auto-shrink – turn it OFF!	12	None

Snapshot Isolation (6)

Date	Title	Comments	Rating
2010-01-04	TechNet Magazine: January 2010 SQL Q&A column	3	None
2009-03-10	Couple of LOB corruption bugs fixed in the latest CUs for 2005	0	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-01-16	Comprehensive tempdb blog post series	0	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2007-12-31	Inside the Storage Engine: When do versioning tags get added?	0	None

Sparse Columns (3)

Date	Title	Comments	Rating
2008-10-19	Sparse columns: misleading info in Books Online	0	None
2008-04-28	SQL Server 2008: Sparse columns and XML COLUMN_SET	3	None
2008-04-18	SQL Server 2008: Sparse Columns	2	None

Spinlocks (5)

Date	Title	Comments	Rating
2011-07-01	New whitepapers on latches and spinlocks published	1	None
2011-04-26	SOS_SCHEDULER_YIELD waits and the LOCK_HASH spinlock	10	None
2011-04-13	Advanced performance troubleshooting: waits, latches, spinlocks	7	None
2011-04-13	How to download a sqlservr.pdb symbol file	2	None
2011-03-24	Survey: have you ever used these DMVs?	7	None

SQL Agent (7)

Date	Title	Comments	Rating
2009-04-15	SQL 2005 SP2 maintenance plan bug masking corruption	0	None
2009-03-25	Is running repair on msdb safe?	2	None
2009-02-23	Easy monitoring of high-severity errors: create Agent alerts	3	None
2009-02-23	A little-known sign of impending doom: error 825	3	None
2008-04-19	Conference Questions Pot-Pourri #7: How to create Agent alerts	0	None
2008-03-13	CHECKDB From Every Angle: When did DBCC CHECKDB last run successfully?	5	None
2007-10-06	How does daylight savings time affect disaster recovery?	4	None

SQL Server 2008 (92)

Date	Title	Comments	Rating
2010-06-04	Whitepaper on high-availability architectures published	3	None
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2010-04-23	A SQL Server DBA myth a day: (23/30) lock escalation	1	None
2009-10-15	Tracking expensive queries with extended events in SQL 2008	3	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-09-23	DBCC CHECKFILEGROUP bug on SQL Server 2008	1	None
2009-07-23	New whitepaper on SQL Server 2008 failover clustering	1	None
2009-07-18	New whitepaper on Resource Governor	0	None
2009-06-26	Scripting schema AND data with SSMS in SQL 2008	3	None
2009-05-29	SQL Server 2008 Data Compression whitepaper published	0	None
2009-05-10	Importance of having a manageable environment	2	None
2009-05-06	What is FSAgent.exe and why does it have lots of waits?	0	None
2009-05-06	Misconceptions around FILESTREAM storage	0	None
2009-04-23	Misconceptions around TF 1118	14	None
2009-04-21	FILESTREAM garbage collection	0	None
2009-04-07	SQL Server 2008 SP1 has been released	0	None
2009-04-03	Importance of choosing the right LOB storage technique	4	None
2009-04-03	TechNet Magazine: feature article on Common SQL Server Security Issues and Solutions	0	None
2009-03-27	Importance of how you run consistency checks	3	None
2009-03-22	How to change a default constraint	3	None
2009-03-22	IAM page corruption examples	1	None
2009-03-21	Importance of index maintenance	2	None
2009-03-19	Ghost cleanup redux	4	None
2009-03-17	FILESTREAM directory structure - where do the GUIDs come from?	4	None
2009-03-13	Importance of validating backups	7	None
2009-03-11	FILESTREAM directory structure	3	None
2009-03-11	Our book has been published!	1	None
2009-03-02	New whitepaper on SQL Server Audit in 2008	0	None
2009-02-24	Rolling upgrade using database mirroring (and a bug in 2008 RTM)	2	None
2009-02-23	Getting historical deadlock info using extended events	2	None
2009-02-23	Couple of nasty FILESTREAM bugs fixed in 2008 RTM CU1	0	None
2009-02-16	SQL Server 2008 system table map PDF	0	None
2008-12-05	TechNet Magazine: feature article on Advanced Troubleshooting with Extended Events	1	None
2008-12-03	SQL Server 2008: Using Change Data Capture with SSIS	2	None
2008-11-25	SQLskills.com.au and classes in Australia 2009	0	None
2008-11-25	Life on SQL Server 2008 - PASS interview with a large-scale user	0	None
2008-11-11	Conference Questions Pot-Pourri #9: Q&A around compression features	2	None
2008-10-29	High-end backup compression numbers	4	None
2008-10-28	New minimally-logged insert functionality in SQL Server 2008	0	None
2008-10-19	Sparse columns: misleading info in Books Online	0	None
2008-10-14	TechNet Magazine: Article on Tracking Changes in Your Enterprise Database	0	None
2008-10-10	SQL Server 2008 FILESTREAM whitepaper published on MSDN	5	None
2008-09-10	Dev Connections newsletter	0	None
2008-09-10	RunAs Radio interview on FILESTREAM	0	None
2008-09-02	SQL Server2008: New whitepaper on combining transactional replication and database mirroring	0	None
2008-09-02	Better behavior with suspect databases in SQL Server 2008	0	None
2008-08-29	SQL Server 2008: How to rebuild the system databases?	1	None
2008-08-25	High-performance FILESTREAM tips and tricks	5	None
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	4	None
2008-07-21	TechEd Online Panel Video: Building a Solid High-Availability Strategy	0	None
2008-07-10	We're writing a book - finally!	1	None
2008-07-10	Dev Connections SQL Power Workshop on SQL Server 2008, October, San Francisco	0	None
2008-04-28	SQL Server 2008: Sparse columns and XML COLUMN_SET	3	None
2008-04-18	SQL Server 2008: Sparse Columns	2	None
2008-04-08	New script: How much of the database has changed since the last full backup?	9	None
2008-04-07	SQL Server 2008: How to get FILESTREAM and partitioning to work	0	None
2008-03-20	SQL Server 2008: New (undocumented) physical row locator function	10	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-03-11	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 2	0	None
2008-03-10	SQL Server Magazine Connections Fall 2008 Call For Abstracts	0	None
2008-03-09	SQL Server 2008: FILESTREAM performance	4	None
2008-03-07	SQL Server 2008: Changes to enabling FILESTREAM from CTP-6 onwards	0	None
2008-03-05	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 1	0	None
2008-02-25	Conferences coming up: SQL Connections in April and TechEd US in June	0	None
2008-02-15	SQL Server 2008 JumpStart	0	None
2008-02-07	Updated aggregated feeds	0	None
2008-02-04	SQL Server 2008: Enabling FILESTREAM through T-SQL and SSMS	0	None
2008-01-28	SQL Server 2008: RTM slips to Q3	0	None
2008-01-25	SQL Server 2008: FILESTREAM	0	None
2008-01-17	SQL Server 2008: Spatial indexes	1	None
2008-01-14	SQL Server 2008: Partition-level lock escalation details and examples	10	None
2008-01-10	SQL Server 2008: Hot-Add CPU (and affinity masks)	4	None
2008-01-09	SQL Server 2008: Backup Compression CPU Cost	7	None
2008-01-04	Enabling VS2005 support for SQL Server 2008 CTP-5	0	None
2008-01-04	Katmai bug: SSMS doesn't drop database locks when leaving the context of a database	0	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-12-07	SQL Server 2008: Configuring Peer-to-Peer Replication	0	None
2007-11-18	Kimberly & Paul interview with SSWUG TV	0	None
2007-10-30	Fed up with BACKUP success messages bloating your error logs?	0	None
2007-10-12	SQL Server 2008: What's been removed in this version? BACKUP LOG WITH NO_LOG for one!	0	None
2007-10-11	SQL Server 2008: Performance boost for Database Mirroring	1	None
2007-10-09	New aggregate feeds for SQLskills blogs	0	None
2007-10-05	SQL Server Magazine Connections Spring 2008 Call For Presentations	0	None
2007-10-04	Coming to Connections in November? Send us your questions and win a prize!	0	None
2007-10-03	SQL Server 2008: Parallelism improvements for partitioning	1	None
2007-10-03	Coming up soon: TechEd IT Forum 2007	0	None
2007-10-02	SQL Server 2008: Lock escalation changes	1	None
2007-10-01	SQL Server 2008: New Performance Counters for Database Mirroring	3	None
2007-09-27	SQL Server 2008: Automatic Page Repair with Database Mirroring	3	None
2007-09-21	SQL Server 2008: On installing the latest CTP...	0	None
2007-09-20	SQL Server 2008: Backup Compression	4	None
2007-09-19	Coming up soon: SQL Server Magazine Connections conference	0	None

SQL Server Magazine (3)

Date	Title	Comments	Rating
2011-08-25	SQL Server Magazine: feature article on using database repair	0	None
2011-05-24	SQL Server Magazine: feature article on advanced BACKUP and RESTORE options	2	None
2010-03-25	Working with SQL Server Magazine	1	None

SQLIOSim (1)

Date	Title	Comments	Rating
2007-09-12	How to tell if the IO subsystem is causing corruptions?	1	None

SSDs (9)

Date	Title	Comments	Rating
2011-07-21	TechNet Magazine: July 2011 SQL Q&A column	0	None
2011-05-24	Benchmarking: Multiple data files on SSDs (plus the latest Fusion-io driver)	19	None
2010-08-10	Benchmarking: Introducing SSDs (Part 3: random inserts with wait stats details)	1	None
2010-07-23	Survey results around purchase and use of SSDs	5	None
2010-07-09	Benchmarking: Introducing SSDs (Part 2: sequential inserts)	10	None
2010-07-04	Survey: SSD purchasing and deployment plans	0	None
2010-05-10	Benchmarking: Introducing SSDs (Part 1b: not overloaded log file array)	10	None
2010-05-06	Benchmarking: Introducing SSDs (Part 1: not overloaded log file array)	12	None
2010-03-03	New hardware to play with: Fusion-io SSDs	20	None

Statistics (3)

Date	Title	Comments	Rating
2009-09-15	Survey: how do you create and maintain statistics	3	None
2009-08-14	How are auto-created column statistics names generated?	4	None
2009-03-27	Index rebuilds depend on stats, which are updated by index rebuilds?!?	0	None

Surveys (87)

Date	Title	Comments	Rating
2012-01-02	Survey results: How cluster key size can lead to GBs of wasted space	4	None
2011-11-08	Survey: wasted space from cluster keys (code to run)	43	None
2011-11-01	Over and under indexing - how bad is it out there?	5	None
2011-08-22	SharePoint in a SQL Server environment	5	None
2011-08-04	Survey: nonclustered index counts (code to run)	82	None
2011-08-02	OT survey results: browsers and email clients	6	None
2011-07-26	Using database snapshots	2	None
2011-07-20	OT Survey: internet browsers and mail readers	6	None
2011-07-06	Survey results on rebooting - is it good or bad?	8	None
2011-07-04	Survey: do you use database snapshots?	0	None
2011-06-23	MAXDOP configuration survey results	4	None
2011-06-02	Survey: do you regularly reboot SQL Server?	0	None
2011-06-02	The pros and cons of trace flags	3	None
2011-06-01	Performance issues from wasted buffer pool memory	9	None
2011-05-26	Survey: cores vs. MAXDOP	60	None
2011-05-05	Survey: what's your comfort level with trace flags in production?	6	None
2011-05-04	Salary survey results - are YOU being paid enough?	5	None
2011-04-19	Anonymous survey: salaries in the SQL Server world	0	None
2011-04-19	Job security, loyalty, and employee retention: you need to take control	7	None
2011-04-15	Survey: how much server memory is being wasted? (code to run)	108	None
2011-04-13	Advanced performance troubleshooting: waits, latches, spinlocks	7	None
2011-04-06	Surveys: what's your company doing for you, and vice versa?	14	None
2011-04-06	Survey results: Common causes of performance problems	2	None
2011-03-24	Survey: have you ever used these DMVs?	7	None
2011-03-23	Human nature is a significant hurdle to successful disaster recovery	8	None
2011-03-17	Survey: what are the most common causes of performance problems?	9	None
2011-03-16	Query plan analysis first steps	1	None
2011-03-11	Surveys: DR plan testing and considering human nature	3	None
2011-03-09	Tempdb configuration survey results and advice	8	None
2011-02-24	Better together - the importance of great inter-team relationships	2	None
2011-02-22	Survey: how is your tempdb configured?	72	None
2011-02-22	Updated database size survey results	1	None
2011-02-14	Survey: what's the largest SQL Server database at your company?	6	None
2011-02-08	Importance of network latency when using database mirroring	1	None
2011-02-06	Survey: what's your plan for a plan?	0	None
2011-01-31	Importance of monitoring a database mirroring session	4	None
2011-01-30	Survey: inter-team relationships	6	None
2011-01-30	Survey: database mirroring latency between servers	0	None
2011-01-24	Survey: monitoring database mirroring	1	None
2011-01-24	What's in a job title?	4	None
2011-01-16	Results of CPU power saving survey	4	None
2010-12-30	Are your CPUs running slowly? Tool tip and survey	9	None
2010-12-21	Survey: what's in a job title?	40	None
2010-12-09	Wait statistics, or please tell me where it hurts	30	None
2010-10-25	Survey: what is the highest wait on your system?	35	None
2010-07-23	Survey results around purchase and use of SSDs	5	None
2010-07-04	Survey: SSD purchasing and deployment plans	0	None
2010-07-04	Log file configuration metrics for 17000 databases	9	None
2010-04-23	Survey: how are your transaction logs configured?	26	None
2009-09-15	Survey: how do you create and maintain statistics	3	None
2009-09-15	Importance of having a good disaster recovery plan	5	None
2009-08-26	Survey: what kind of disaster recovery guide do you have?	0	None
2009-08-26	Adding geo-redundancy to failover clustering	2	None
2009-08-03	Survey: How do you provide geo-redundancy with clustering?	0	None
2009-08-03	Importance of running regular consistency checks	4	None
2009-06-24	Weekly survey: how often do you run consistency checks?	0	None
2009-06-24	Importance of data file size management	4	None
2009-06-15	Weekly survey: how do you manage your data file sizes?	0	None
2009-06-15	Becoming an involuntary DBA - you're not alone	4	None
2009-06-07	Weekly Survey: what's the hardest part of becoming an involuntary DBA?	0	None
2009-06-07	Important considerations when performance tuning	3	None
2009-05-30	Weekly survey: what's the most important thing when performance tuning?	8	None
2009-05-30	Importance of defining and measuring SLAs	0	None
2009-05-25	Weekly survey: maximum allowable downtime - target and actual	0	None
2009-05-25	Importance of testing your disaster recovery plan	3	None
2009-05-17	Weekly survey: have you ever tested your disaster recovery plan?	1	None
2009-05-17	Importance of choosing the right architecture and SQL Server Edition	0	None
2009-05-10	Weekly survey: what architecture do you buy? And which SQL Server edition?	0	None
2009-05-10	Importance of having a manageable environment	2	None
2009-05-02	Weekly survey: what's your largest database, and how many do you manage?	0	None
2009-05-02	Importance of having the right backups	9	None
2009-04-27	Weekly survey: what kind of backups do you take?	0	None
2009-04-27	Physical database layout vs. database size	5	None
2009-04-17	Weekly survey: still running last week's survey	0	None
2009-04-10	Weekly survey: does size really matter - or is it what you do with it?	12	None
2009-04-10	Importance of proper transaction log size management	10	None
2009-04-03	Weekly survey: transaction log size management	5	None
2009-04-03	Importance of choosing the right LOB storage technique	4	None
2009-03-27	Weekly survey: large-value character storage	4	None
2009-03-27	Importance of how you run consistency checks	3	None
2009-03-21	Weekly survey: method of running consistency checks	0	None
2009-03-21	Importance of index maintenance	2	None
2009-03-13	Weekly survey: index maintenance plan	2	None
2009-03-13	Importance of validating backups	7	None
2009-03-10	Misconceptions around instant file initialization	12	None
2009-03-08	What's a valid question for a DBA interview?	4	None
2009-03-05	Testing a new survey method: backup validation	0	None

TechNet Magazine (28)

Date	Title	Comments	Rating
2011-09-14	TechNet Magazine: September 2011 SQL Q&A column	0	None
2011-07-21	TechNet Magazine: July 2011 SQL Q&A column	0	None
2011-05-24	TechNet Magazine: May 2011 SQL Q&A column	0	None
2011-04-06	TechNet Magazine article: data protection and the corporate jigsaw puzzle	1	None
2011-03-23	TechNet Magazine: March 2011 SQL Q&A column	0	None
2011-01-19	TechNet Magazine: January 2011 SQL Q&A column	0	None
2010-11-01	TechNet Magazine Article: Top-10 Secrets of a SQL Server Expert	1	None
2010-08-09	TechNet Magazine: July 2010 SQL Q&A column	0	None
2010-05-09	TechNet Magazine: May 2010 SQL Q&A column	4	None
2010-03-05	TechNet Magazine: March 2010 SQL Q&A column	0	None
2010-01-04	TechNet Magazine: January 2010 SQL Q&A column	3	None
2009-11-05	TechNet Magazine: feature article on recovering from disasters using backups	2	None
2009-09-26	TechNet Magazine: October 2009 SQL Q&A column	0	None
2009-07-17	TechNet Magazine: August 2009 SQL Q&A column	3	None
2009-06-05	TechNet Magazine: Feature article on backups and backup strategy	3	None
2009-05-01	TechNet Magazine: June 2009 SQL Q&A column	0	None
2009-04-03	TechNet Magazine: feature article on Common SQL Server Security Issues and Solutions	0	None
2009-03-11	TechNet Magazine: April 2009 SQL Q&A column	0	None
2009-01-16	TechNet Magazine: February 2009 SQL Q&A column	0	None
2009-01-16	TechNet Magazine: feature article on understanding logging and recovery	1	None
2009-01-16	Daily SQL Server 2008 tips from TechNet Magazine	0	None
2008-12-05	TechNet Magazine: feature article on Advanced Troubleshooting with Extended Events	1	None
2008-11-24	Paul Randal named Contributing Editor of TechNet Magazine	1	None
2008-11-12	TechNet Magazine: December 2008 SQL Q&A column	0	None
2008-10-14	TechNet Magazine: Article on Tracking Changes in Your Enterprise Database	0	None
2008-09-23	TechNet Magazine: October SQL Q&A column	4	None
2008-07-08	TechNet Magazine: Effective Database Maintenance article and August SQL Q&A column	1	None
2008-05-19	In Print: TechNet Magazine June 2008 SQL Q&A Column	4	None

tempdb (11)

Date	Title	Comments	Rating
2011-09-23	How does DBCC CHECKDB WITH ESTIMATEONLY work?	6	None
2011-03-09	Tempdb configuration survey results and advice	8	None
2011-02-22	Survey: how is your tempdb configured?	72	None
2010-05-01	Adventures in query tuning: unexpected key lookups	10	None
2010-04-12	A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core	15	None
2009-10-07	What does checkpoint do for tempdb?	2	None
2009-04-23	Misconceptions around TF 1118	14	None
2009-03-11	TechNet Magazine: April 2009 SQL Q&A column	0	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-01-16	Comprehensive tempdb blog post series	0	None
2008-09-02	Why does the buffer pool contain so many dirty tempdb pages?	2	None

TGIF (4)

Date	Title	Comments	Rating
2011-03-04	Recent Lego models gallery	7	None
2010-03-12	TGIF Time Warp	2	None
2009-09-25	TGIF in Dublin	3	None
2009-06-05	TGIF Insane driving skills clip	0	None

Tools (27)

Date	Title	Comments	Rating
2011-07-20	OT Survey: internet browsers and mail readers	6	None
2011-04-04	Beware of advice from 3rd-party tools around dropping indexes	2	None
2011-03-13	Ever had poor performance saving files in SSMS over slow network?	0	None
2010-12-30	Are your CPUs running slowly? Tool tip and survey	9	None
2010-11-11	Configuring SSMS for presenting	10	None
2010-04-13	A DBA myth a day: (13/30) you cannot run DMVs when in the 80 compat mode (T-SQL Tuesday #005)	5	None
2010-02-28	Using diskpart and wmic to check disk partition alignment	15	None
2009-06-26	Scripting schema AND data with SSMS in SQL 2008	3	None
2009-06-16	Misconceptions about running DMVs on databases with lower compatibility levels	6	None
2009-06-05	Free SQL Server tools	1	None
2009-05-12	How to get all the corruption messages from CHECKDB	6	None
2009-05-10	Importance of having a manageable environment	2	None
2009-05-06	What is FSAgent.exe and why does it have lots of waits?	0	None
2009-04-15	SQL 2005 SP2 maintenance plan bug masking corruption	0	None
2009-04-03	TechNet Magazine: feature article on Common SQL Server Security Issues and Solutions	0	None
2009-03-11	How to scan a network looking for SQL instances	0	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-02-23	Easy monitoring of high-severity errors: create Agent alerts	3	None
2008-08-26	Should Microsoft provide a transaction log reader tool?	10	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	2	None
2008-03-11	TechNet Radio interview with Paul and Kimberly on SQL Server 2008 - Part 2	0	None
2008-01-10	Whitepaper on Predeployment I/O Best Practices, plus a few urban legends around SQL Server IO	0	None
2008-01-04	Enabling VS2005 support for SQL Server 2008 CTP-5	0	None
2008-01-04	Katmai bug: SSMS doesn't drop database locks when leaving the context of a database	0	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None
2007-12-07	SQL Server 2008: Configuring Peer-to-Peer Replication	0	None
2007-10-19	Tool for estimating the size of a database	0	None

Trace Flags (12)

Date	Title	Comments	Rating
2011-06-02	The pros and cons of trace flags	3	None
2011-05-05	Survey: what's your comfort level with trace flags in production?	6	None
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2010-01-08	Turning off the ghost cleanup task for a performance gain	12	None
2009-04-23	Misconceptions around TF 1118	14	None
2007-10-30	Fed up with BACKUP success messages bloating your error logs?	0	None
2007-10-12	BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it	22	None
2007-10-11	SQL Server 2008: Performance boost for Database Mirroring	1	None
2007-10-02	SQL Server 2008: Lock escalation changes	1	None
2007-10-01	Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back	3	None
2007-09-27	SQL Server 2008: Automatic Page Repair with Database Mirroring	3	None
2007-09-12	How to tell if the IO subsystem is causing corruptions?	1	None

Training (9)

Date	Title	Comments	Rating
2011-12-07	Training budget: use it or lose it - prepaid seats offer	0	None
2011-12-01	Four new Spring 2012 classes in Chicago, IL open for registration	0	None
2011-10-06	Spring 2012 classes in Tampa, FL open for registration	0	None
2011-07-13	New DBA, dev, BI classes for Fall in Chicago and Atlanta	0	None
2011-04-19	Job security, loyalty, and employee retention: you need to take control	7	None
2011-03-14	London class in June open for public registration	0	None
2011-03-07	Internals, Design, and Performance class in Chicago in May	1	None
2011-02-19	London calling...	6	None
2011-02-10	My name is Kyle, and I've got SQLskills	3	None

Transaction Log (59)

Date	Title	Comments	Rating
2011-09-14	TechNet Magazine: September 2011 SQL Q&A column	0	None
2011-09-13	Initial VLF sequence numbers and default log file size	5	None
2011-07-21	TechNet Magazine: July 2011 SQL Q&A column	0	None
2011-01-19	TechNet Magazine: January 2011 SQL Q&A column	0	None
2010-07-04	Log file configuration metrics for 17000 databases	9	None
2010-06-18	Disaster recovery 101: backing up the tail of the log	7	None
2010-05-15	Bug: log file growth broken for multiples of 4GB	15	None
2010-04-30	A SQL Server DBA myth a day: (30/30) backup myths	19	None
2010-04-28	A SQL Server DBA myth a day: (28/30) BULK_LOGGED recovery model	3	None
2010-04-26	A SQL Server DBA myth a day: (26/30) nested transactions are real	9	None
2010-04-23	Survey: how are your transaction logs configured?	26	None
2010-04-19	A SQL Server DBA myth a day: (19/30) TRUNCATE TABLE is non-logged	7	None
2010-04-14	A SQL Server DBA myth a day: (14/30) clearing the log zeroes out log records	1	None
2010-02-01	Script: open transactions with text and plans	18	None
2010-01-27	Benchmarking: 1-TB table population (part 2: optimizing log block IO size and how log IO works)	28	None
2010-01-18	Interesting case of watching log file growth during a perf test	4	None
2009-12-09	What can cause log reads and other transaction log questions	8	None
2009-11-13	Lock logging and fast recovery	7	None
2009-10-07	New script: is that database REALLY in the FULL recovery mode?	2	None
2009-10-07	What does checkpoint do for tempdb?	2	None
2009-09-27	How do checkpoints work and what gets logged	6	None
2009-07-17	TechNet Magazine: August 2009 SQL Q&A column	3	None
2009-06-16	Finding out who dropped a table using the transaction log	17	None
2009-05-29	Misconceptions around the log and log backups: how to convince yourself	8	None
2009-05-24	New script: how much data will the next log backup include?	0	None
2009-05-12	A sad tale of mis-steps and corruption (from today)	8	None
2009-05-12	How expensive are page splits in terms of transaction log?	7	None
2009-04-21	Why could restoring a log-shipping log backup be slow?	1	None
2009-04-21	Inside the Storage Engine: More on the circular nature of the log	4	None
2009-04-10	Importance of proper transaction log size management	10	None
2009-04-03	Weekly survey: transaction log size management	5	None
2009-03-19	Ghost cleanup redux	4	None
2009-03-07	How can a log backup fail but a full backup succeed?	3	None
2009-02-25	TechNet and MSDN webcasts available again	0	None
2009-02-09	Performance impact of lots of VLFs in the transaction log	0	None
2009-01-16	TechNet Magazine: February 2009 SQL Q&A column	0	None
2009-01-16	TechNet Magazine: feature article on understanding logging and recovery	1	None
2008-11-26	Conference Questions Pot-Pourri #10: Shrinking the database before taking a backup	6	None
2008-11-11	Conference Questions Pot-Pourri #9: Q&A around compression features	2	None
2008-10-28	New minimally-logged insert functionality in SQL Server 2008	0	None
2008-09-23	TechNet Magazine: October SQL Q&A column	4	None
2008-08-26	Should Microsoft provide a transaction log reader tool?	10	None
2008-08-25	Search Engine Q&A #25: Why isn't my log backup the same size as my log?	1	None
2008-08-20	Search Engine Q&A #24: Why can't the transaction log use instant initialization?	5	None
2008-08-14	Search Engine Q&A #23: My transaction log is full - now what?	0	None
2008-06-08	Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)	6	None
2008-01-31	More on how much transaction log a full backup includes	4	None
2007-11-06	Conference Questions Pot-Pourri #3: unexpected index rebuild results and bulk-logged operations	3	None
2007-11-05	Why won't my log clear in SIMPLE recovery mode? SQL 2000 bug or very large VLFs	2	None
2007-10-25	Debunking a couple of myths around full database backups	8	None
2007-10-19	More on Database Mirroring performance and index maintenance	1	None
2007-10-12	BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it	22	None
2007-10-11	SQL Server 2008: Performance boost for Database Mirroring	1	None
2007-10-08	Inside the Storage Engine: Ghost cleanup in depth	11	None
2007-10-06	Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup	1	None
2007-10-02	CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort	23	None
2007-10-02	Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database	5	None
2007-09-24	Search Engine Q&A #1: Running out of transaction log space	5	None
2007-09-15	Corruption: Last resorts that people try first...	0	None

T-SQL Tuesday (6)

Date	Title	Comments	Rating
2011-01-11	T-SQL Tuesday #14: Resolutions - continue having fun	1	None
2010-11-10	T-SQL Tuesday #012 : Summary of why DBA skills are necessary	2	None
2010-10-25	Invitation to participate in T-SQL Tuesday #12 – Why are DBA skills necessary?	50	None
2010-10-12	T-SQL Tuesday #11: Misconceptions about.... EVERYTHING!!	4	None
2010-07-13	T-SQL Tuesday #008: Top ten mistakes to make when attending a class	26	None
2010-03-09	Inside sys.dm_db_index_physical_stats	6	None

Undocumented commands (18)

Date	Title	Comments	Rating
2010-06-18	Disaster recovery 101: hack-attach a damaged database	6	None
2009-08-19	CHECKDB From Every Angle: How to tell if data purity checks will be run?	6	None
2009-06-16	Finding out who dropped a table using the transaction log	17	None
2009-05-30	Investigating locking and deadlocking with %%lockres%%	0	None
2009-03-19	Ghost cleanup redux	4	None
2009-03-17	FILESTREAM directory structure - where do the GUIDs come from?	4	None
2008-12-05	TechEd: 80 minute video of Corruption Survival Techniques presentation	0	None
2008-11-24	Conference corruption demo scripts and example corrupt databases	3	None
2008-07-25	Search Engine Q&A #21: File header pages, and file header corruption	1	None
2008-07-11	Search Engine Q&A #20: Boot pages, and boot page corruption	3	None
2008-06-09	CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete	6	None
2008-04-08	New script: How much of the database has changed since the last full backup?	9	None
2008-03-20	SQL Server 2008: New (undocumented) physical row locator function	10	None
2008-03-12	Inside The Storage Engine: sp_AllocationMetadata - putting undocumented system catalog views to work	3	None
2007-10-08	Inside the Storage Engine: Ghost cleanup in depth	11	None
2007-10-06	Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup	1	None
2007-10-04	Inside the Storage Engine: Proof that records are not always physically stored in index key order	0	None
2007-10-01	Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back	3	None

Wait Stats (9)

Date	Title	Comments	Rating
2011-07-11	Capturing wait stats for a single operation	5	None
2011-07-01	New whitepapers on latches and spinlocks published	1	None
2011-06-23	MAXDOP configuration survey results	4	None
2011-05-24	Benchmarking: Multiple data files on SSDs (plus the latest Fusion-io driver)	19	None
2011-04-26	SOS_SCHEDULER_YIELD waits and the LOCK_HASH spinlock	10	None
2011-04-13	Advanced performance troubleshooting: waits, latches, spinlocks	7	None
2011-03-24	Survey: have you ever used these DMVs?	7	None
2010-12-09	Wait statistics, or please tell me where it hurts	30	None
2010-10-25	Survey: what is the highest wait on your system?	35	None

Webcasts (1)

Date	Title	Comments	Rating
2009-02-25	TechNet and MSDN webcasts available again	0	None

Where In The World Are Paul And Kimberly (37)

Date	Title	Comments	Rating
2012-01-08	Photos from first part of Indonesia trip	8	None
2011-12-13	Photos from Belize dive trip	10	None
2011-08-11	Photos: Illinois Railway Museum	3	None
2011-07-18	Photos: Japanese Garden at Seattle Arboretum	5	None
2011-05-30	Photos of the USS Silversides WWII submarine	8	None
2011-05-10	Photos from Munich trip in April	4	None
2010-11-26	Bald eagles in Alaska (4th and final part)	7	None
2010-11-24	Bald eagles in Alaska (part 3)	6	None
2010-11-18	Bald eagles in Alaska (part 2)	11	None
2010-11-17	Bald eagles in Alaska (part 1)	16	None
2010-10-01	Summer travels part 1: Alaska (Denali, Seward, Homer)	17	None
2010-08-12	Offline for four weeks...	1	None
2010-06-06	Cool underwater videos of diving in the Cayman Islands - wrecks, octopus, turtles and more!	6	None
2009-10-29	Video of didgeridoo player at Ayers Rock	1	None
2009-10-15	Photos from Warsaw trip in September	2	None
2009-10-14	Penguins, cockatoos, and other sights in Melbourne	1	None
2009-10-08	Photos: Dublin 2009	0	None
2009-09-15	Birds, beasts, sunsets, and scenery on the Olympic Pensinsula	2	None
2009-08-24	Birds, beasts, and boats in rural Texas	1	None
2009-08-09	Cleveland river tour	0	None
2009-07-25	Photos: Lavender farms and coastal scenery around Sequim, WA	0	None
2009-06-24	Dragonflies and other creatures	1	None
2009-06-14	Bird watching on the Gulf Coast of Texas	0	None
2009-05-01	Photos: awesome statues in the Bangkok Imperial Palace	0	None
2009-04-23	Early morning bird-watching in India	1	None
2009-03-27	Photos: amazing wall paintings from the Imperial Palace in Bangkok	0	None
2009-03-04	Photos from India	0	None
2009-02-16	Diving in the Caribbean	1	None
2008-11-04	Vienna: churches and horses	1	None
2008-10-04	Photos and stories from our Scotland trip	0	None
2008-08-11	When Moray Eels get a little close for comfort...	0	None
2008-06-26	The Euclidian Geometry of Eggs	1	None
2008-05-30	Backups, trains, birds, and painfully contrived movie plots	0	None
2008-03-30	Chilling out in the Land of Fire and Ice	0	None
2008-02-03	Personal: Final day in Beijing sightseeing (lots of photos)	3	None
2008-01-27	Personal: And on to Beijing and the Great Wall...	1	None
2008-01-21	Personal: First trip of the year - China!	1	None

Whitepapers (12)

Date	Title	Comments	Rating
2011-07-26	SharePoint 2010 database maintenance whitepaper	7	None
2010-10-19	Myths and misconceptions: 60-page PDF of blog posts	12	None
2010-06-04	Whitepaper on high-availability architectures published	3	None
2009-09-28	SQL Server 2008 High Availability whitepaper published on MSDN	3	None
2009-07-23	New whitepaper on SQL Server 2008 failover clustering	1	None
2009-05-29	SQL Server 2008 Data Compression whitepaper published	0	None
2009-05-13	Are your disk partition offsets, RAID stripe sizes, and NTFS allocation units set correctly?	1	None
2009-04-15	Updated whitepaper: Troubleshooting Performance Problems in SQL Server 2008	1	None
2009-02-15	New whitepaper on tuning Change Data Capture performance	0	None
2009-02-15	New whitepaper on database snapshots	0	None
2008-10-10	SQL Server 2008 FILESTREAM whitepaper published on MSDN	5	None
2008-09-02	SQL Server2008: New whitepaper on combining transactional replication and database mirroring	0	None

Uncategorized (7)

Date	Title	Comments	Rating
2011-12-30	2011 review: the year by the numbers	4	None
2011-10-13	SQL Connections Spring 2012: Call for Abstracts	0	None
2011-06-24	Disaster recovery 101: dealing with negative SPIDS (-2 and -3)	5	None
2011-01-26	So why do you want to come to our training? And the winner is...	12	None
2010-01-14	Arduino projects: LED 10-bar array	2	None
2008-09-10	SQL Server 2008 public class - database infrastructure and scalability	0	None
2008-09-08	How the on-disk data structures fit together	0	None