Archive

RSSAuditing (5)

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

RSSBackup/Restore (57)

Date Title Comments Rating
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 7 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 5 None
2009-03-25 Is running repair on msdb safe? 2 None
2009-03-25 Msg 602, Level 21, State 50, Line 1 0 None
2009-03-23 Measuring 'churn' in a SharePoint content database using SQL Server 0 None
2009-03-13 Importance of validating backups 5 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 1 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? 8 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 7 None
2007-10-15 BACKUP WITH COPY_ONLY - how to avoid breaking the backup chain 6 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 20 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 6 None

RSSBad Advice (20)

Date Title Comments Rating
2009-06-24 Why you should not shrink your data files 16 None
2009-05-29 Misconceptions around the log and log backups: how to convince yourself 8 None
2009-05-15 Misconceptions around database repair 4 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 TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database 15 None
2008-08-27 Search Engine Q&A #26: Myths around causing corruption 1 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 20 None
2007-09-15 Corruption: Last resorts that people try first... 0 None
2007-09-13 Common bad advice around disaster recovery 0 None

RSSBenchmarking (7)

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

RSSBlogEngine.NET (0)

Date Title Comments Rating

RSSBooks (6)

Date Title Comments Rating
2009-12-30 Once in a lifetime: 100 books in a year 25 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

RSSBugfixes (12)

Date Title Comments Rating
2010-01-25 DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6 2 None
2010-01-13 Diskeeper 10 Intelliwrite corruption bug 3 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

RSSChange Data Capture (7)

Date Title Comments Rating
2009-12-09 What can cause log reads and other transaction log questions 7 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

RSSCHECKDB From Every Angle (42)

Date Title Comments Rating
2010-02-26 Sample corrupt databases to play with 9 None
2010-01-25 DBCC CHECKFILEGROUP bug fixed in 2008 SP1 CU6 2 None
2010-01-13 Diskeeper 10 Intelliwrite corruption bug 3 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 3 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 0 None
2009-05-15 Misconceptions around database repair 4 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? 0 None
2009-03-27 Importance of how you run consistency checks 2 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 1 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 TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database 15 None
2008-08-27 Search Engine Q&A #26: Myths around causing corruption 1 None
2008-06-12 TechEd Demo: Using the SQL 2005 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 5 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? 4 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 6 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 1 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 20 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 1 None
2007-09-15 Corruption: Last resorts that people try first... 0 None

RSSCheckpoint (4)

Date Title Comments Rating
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 7 None
2009-10-07 What does checkpoint do for tempdb? 2 None
2009-09-27 How do checkpoints work and what gets logged 4 None

RSSClasses (18)

Date Title Comments Rating
2010-03-03 Still some spots available on the 5-day class in Boston in 3 weeks 5 None
2010-02-11 New advanced performance classes in Melbourne, Australia, April 2010 0 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 1 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

RSSCompression (7)

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

RSSConference 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

RSSConferences (42)

Date Title Comments Rating
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 1 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 TechEd Demo: Using the SQL 2005 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

RSSConstraints (3)

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

RSSConsulting (1)

Date Title Comments Rating
2010-01-19 Remote DB maintenance auditing promotion 3 None

RSSCorruption (56)

Date Title Comments Rating
2010-02-26 Sample corrupt databases to play with 9 None
2010-01-13 Diskeeper 10 Intelliwrite corruption bug 3 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 4 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 2 None
2009-03-25 Is running repair on msdb safe? 2 None
2009-03-25 Msg 602, Level 21, State 50, Line 1 0 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 1 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 1 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 TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database 15 None
2008-08-27 Search Engine Q&A #26: Myths around causing corruption 1 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 TechEd Demo: Using the SQL 2005 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 5 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? 4 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 1 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 20 None
2007-10-02 Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database 4 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

RSSDatabase Maintenance (95)

Date Title Comments Rating
2010-03-09 Inside sys.dm_db_index_physical_stats 4 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 3 None
2009-06-24 Weekly survey: how often do you run consistency checks? 0 None
2009-06-24 Importance of data file size management 3 None
2009-06-24 Why you should not shrink your data files 16 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 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-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? 0 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 10 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 5 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 2 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 1 None
2009-03-13 Weekly survey: index maintenance plan 2 None
2009-03-13 Importance of validating backups 5 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 2 None
2009-02-23 A little-known sign of impending doom: error 825 1 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 1 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? 3 None
2008-08-20 Can GUID cluster keys cause non-clustered index fragmentation? 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-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? 8 None
2008-03-13 CHECKDB From Every Angle: When did DBCC CHECKDB last run successfully? 4 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 6 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 1 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 0 None
2007-10-12 BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it 20 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

RSSDatabase Mirroring (31)

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

RSSDatabase Snapshots (11)

Date Title Comments Rating
2010-01-07 Misconceptions around database snapshots and transaction rollbacks 8 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 0 None
2009-05-04 Do transactions rollback when DBCC CHECKDB runs? 0 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 2 None
2007-11-14 Conference Questions Pot-Pourri #5: Database snapshots, and creating a snapshot of a single filegroup 2 None

RSSDBCC (43)

Date Title Comments Rating
2010-02-26 Sample corrupt databases to play with 9 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 16 None
2009-06-15 Issues around DBCC CHECKDB and the use of hidden database snapshots 0 None
2009-05-15 Misconceptions around database repair 4 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? 0 None
2009-03-27 Importance of how you run consistency checks 2 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 1 None
2008-10-19 SQL Server 2008 Internals available to pre-order on Amazon.com 2 None
2008-08-29 TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database 15 None
2008-08-27 Search Engine Q&A #26: Myths around causing corruption 1 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 13 None
2008-06-09 CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete 5 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? 4 None
2007-12-23 Patents and parties 0 None
2007-11-19 CHECKDB From Every Angle: Consistency Checking Options for a VLDB 6 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 1 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 20 None
2007-10-01 Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back 2 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 1 None
2007-09-15 Corruption: Last resorts that people try first... 0 None

RSSDisaster Recovery (56)

Date Title Comments Rating
2010-02-26 Sample corrupt databases to play with 9 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 4 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 5 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 1 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 TechEd Demo: 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 TechEd Demo: Using the SQL 2005 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 5 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 1 None
2007-10-15 BACKUP WITH COPY_ONLY - how to avoid breaking the backup chain 6 None
2007-10-12 BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it 20 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 20 None
2007-10-02 Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database 4 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

RSSElectronics (1)

Date Title Comments Rating
2009-06-02 I like it when people send me electronics 1 None

RSSEncryption (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

RSSExample Scripts (55)

Date Title Comments Rating
2010-02-26 Sample corrupt databases to play with 9 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 15 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 1 None
2009-03-13 Great script for automating database maintenance 0 None
2009-03-11 FILESTREAM directory structure 2 None
2009-02-25 TechNet and MSDN webcasts available again 0 None
2009-02-23 Getting historical deadlock info using extended events 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-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 1 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? 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? 4 None
2008-06-12 TechEd Demo: Using the SQL 2005 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? 8 None
2008-03-12 Inside The Storage Engine: sp_AllocationMetadata - putting undocumented system catalog views to work 2 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 2 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? 3 None
2007-11-13 Auto-shrink – turn it OFF! 12 None
2007-10-25 Debunking a couple of myths around full database backups 7 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 6 None
2007-10-12 BACKUP LOG WITH NO_LOG - use, abuse, and undocumented trace flags to stop it 20 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 7 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 20 None
2007-10-02 Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database 4 None
2007-10-01 Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back 2 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

RSSExtended Events (6)

Date Title Comments Rating
2009-10-15 Tracking expensive queries with extended events in SQL 2008 3 None
2009-02-23 Getting historical deadlock info using extended events 1 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

RSSFailover Clusters (4)

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

RSSFILESTREAM (16)

Date Title Comments Rating
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? 3 None
2009-03-11 FILESTREAM directory structure 2 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 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 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

RSSFragmentation (13)

Date Title Comments Rating
2010-03-09 Inside sys.dm_db_index_physical_stats 4 None
2009-12-08 Where do the Books Online index fragmentation thresholds come from? 11 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? 6 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 1 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? 4 None

RSSFusion-io (1)

Date Title Comments Rating
2010-03-03 New hardware to play with: Fusion-io SSDs 17 None

RSSGeneral (44)

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

RSSHardware (8)

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

RSSHigh Availability (22)

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

RSSIndexes From Every Angle (31)

Date Title Comments Rating
2010-03-09 Inside sys.dm_db_index_physical_stats 4 None
2009-12-08 Where do the Books Online index fragmentation thresholds come from? 11 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? 6 None
2009-03-27 Index rebuilds depend on stats, which are updated by index rebuilds?!? 0 None
2009-03-21 Importance of index maintenance 1 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 1 None
2008-08-20 Can GUID cluster keys cause non-clustered index fragmentation? 4 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 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! 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

RSSInside the Storage Engine (41)

Date Title Comments Rating
2010-03-09 Inside sys.dm_db_index_physical_stats 4 None
2010-01-08 Turning off the ghost cleanup task for a performance gain 10 None
2009-11-13 Lock logging and fast recovery 6 None
2009-10-07 What does checkpoint do for tempdb? 2 None
2009-09-27 How do checkpoints work and what gets logged 4 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? 6 None
2009-05-04 Misconceptions around null bitmap size 3 None
2009-04-30 Performance bug: NOLOCK scans involving off-row LOB data 12 None
2009-04-23 Misconceptions around TF 1118 10 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 1 None
2009-03-11 FILESTREAM directory structure 2 None
2009-03-10 Misconceptions around instant file initialization 9 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? 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 10 None
2008-03-14 Inside The Storage Engine: GAM, SGAM, PFS and other allocation maps 2 None
2008-03-12 Inside The Storage Engine: sp_AllocationMetadata - putting undocumented system catalog views to work 2 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? 3 None
2007-10-08 Inside the Storage Engine: Ghost cleanup in depth 7 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 0 None
2007-10-03 Inside the Storage Engine: Anatomy of a page 16 None
2007-10-01 Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back 2 None
2007-09-30 Inside the Storage Engine: Anatomy of a record 5 None

RSSInstall / 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

RSSInstant Initialization (4)

Date Title Comments Rating
2009-06-24 Importance of data file size management 3 None
2009-03-10 Misconceptions around instant file initialization 9 None
2008-08-20 Search Engine Q&A #24: Why can't the transaction log use instant initialization? 3 None
2008-08-11 How to tell if you have instant initialization enabled? 4 None

RSSInterviews (17)

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

RSSInvoluntary DBA (52)

Date Title Comments Rating
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 3 None
2009-06-24 Weekly survey: how often do you run consistency checks? 0 None
2009-06-24 Importance of data file size management 3 None
2009-06-24 Why you should not shrink your data files 16 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? 0 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 5 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 2 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 0 None
2009-03-21 Importance of index maintenance 1 None
2009-03-13 Weekly survey: index maintenance plan 2 None
2009-03-13 Importance of validating backups 5 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 2 None
2009-02-23 A little-known sign of impending doom: error 825 1 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 TechEd Demo: 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

RSSIO Subsystems (21)

Date Title Comments Rating
2010-03-05 TechNet Magazine: March 2010 SQL Q&A column 0 None
2010-03-03 New hardware to play with: Fusion-io SSDs 17 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 0 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 1 None
2008-08-27 Search Engine Q&A #26: Myths around causing corruption 1 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

RSSJokes (7)

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

RSSLOB data (5)

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

RSSLocking (9)

Date Title Comments Rating
2009-11-13 Lock logging and fast recovery 6 None
2009-05-30 Investigating locking and deadlocking with %%lockres%% 0 None
2009-02-23 Getting historical deadlock info using extended events 1 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? 3 None
2007-10-02 SQL Server 2008: Lock escalation changes 1 None

RSSLog Shipping (7)

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

RSSMemory (5)

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

RSSMisconceptions (10)

Date Title Comments Rating
2010-01-07 Misconceptions around database snapshots and transaction rollbacks 8 None
2009-06-24 Why you should not shrink your data files 16 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 4 None
2009-05-06 Misconceptions around adding columns to a table 1 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 3 None
2009-04-23 Misconceptions around TF 1118 10 None

RSSOn-Disk Structures (40)

Date Title Comments Rating
2010-02-26 Sample corrupt databases to play with 9 None
2009-11-13 Lock logging and fast recovery 6 None
2009-09-27 How do checkpoints work and what gets logged 4 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? 6 None
2009-05-06 Misconceptions around adding columns to a table 1 None
2009-05-04 Misconceptions around null bitmap size 3 None
2009-04-23 Misconceptions around TF 1118 10 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 0 None
2009-03-22 IAM page corruption examples 1 None
2009-03-19 Ghost cleanup redux 1 None
2009-03-11 FILESTREAM directory structure 2 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 1 None
2008-08-20 Search Engine Q&A #24: Why can't the transaction log use instant initialization? 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 5 None
2008-04-08 New script: How much of the database has changed since the last full backup? 8 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 2 None
2008-03-12 Inside The Storage Engine: sp_AllocationMetadata - putting undocumented system catalog views to work 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? 3 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 7 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 0 None
2007-10-03 Inside the Storage Engine: Anatomy of a page 16 None
2007-10-01 Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back 2 None
2007-09-30 Inside the Storage Engine: Anatomy of a record 5 None

RSSPage Checksums (12)

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

RSSPartial 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

RSSPartitioning (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

RSSPerformance (63)

Date Title Comments Rating
2010-03-09 Inside sys.dm_db_index_physical_stats 4 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) 27 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 10 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? 6 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 1 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 10 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? 4 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 3 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 0 None
2007-10-11 SQL Server 2008: Performance boost for Database Mirroring 0 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 2 None

RSSPersonal (36)

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

RSSPolicy 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

RSSProducts (3)

Date Title Comments Rating
2008-02-19 Administrivia 1 None
2008-01-13 Dual Database Monitor now available to order 0 None
2007-12-05 Question for all of you.... interest in printouts of our workshops? 5 None

RSSQuery Processor (1)

Date Title Comments Rating
2009-10-08 Which index will SQL Server use to count all rows 6 None

RSSRepair (17)

Date Title Comments Rating
2009-05-15 Misconceptions around database repair 4 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 1 None
2008-09-23 TechNet Magazine: October SQL Q&A column 4 None
2008-08-29 TechEd Demo: Creating, detaching, re-attaching, and fixing a suspect database 15 None
2008-08-27 Search Engine Q&A #26: Myths around causing corruption 1 None
2008-06-12 TechEd Demo: Using the SQL 2005 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 5 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 1 None
2007-10-02 CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort 20 None
2007-09-15 Corruption: Last resorts that people try first... 0 None
2007-09-13 Common bad advice around disaster recovery 0 None

RSSReplication (10)

Date Title Comments Rating
2009-12-09 What can cause log reads and other transaction log questions 7 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
2008-01-13 Dual Database Monitor now available to order 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

RSSResource Governor (5)

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

RSSSearch 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 1 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? 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? 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 4 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

RSSSecurity (7)

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

RSSSharepoint (3)

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

RSSShrink (9)

Date Title Comments Rating
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 3 None
2009-06-24 Why you should not shrink your data files 16 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 1 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

RSSSnapshot 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

RSSSparse 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

RSSSQL 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 2 None
2009-02-23 A little-known sign of impending doom: error 825 1 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? 4 None
2007-10-06 How does daylight savings time affect disaster recovery? 4 None

RSSSQL Server 2008 (89)

Date Title Comments Rating
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 10 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 2 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 1 None
2009-03-19 Ghost cleanup redux 1 None
2009-03-17 FILESTREAM directory structure - where do the GUIDs come from? 3 None
2009-03-13 Importance of validating backups 5 None
2009-03-11 FILESTREAM directory structure 2 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 1 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? 8 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 3 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 0 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 0 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 2 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

RSSSQLIOSim (1)

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

RSSSSDs (1)

Date Title Comments Rating
2010-03-03 New hardware to play with: Fusion-io SSDs 17 None

RSSStatistics (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

RSSSurveys (38)

Date Title Comments Rating
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 3 None
2009-06-24 Weekly survey: how often do you run consistency checks? 0 None
2009-06-24 Importance of data file size management 3 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 5 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 2 None
2009-03-21 Weekly survey: method of running consistency checks 0 None
2009-03-21 Importance of index maintenance 1 None
2009-03-13 Weekly survey: index maintenance plan 2 None
2009-03-13 Importance of validating backups 5 None
2009-03-10 Misconceptions around instant file initialization 9 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

RSSTechNet Magazine (19)

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

RSStempdb (6)

Date Title Comments Rating
2009-10-07 What does checkpoint do for tempdb? 2 None
2009-04-23 Misconceptions around TF 1118 10 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

RSSTGIF (3)

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

RSSTools (21)

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

RSSTrace Flags (9)

Date Title Comments Rating
2010-01-08 Turning off the ghost cleanup task for a performance gain 10 None
2009-04-23 Misconceptions around TF 1118 10 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 20 None
2007-10-11 SQL Server 2008: Performance boost for Database Mirroring 0 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 2 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

RSSTransaction Log (46)

Date Title Comments Rating
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) 27 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 7 None
2009-11-13 Lock logging and fast recovery 6 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 4 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 15 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? 6 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 5 None
2009-04-03 Weekly survey: transaction log size management 5 None
2009-03-19 Ghost cleanup redux 1 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? 3 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 7 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 20 None
2007-10-11 SQL Server 2008: Performance boost for Database Mirroring 0 None
2007-10-08 Inside the Storage Engine: Ghost cleanup in depth 7 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 20 None
2007-10-02 Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database 4 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

RSSUndocumented commands (17)

Date Title Comments Rating
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 15 None
2009-05-30 Investigating locking and deadlocking with %%lockres%% 0 None
2009-03-19 Ghost cleanup redux 1 None
2009-03-17 FILESTREAM directory structure - where do the GUIDs come from? 3 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 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-09 CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete 5 None
2008-04-08 New script: How much of the database has changed since the last full backup? 8 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 2 None
2007-10-08 Inside the Storage Engine: Ghost cleanup in depth 7 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 2 None

RSSWebcasts (1)

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

RSSWhere In The World Are Paul And Kimberly (24)

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

RSSWhitepapers (9)

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

RSSUncategorized (3)

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

Total

460 posts
1260 comments
0 raters

Theme design by Nukeation based on Jelle Druyts