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 2012’s Window Functions @ Microsoft's Channel 9
  - SQL Server 2012 T-SQL at a Glance – OFFSET/FETCH,
    OFFSET/FETCH Part 1, Part 2
  - SQL Server 2012 T-SQL at a Glance – Sequences,
    Sequences Part 1, Part 2
  - SQL Server 2012 T-SQL at a Glance – THROW
  - SQL Server 2012 T-SQL at a Glance – EXECUTE WITH RESULT SETS
  - SQL Server 2012 T-SQL at a Glance - Metadata Discovery
  - SQL Server 2012 T-SQL at a Glance - New and Enhanced Functions
   
• Connect Items:
   
• Connect Feature Request - BIGDATEADD, BIGDATEDIFF and “100 nanoseconds” Part
• Connect Feature Request - Add SQL Server Engine Support for Interval Queries, connect item, Survey
• Connect Feature Request - Ordered Set Functions, connect item
   
• Various Resources:
   
• SQL Server Columnstore Performance Tuning
• SQL Server Columnstore Index FAQ
• Tracing Query Performance with Extended Events
• Temporary Tables in Stored Procedures

• Temporary Object Caching Explained

• Partitioned Table and Index Strategies Using SQL Server 2008
• Changes to automatic update statistics in SQL Server – traceflag 2371
• Arrays and Lists in SQL Server, Other Texts by Erland Sommarskog
• Advanced Uses of APPLY
• SQL Server 2012 Solutions for Median Calculation
• The Data Loading Performance Guide
• Intervals:
  - Academic Paper - Managing Intervals Efficiently in Object-Relational Databases
  - Article - A Static Relational Interval Tree
  - Article - Advanced interval queries with the Static Relational Interval Tree
  - Connect Feature Request - Add SQL Server Engine Support for Interval Queries
• Dynamic Search Conditions, Other Texts by Erland Sommarskog
• Plan Caching and Recompilation in SQL Server 2012
• Plan Caching in SQL Server 2008
   
• SQL Server 2012 Upgrade Technical Reference Guide
• SQL Server 2008 Upgrade Technical Reference Guide

 
• The SolidQ Journal
  SQL Server Pro Magazine
• Itzik's Articles in SQL Server Pro Magazine

• Microsoft, SQLCAT and Community Technical Articles:
  
  - SQL Server 2012 Microsoft White Papers
  - SQL Server 2012 SQLCAT 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
   

Books:

T-SQL Books:

• Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 (MSPress, December 2012)
• Microsoft SQL Server 2012 T-SQL Fundamentals (MSPress, 2012)
• Microsoft Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (MSPress, 2012)
• 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

Blogs:

• SQLblog.com
• Paul White @ SQLblog, Paul White @ SQLPerformance
• Craig Freedman's SQL Server Blog
• Benjamin Nevarez
• Itzik's Blog at SQL Server Pro - Puzzled by T-SQL

SQL Server Forums:

• SQL Server Forums
• T-SQL Forum

Downloads:

• Source Code for T-SQL Books
• TSQL2012 Sample Database
• Performance Sample Database
• Logical Query Processing Poster
• SQL Sentry Plan Explorer

Source Code for Recent Conferences:

Atlanta Microsoft Database Forum

• Efficient Interval Management in Microsoft SQL Server Deck, Source Code, Connect Item

Back to Top