This page will serve as a list of the chapters and which one’s have been “spoken” for and which ones are available.  Please send an e-mail to, or if you would like to be the guest blogger for that chapter.

All posts need to be submitted, via e-mail no later than Thursday morning on the week of the subject you choose to blog about.  If there is significant interest in mulitple guest bloggers for one week, we will certainly accomodate.  As part of your blog post, please provide a link back to your blog or an e-mail address, if you choose, so that readers can get in touch with you or follow along on your own blog.

We are very excited about this and hope that this format will do justice to the quality of the book.

Below you will find a table of dates, chapters and guest bloggers that are needed. 

Date (Week of) Chapter – Subject Guest Blogger(s)
February 1st 1 – 10 Relational DB Design Ideas Dale Lamb
February 8th 2 – Maintaining Data Integrity  Jorge Segarra
February 15th 3 –Finding Functional Dependencies  
February 22nd 4 – Set-based iteration, the 3rd alternative  Tjay Belt
March 1st 5 – Gaps and islands  Jen McCown
March 8th 6 – Error handling in SQL Server & Applications  
March 15th 7 – Pulling apart the FROM clause  
March 22nd 8 – Bulk insert a minimally logged operation  
March 29th 9 – Avoiding three common Query Mistakes Derrick Hadzima
April 5th 10 – Introduction to XQuery on SQL Server Michael Coles 
April 12th 11 – SQL Server XML frequently asked ?’s Jason Strate
April 19th 12 – Using XML to transport relational data  
April 26th 13 – Full-text searching  Hilary Cotter
May 3rd 14 – Simil: algorithm to look for similar strings  
May 10th 15 – LINQ to SQL and ADO.NET Entity Framework  Jason Marsell
May 17th 16 – Table-valued parameters  
May 24th 17 – Build your own index  
May 31st 18 – Getting and staying connected – or not  
June 7th 19 – Extending your productivity in SSMS Tim Ford 
June 14th 20 – Why every SQL developer needs a tools DB  Buck Woody
June 21st 21 – Deprecation feature  
June 28th 22 – Placing SQL Server in your pocket  
July 5th 23 – Mobile data strategies  
July 12th 24 – What does it mean to be a DBA?  
July 19th 25 – Working with maintenance plans  
July 26th 26 – PowerShell in SQL Server  Sean McCown
August 2nd 27 – Automating SQL Srvr Mgmt using SMO  
August 9th 28 – Practical auditing in SQL Server 2008  
August 16th 29 – My favorite DMV’s, and why  
August 23rd 30 – Reusing space in a table  
August 30th 31 – Some practical issues in table partitioning  
September 6th 32 – Partitioning for manageability  
September 13th 33 – Efficient backups without indexes  Brent Ozar
September 20th 34 – Using DB mirroring to become a superhero!  
September 27th 35 – The poor man’s SQL Server log shipping  
October 4th 36 – Understated changes-SQL Srvr 2k5 replication  
October 11th 37 – High-performance transactional replication  
October 18th 38 – Successfully implementing Kerberos delegation Jack Corbett
October 25th 39 – Running SQL Server on Hyper-V  
November 1st 40 – When is an unused index not an unused index?  
November 8th 41 – Speeding up your queries with index covering  
November 15th 42 – Tracing the deadlock  
November 22nd 43 – How to optimize tempdb performance  
November 29th 44 – Does the order of columns in an index matter?  
December 6th 45 – Correlating SQL Profiler with PerfMon  
December 13th 46 – Using correlation to improve query performance  
December 20th 47 – How to use Dynamic Management Views  Tim Ford
December 27th 48 – Query performance and disk I/O counters  
January 3rd 49 – XEVENT: the next event infrastructure  
January 10th 50 – BI for the relational guy  
January 17th 51 – Unlocking the secrets of 2008 Reporting Services  
January 24th 52 – Reporting Services tips and tricks  
January 31st 53 – SQL Server Audit, change tracking, and CDC  
February 7th 54 – Introduction to SSAS 2008 data mining  Matija Lah
February 14th 55 – To aggregate or not to aggregate  
February 21st 56 – Incorporating data profiling in the ETL process  
February 28th 57 – Expressions in SQL Server Integration Services Chris Randall
March 7th 58 – SSIS performance tips  
March 14th 59 – Incremental loads using T-SQL and SSIS  

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 11 other followers