Guest Blogger of the Week – Info

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

sqlPerspectives