Archive

Auditing
Backup/Restore
Bad Advice
BlogEngine.NET
Books
Change Data Capture
CHECKDB From Every Angle
Classes
Compression
Conference Questions Pot-Pourri
Conferences
Constraints
Corruption
Database Maintenance
Database Mirroring
Database Snapshots
DBCC
Disaster Recovery
Encryption
Example Scripts
Extended Events
FILESTREAM
Fragmentation
General
High Availability
Indexes From Every Angle
Inside the Storage Engine
Install / Setup
Interviews
Involuntary DBA
IO Subsystems
Jokes
Locking
Log Shipping
On-Disk Structures
Page Checksums
Partial Database Availability
Partitioning
Performance
Personal
Policy Based Management
Products
Repair
Replication
Resource Governor
Search Engine Q and A
Security
Shrink
Snapshot Isolation
Sparse Columns
SQL Agent
SQL Server 2008
SQLIOSim
TechNet Magazine
Tools
Trace Flags
Transaction Log
Undocumented commands
Where In The World Are Paul And Kimberly
Whitepapers
Uncategorized

Auditing (2)

Date	Title	Comments	Rating
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	1	None

Backup/Restore (32)

Date	Title	Comments	Rating
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	1	None
2008-10-29	High-end backup compression numbers	0	None
2008-10-26	Planning a backup strategy - where to start?	0	None
2008-09-23	TechNet Magazine: October SQL Q&A column	0	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?	3	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?	0	None
2008-08-11	How to tell if you have instant initialization enabled?	2	None
2008-07-08	TechNet Magazine: Effective Database Maintenance article and August 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-04-08	New script: How much of the database has changed since the last full backup?	2	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	2	None
2008-02-15	SQL Server 2008 JumpStart	1	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	3	None
2008-01-09	SQL Server 2008: Backup Compression CPU Cost	3	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	3	None
2007-10-15	BACKUP WITH COPY_ONLY - how to avoid breaking the backup chain	3	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	13	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	0	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	0	None

Bad Advice (12)

Date	Title	Comments	Rating
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	TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database	4	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	0	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	8	None
2007-10-12	BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it	13	None
2007-09-15	Corruption: Last resorts that people try first...	0	None
2007-09-13	Common bad advice around disaster recovery	1	None

BlogEngine.NET (0)

Date	Title	Comments	Rating

Books (1)

Date	Title	Comments	Rating
2008-10-19	SQL Server 2008 Internals available to pre-order on Amazon.com	0	None

Change Data Capture (4)

Date	Title	Comments	Rating
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?	3	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	0	None
2008-02-15	SQL Server 2008 JumpStart	1	None

CHECKDB From Every Angle (19)

Date	Title	Comments	Rating
2008-11-06	Corruption bug that people are hitting: Msg 8914 - PFS free space	0	None
2008-10-19	SQL Server 2008 Internals available to pre-order on Amazon.com	0	None
2008-08-29	TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database	4	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	0	None
2008-06-12	TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix Msg 8992: corrupt system tables	4	None
2008-06-09	CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete	0	None
2008-05-22	CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216	1	None
2008-03-13	CHECKDB From Every Angle: When did DBCC CHECKDB last run successfully?	1	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	0	None
2007-11-19	CHECKDB From Every Angle: Consistency Checking Options for a VLDB	0	None
2007-11-16	CHECKDB From Every Angle: Can CHECKDB repair everything?	0	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	0	None
2007-11-06	CHECKDB From Every Angle: Why would CHECKDB run out of space?	0	None
2007-10-02	CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort	7	None
2007-09-22	CHECKDB From Every Angle: Automate your database integrity checks with SMO	0	None
2007-09-15	CHECKDB From Every Angle: Complete description of all CHECKDB stages	0	None
2007-09-15	Corruption: Last resorts that people try first...	0	None

Classes (6)

Date	Title	Rating
2008-09-01	Last chance to register for our class in Scotland next week	None
2008-08-11	BI classes in Iceland in September	None
2008-08-11	User groups and classes in August and September	None
2008-07-10	2008 Conferences: TechEd EMEA, SQL Connections, PASS Community Summit	None
2008-07-10	Dev Connections SQL Power Workshop on SQL Server 2008, October, San Francisco	None
2008-06-23	Public classes in the UK in September	None

Compression (5)

Date	Title	Comments	Rating
2008-11-11	Conference Questions Pot-Pourri #9: Q&A around compression features	1	None
2008-09-10	Dev Connections newsletter	0	None
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	3	None
2008-02-15	SQL Server 2008 JumpStart	1	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None

Conference Questions Pot-Pourri (9)

Date	Title	Comments	Rating
2008-11-11	Conference Questions Pot-Pourri #9: Q&A around compression features	1	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 (25)

Date	Title	Comments	Rating
2008-09-10	Dev Connections newsletter	0	None
2008-08-13	SQL Connections Spring 2009: Call for Abstracts	4	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	TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix Msg 8992: corrupt system tables	4	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	1	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 (2)

Date	Title	Comments	Rating
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

Corruption (29)

Date	Title	Comments	Rating
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	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	TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database	4	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	0	None
2008-08-11	Search Engine Q&A #22: Can all page types be single-page restored?	0	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	0	None
2008-06-12	TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix Msg 8992: corrupt system tables	4	None
2008-06-09	CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete	0	None
2008-05-22	CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216	1	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?	1	None
2008-02-04	Search Engine Q&A #14: Beware 3rd party file-system drivers with DBCC CHECKDB	0	None
2007-11-16	CHECKDB From Every Angle: Can CHECKDB repair everything?	0	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	0	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	7	None
2007-10-02	Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database	1	None
2007-09-27	SQL Server 2008: Automatic Page Repair with Database Mirroring	0	None
2007-09-15	Corruption: Last resorts that people try first...	0	None
2007-09-13	Common bad advice around disaster recovery	1	None
2007-09-12	How to tell if the IO subsystem is causing corruptions?	0	None
2007-09-04	Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors	0	None

Database Maintenance (34)

Date	Title	Comments	Rating
2008-09-23	TechNet Magazine: October SQL Q&A column	0	None
2008-08-30	Follow-on from instant initialization privilege checking	4	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?	7	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?	3	None
2008-08-20	Search Engine Q&A #24: Why can't the transaction log use instant initialization?	2	None
2008-08-20	Can GUID cluster keys cause non-clustered index fragmentation?	2	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?	0	None
2008-08-11	How to tell if you have instant initialization enabled?	2	None
2008-07-08	TechNet Magazine: Effective Database Maintenance article and August 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-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?	2	None
2008-03-13	CHECKDB From Every Angle: When did DBCC CHECKDB last run successfully?	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	0	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	8	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	0	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	0	None
2007-11-13	Auto-shrink – turn it OFF!	0	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	1	None
2007-10-19	More on Database Mirroring performance and index maintenance	0	None
2007-10-12	BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it	13	None
2007-10-05	Indexes From Every Angle: How can you tell if an index is being used?	2	None
2007-09-28	Search Engine Q&A #2: Moving a database while Database Mirroring is running	1	None

Database Mirroring (21)

Date	Title	Comments	Rating
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	1	None
2008-09-23	TechNet Magazine: October SQL Q&A column	0	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	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	1	None
2008-01-13	Dual Database Monitor now available to order	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	0	None
2007-10-11	SQL Server 2008: Performance boost for Database Mirroring	0	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	1	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	0	None

Database Snapshots (5)

Date	Title	Comments	Rating
2008-05-22	CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216	1	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	0	None
2008-02-04	Search Engine Q&A #14: Beware 3rd party file-system drivers with DBCC CHECKDB	0	None
2008-01-30	Database snapshots - when things go wrong	2	None
2007-11-14	Conference Questions Pot-Pourri #5: Database snapshots, and creating a snapshot of a single filegroup	2	None

DBCC (20)

Date	Title	Comments	Rating
2008-10-19	SQL Server 2008 Internals available to pre-order on Amazon.com	0	None
2008-08-29	TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database	4	None
2008-08-27	Search Engine Q&A #26: Myths around causing corruption	0	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	TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix Msg 8992: corrupt system tables	4	None
2008-06-09	CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete	0	None
2008-05-22	CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216	1	None
2008-03-13	CHECKDB From Every Angle: When did DBCC CHECKDB last run successfully?	1	None
2007-12-23	Patents and parties	0	None
2007-11-19	CHECKDB From Every Angle: Consistency Checking Options for a VLDB	0	None
2007-11-16	CHECKDB From Every Angle: Can CHECKDB repair everything?	0	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	0	None
2007-11-13	Auto-shrink – turn it OFF!	0	None
2007-10-02	CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort	7	None
2007-10-01	Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back	0	None
2007-09-22	CHECKDB From Every Angle: Automate your database integrity checks with SMO	0	None
2007-09-15	CHECKDB From Every Angle: Complete description of all CHECKDB stages	0	None
2007-09-15	Corruption: Last resorts that people try first...	0	None

Disaster Recovery (32)

Date	Title	Comments	Rating
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	TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database	4	None
2008-08-29	SQL Server 2008: How to rebuild the system databases?	0	None
2008-08-26	Should Microsoft provide a transaction log reader tool?	7	None
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	3	None
2008-08-11	Search Engine Q&A #22: Can all page types be single-page restored?	0	None
2008-08-11	How to tell if you have instant initialization enabled?	2	None
2008-06-12	TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix Msg 8992: corrupt system tables	4	None
2008-06-09	CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete	0	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	0	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?	0	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	0	None
2007-10-15	BACKUP WITH COPY_ONLY - how to avoid breaking the backup chain	3	None
2007-10-12	BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it	13	None
2007-10-11	SQL Server 2008: Performance boost for Database Mirroring	0	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	7	None
2007-10-02	Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database	1	None
2007-09-15	Corruption: Last resorts that people try first...	0	None
2007-09-13	Common bad advice around disaster recovery	1	None
2007-09-04	Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors	0	None

Encryption (5)

Date	Title	Comments	Rating
2008-08-23	SQL Server 2008: Does my database contain Enterprise-only features?	3	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	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	1	None
2007-12-12	Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?	0	None

Example Scripts (34)

Date	Title	Comments	Rating
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?	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-11	How to tell if you have instant initialization enabled?	2	None
2008-06-12	TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix Msg 8992: corrupt system tables	4	None
2008-05-22	CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216	1	None
2008-04-28	SQL Server 2008: Sparse columns and XML COLUMN_SET	0	None
2008-04-08	New script: How much of the database has changed since the last full backup?	2	None
2008-03-12	Inside The Storage Engine: sp_AllocationMetadata - putting undocumented system catalog views to work	1	None
2008-03-12	Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials	0	None
2008-02-05	Search Engine Q&A #15: Mirrored backups	1	None
2008-01-30	Database snapshots - when things go wrong	2	None
2008-01-14	SQL Server 2008: Partition-level lock escalation details and examples	2	None
2008-01-04	Katmai bug: SSMS doesn't drop database locks when leaving the context of a database	2	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?	1	None
2007-11-13	Auto-shrink – turn it OFF!	0	None
2007-10-25	Debunking a couple of myths around full database backups	3	None
2007-10-20	Indexes From Every Angle: Using CROSS APPLY with sys.dm_db_index_physical_stats	1	None
2007-10-15	BACKUP WITH COPY_ONLY - how to avoid breaking the backup chain	3	None
2007-10-12	BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it	13	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	2	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?	2	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	7	None
2007-10-02	Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database	1	None
2007-10-01	Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back	0	None
2007-09-30	Inside the Storage Engine: Anatomy of a record	2	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	1	None
2007-09-22	CHECKDB From Every Angle: Automate your database integrity checks with SMO	0	None
2007-09-04	Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors	0	None

Extended Events (2)

Date	Title	Comments	Rating
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	1	None

FILESTREAM (9)

Date	Title	Comments	Rating
2008-10-10	SQL Server 2008 FILESTREAM whitepaper published on MSDN	1	None
2008-09-10	RunAs Radio interview on FILESTREAM	0	None
2008-08-25	High-performance FILESTREAM tips and tricks	0	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	3	None
2008-03-07	SQL Server 2008: Changes to enabling FILESTREAM from CTP-6 onwards	0	None
2008-02-15	SQL Server 2008 JumpStart	1	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 (1)

Date	Title	Comments	Rating
2008-08-20	Can GUID cluster keys cause non-clustered index fragmentation?	2	None

General (19)

Date	Title	Comments	Rating
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-03-31	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

High Availability (7)

Date	Title	Comments	Rating
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?	2	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 (19)

Date	Title	Comments	Rating
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	0	None
2008-08-20	Can GUID cluster keys cause non-clustered index fragmentation?	2	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	8	None
2008-01-17	SQL Server 2008: Spatial indexes	0	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!	0	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	1	None
2007-10-05	Indexes From Every Angle: How can you tell if an index is being used?	2	None
2007-10-05	Indexes From Every Angle: What happens to non-clustered indexes when the table structure is changed?	0	None

Inside the Storage Engine (20)

Date	Title	Comments	Rating
2008-11-06	Corruption bug that people are hitting: Msg 8914 - PFS free space	0	None
2008-10-19	SQL Server 2008 Internals available to pre-order on Amazon.com	0	None
2008-09-02	Why does the buffer pool contain so many dirty tempdb pages?	0	None
2008-08-26	Inside the Storage Engine: What's in the buffer pool?	4	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	6	None
2008-03-14	Inside The Storage Engine: GAM, SGAM, PFS and other allocation maps	0	None
2008-03-12	Inside The Storage Engine: sp_AllocationMetadata - putting undocumented system catalog views to work	1	None
2008-01-31	More on how much transaction log a full backup includes	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?	1	None
2007-10-08	Inside the Storage Engine: Ghost cleanup in depth	2	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	0	None
2007-10-03	Inside the Storage Engine: Anatomy of an extent	0	None
2007-10-03	Inside the Storage Engine: Anatomy of a page	5	None
2007-10-01