Resources:

• Whitepapers/Articles
• Books
• Blogs
• SQL Server Forums
• Downloads
• Source Code for Recent Conferences

Whitepapers/Articles:

• T-SQL improvements in SQL Server 2012:
  
  - How to Use Microsoft SQL Server 2012's Window Functions, Part 1, Part 2, Part 3
  - Efficient T-SQL Querying using SQL Server Denali’s Window Functions @ Microsoft's Channel 9
  - Denali T-SQL at a Glance – OFFSET/FETCH,
    OFFSET/FETCH Part 1, Part 2
  - Denali T-SQL at a Glance – Sequences,
    Sequences Part 1, Part 2
  - Denali T-SQL at a Glance – THROW
  - Denali T-SQL at a Glance – EXECUTE WITH RESULT SETS
  - Denali T-SQL at a Glance - Metadata Discovery
  - Denali T-SQL at a Glance - New and Enhanced Functions
   
• Microsoft, SQLCAT and Community Technical Articles:
  
  - SQL Server 2008 R2 Microsoft White Papers
  - SQL Server 2008 R2 SQLCAT Articles
  
  - SQL Server 2008 Microsoft White Papers
  - SQL Server 2008 SQLCAT Articles
  - SQL Server 2008 Community Articles
  
  - SQL Server 2005 Technical Articles
   
• Connect Feature Request - Ordered Set Functions, connect item
• The SolidQ Journal
• Packing Intervals
• A Static Relational Interval Tree
• SQL Server Columnstore Performance Tuning
• SQL Server Columnstore Index FAQ
• Changes to automatic update statistics in SQL Server – traceflag 2371
• An Introduction to New T-SQL Programmability Features in SQL Server 2008
• Plan Caching in SQL Server 2008
• Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005
• SQL Server 2012 Upgrade Technical Reference Guide
• SQL Server 2008 Upgrade Technical Reference Guide
• Partitioned Table and Index Strategies Using SQL Server 2008
• Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries
• SQL Server 2005 Waits and Queues
• Working with tempdb in SQL Server 2005
• Database Mirroring in SQL Server 2005
• Troubleshooting Performance Problems in SQL Server 2005
• Statistics Used by the Query Optimizer in Microsoft SQL Server 2005
• Forcing Query Plans with SQL Server 2005
• Improving Performance with SQL Server 2008 Indexed Views
• Improving Performance with SQL Server 2005 Indexed Views
• Whitepapers/articles by Erland Sommarskog
  - The curse and blessings of dynamic SQL
  - Arrays and Lists in SQL Server
  - Dynamic Search Conditions
  - Implementing Error Handling with Stored Procedures and Error Handling in SQL Server – a Background
• The Data Loading Performance Guide
• Blog entries by  Sunil Agarwal on Bulk Import Optimizations (Minimal Logging)
  - Bulk Import Optimizations (Minimal Logging)
  - Minimal Logging changes in SQL Server 2008 (part-1, part-2, part-3)
• SQL Server Magazine
• T-SQL Black Belt Column
• Opening Microsoft's Performance-Tuning Toolbox / Tom Davidson
• SQL Injection
• Ordered vs. Unordered Index Scans
  - Part I
  - Part II
  - Part III

Books:

T-SQL Books:

• Microsoft SQL Server 2008: T-SQL Fundamentals (MSPress, 2008) by Itzik Ben-Gan
• Inside Microsoft SQL Server 2008: T-SQL Querying (MSPress, 2009) by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass
• Inside Microsoft SQL Server 2008: T-SQL Programming (MSPress, 2009) by Itzik Ben-Gan, Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah, Isaac Kunen
• Inside Microsoft SQL Server 2005: T-SQL Querying (MSPress, 2006) by Itzik Ben-Gan, Lubor Kollar, Dejan Sarka
• Inside Microsoft SQL Server 2005: T-SQL Programming (MSPress, 2006) by Itzik Ben-Gan, Dejan Sarka, Roger Wolter

Set Theory:

• Set Theory and Logic (Dover Publications)
    by Robert R Stoll

• Set Theory and Its Philosophy : A Critical Introduction (Oxford University Press)
    by Michael Potter

Relational Modeling:

• Data Modeling Essentials (Coriolis Group Books)
    by Graeme Simsion

• Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Second Edition (Addison-Wesley Professional)
    by Michael J. Hernandez

• Practical Issues in Database Management: A Reference for the Thinking Practitioner (Addison-Wesley Professional)
    by Fabian Pascal

• Foundation for Object / Relational Databases: The Third Manifesto (Addison-Wesley Professional)
    by C. J. Date, Hugh Darwen

• Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design (The Morgan Kaufmann Series in Data Management Systems)
  by Terry Halpin

SQL:

• SQL and Relational Theory (O'Reilly, 2009)
    by C. J. Date

• The Art of SQL (O'Reilly Media, March 2006)
    by Stephane Faroult, Peter Robson

• SQL-99 Complete, Really (CMP Books)
    by Peter Gulutzan, Trudy Pelzer

• Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems)
    by Joe Celko

• Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems)
    by Joe Celko

Database:

• Transaction Processing : Concepts and Techniques (The Morgan Kaufmann Series in Data Management Systems)

Computing:

• The Art of Computer Programming, Volumes 1-3 Boxed Set (Addison-Wesley Professional)
    by Donald E. Knuth

• The Art of Computer Programming, Volume 1, Fascicle 1 : MMIX -- A RISC Computer for the New Millennium (Art of Computer Programming) (Addison-Wesley Professional )
    by Donald E. Knuth

• The Art of Computer Programming, Volume 4, Fascicle 2 : Generating All Tuples and Permutations (Art of Computer Programming) (Addison-Wesley Professional )
    by Donald E. Knuth

• The Art of Computer Programming, Volume 4, Fascicle 3 : Generating All Combinations and Partitions (Art of Computer Programming) (Addison-Wesley Professional )
    by Donald E. Knuth

• Mastering Regular Expressions, Second Edition (O'Reilly Media, Inc.)
    by Jeffrey Friedl

• Regular Expression Pocket Reference (O'Reilly Media, Inc.)
    by Tony Stubblebine

Blogs:

• Craig Freedman's SQL Server Blog
• Itzik's Blog at SQL Server Magazine - Puzzled by T-SQL
• Benjamin Nevarez
• Tips, Tricks, and Advice from the SQL Server Query Processing Team
• SQL Server Storage Engine
• Microsoft Community SQL Server Blogs
• SQLblog.com
• Bob Beauchemin
• Paul Randal

SQL Server Forums:

• SQL Server Forums
• T-SQL Forum

Downloads:

• System Views 2008 Poster
• Logical Query Processing Poster
• SQL:2008 draft (Whitemarsh Information Systems Corporation)
• SQL Server 2012 Sample Databases
• SQL Server 2008 R2 SP1
• SQL Server 2008 SP3
• SQL Server 2005 SP4
• SQL Server 2008 R2 Books Online, Online Version
• SQL Server 2008 Books Online, Online Version
• SQL Server 2005 Books Online, Online Version
• PDF version of Developing Time-Oriented Database Applications in SQL by Richard T. Snodgrass (Morgan Kaufmann Publishers, Inc., July, 1999)

Source Code for Recent Conferences:

DevTeach Vancouver Spring 2012

• T-SQL Bug or Feature
• Query Tuning Tips
• Advanced T-SQL

Back to Top