About Contact Us

Whitepaper on high-availability architectures published

Posted on: June 4, 2010 11:00 am

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

Posted on: April 30, 2010 9:19 am

A SQL Server DBA myth a day: (23/30) lock escalation

Posted on: April 23, 2010 12:14 pm

Tracking expensive queries with extended events in SQL 2008

Posted on: October 15, 2009 4:13 pm

SQL Server 2008 High Availability whitepaper published on MSDN

Posted on: September 28, 2009 12:42 pm

DBCC CHECKFILEGROUP bug on SQL Server 2008

Posted on: September 23, 2009 1:54 am

New whitepaper on Resource Governor

Posted on: July 18, 2009 12:19 pm

Scripting schema AND data with SSMS in SQL 2008

Posted on: June 26, 2009 10:16 am

SQL Server 2008 Data Compression whitepaper published

Posted on: May 29, 2009 12:59 pm

Importance of having a manageable environment

Posted on: May 10, 2009 11:22 am

What is FSAgent.exe and why does it have lots of waits?

Posted on: May 6, 2009 4:21 pm

Misconceptions around FILESTREAM storage

Posted on: May 6, 2009 1:47 pm

Misconceptions around TF 1118

Posted on: April 23, 2009 9:19 pm

FILESTREAM garbage collection

Posted on: April 21, 2009 9:29 pm

SQL Server 2008 SP1 has been released

Posted on: April 7, 2009 7:17 pm

Importance of choosing the right LOB storage technique

Posted on: April 3, 2009 8:46 am

TechNet Magazine: feature article on Common SQL Server Security Issues and Solutions

Posted on: April 3, 2009 7:35 am

How to change a default constraint

Posted on: March 22, 2009 8:04 am

IAM page corruption examples

Posted on: March 22, 2009 6:14 am

Importance of index maintenance

Posted on: March 21, 2009 3:50 pm

Ghost cleanup redux

Posted on: March 19, 2009 10:44 am

FILESTREAM directory structure – where do the GUIDs come from?

Posted on: March 17, 2009 4:19 pm

Importance of validating backups

Posted on: March 13, 2009 5:17 pm

FILESTREAM directory structure

Posted on: March 11, 2009 3:50 pm

Our book has been published!

Posted on: March 11, 2009 3:24 pm

New whitepaper on SQL Server Audit in 2008

Posted on: March 2, 2009 4:41 pm

Rolling upgrade using database mirroring (and a bug in 2008 RTM)

Posted on: February 24, 2009 11:00 am

Getting historical deadlock info using extended events

Posted on: February 23, 2009 1:49 pm

Couple of nasty FILESTREAM bugs fixed in 2008 RTM CU1

Posted on: February 23, 2009 12:29 pm

SQL Server 2008 system table map PDF

Posted on: February 16, 2009 4:34 am

TechNet Magazine: feature article on Advanced Troubleshooting with Extended Events

Posted on: December 5, 2008 6:31 am

SQL Server 2008: Using Change Data Capture with SSIS

Posted on: December 3, 2008 6:27 pm

Life on SQL Server 2008 – PASS interview with a large-scale user

Posted on: November 25, 2008 10:23 am

Conference Questions Pot-Pourri #9: Q&A around compression features

Posted on: November 11, 2008 9:29 am

High-end backup compression numbers

Posted on: October 29, 2008 8:36 pm

New minimally-logged insert functionality in SQL Server 2008

Posted on: October 28, 2008 1:26 am

Sparse columns: misleading info in Books Online

Posted on: October 19, 2008 3:30 pm

TechNet Magazine: Article on Tracking Changes in Your Enterprise Database

Posted on: October 14, 2008 4:01 pm

SQL Server 2008 FILESTREAM whitepaper published on MSDN

Posted on: October 10, 2008 4:35 pm

Dev Connections newsletter

Posted on: September 10, 2008 7:29 am

RunAs Radio interview on FILESTREAM

Posted on: September 10, 2008 7:13 am

SQL Server2008: New whitepaper on combining transactional replication and database mirroring

Posted on: September 2, 2008 8:05 pm

Better behavior with suspect databases in SQL Server 2008

Posted on: September 2, 2008 9:44 am

SQL Server 2008: How to rebuild the system databases?

Posted on: August 29, 2008 5:04 pm

High-performance FILESTREAM tips and tricks

Posted on: August 25, 2008 10:53 pm

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

Posted on: August 23, 2008 4:06 pm

TechEd Online Panel Video: Building a Solid High-Availability Strategy

Posted on: July 21, 2008 6:00 pm

We’re writing a book – finally!

Posted on: July 10, 2008 10:37 pm

Dev Connections SQL Power Workshop on SQL Server 2008, October, San Francisco

Posted on: July 10, 2008 7:07 pm

SQL Server 2008: Sparse columns and XML COLUMN_SET

Posted on: April 28, 2008 11:05 pm

SQL Server 2008: Sparse Columns

Posted on: April 18, 2008 1:46 am

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

Posted on: April 8, 2008 4:49 pm

SQL Server 2008: How to get FILESTREAM and partitioning to work

Posted on: April 7, 2008 11:07 pm

SQL Server 2008: New (undocumented) physical row locator function

Posted on: March 20, 2008 12:25 am

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

Posted on: March 12, 2008 5:23 pm

TechNet Radio interview with Paul and Kimberly on SQL Server 2008 – Part 2

Posted on: March 11, 2008 11:45 pm

SQL Server Magazine Connections Fall 2008 Call For Abstracts

Posted on: March 10, 2008 9:29 pm

SQL Server 2008: FILESTREAM performance

Posted on: March 9, 2008 5:45 pm

SQL Server 2008: Changes to enabling FILESTREAM from CTP-6 onwards

Posted on: March 7, 2008 7:10 pm

TechNet Radio interview with Paul and Kimberly on SQL Server 2008 – Part 1

Posted on: March 5, 2008 2:31 am

Conferences coming up: SQL Connections in April and TechEd US in June

Posted on: February 25, 2008 4:11 am

SQL Server 2008 JumpStart

Posted on: February 15, 2008 12:38 am

Updated aggregated feeds

Posted on: February 7, 2008 1:03 pm

SQL Server 2008: Enabling FILESTREAM through T-SQL and SSMS

Posted on: February 4, 2008 7:57 pm

SQL Server 2008: RTM slips to Q3

Posted on: January 28, 2008 1:59 am

SQL Server 2008: FILESTREAM

Posted on: January 25, 2008 9:51 am

SQL Server 2008: Spatial indexes

Posted on: January 17, 2008 7:59 pm

SQL Server 2008: Partition-level lock escalation details and examples

Posted on: January 14, 2008 10:10 pm

SQL Server 2008: Hot-Add CPU (and affinity masks)

Posted on: January 10, 2008 12:11 am

SQL Server 2008: Backup Compression CPU Cost

Posted on: January 9, 2008 10:26 am

Enabling VS2005 support for SQL Server 2008 CTP-5

Posted on: January 4, 2008 6:05 pm

Katmai bug: SSMS doesn’t drop database locks when leaving the context of a database

Posted on: January 4, 2008 3:07 am

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

Posted on: December 12, 2007 6:07 pm

SQL Server 2008: Configuring Peer-to-Peer Replication

Posted on: December 7, 2007 12:31 am

Kimberly & Paul interview with SSWUG TV

Posted on: November 18, 2007 2:49 pm

Fed up with BACKUP success messages bloating your error logs?

Posted on: October 30, 2007 7:26 pm

SQL Server 2008: What’s been removed in this version? BACKUP LOG WITH NO_LOG for one!

Posted on: October 12, 2007 7:26 pm

SQL Server 2008: Performance boost for Database Mirroring

Posted on: October 11, 2007 12:06 am

New aggregate feeds for SQLskills blogs

Posted on: October 9, 2007 1:35 am

SQL Server Magazine Connections Spring 2008 Call For Presentations

Posted on: October 5, 2007 1:27 am

Coming to Connections in November? Send us your questions and win a prize!

Posted on: October 4, 2007 9:19 pm

SQL Server 2008: Parallelism improvements for partitioning

Posted on: October 3, 2007 10:40 pm

Coming up soon: TechEd IT Forum 2007

Posted on: October 3, 2007 3:58 pm

SQL Server 2008: Lock escalation changes

Posted on: October 2, 2007 10:06 pm

SQL Server 2008: New Performance Counters for Database Mirroring

Posted on: October 1, 2007 8:31 pm

SQL Server 2008: Automatic Page Repair with Database Mirroring

Posted on: September 27, 2007 10:53 pm

SQL Server 2008: Backup Compression

Posted on: September 20, 2007 6:38 pm

Coming up soon: SQL Server Magazine Connections conference

Posted on: September 19, 2007 11:41 pm