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
   
• 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
   
• 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
• The SolidQ Journal
• Tracing Query Performance with Extended Events
• Packing Intervals
• Managing Intervals Efficiently in Object-Relational Databases
• A Static Relational Interval Tree
• Advanced interval queries with the Static Relational Interval Tree
• SQL Server Columnstore Performance Tuning
• SQL Server Columnstore Index FAQ
• APPLY Part I, Part II
• SQL Server 2012 Solutions for Median Calculation
• Changes to automatic update statistics in SQL Server – traceflag 2371
• An Introduction to New T-SQL Programmability Features in SQL Server 2008
• 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
• 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
• SQL Server Pro Magazine
• Itzik's Articles in SQL Server Pro Magazine
• 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:

• 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
• 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:

Atlanta Microsoft Database Forum

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

Back to Top