Resources:

• Whitepapers
• Magazines/Articles
• Books
• Websites
• Blogs
• Newsgroups
• Downloads
• Source Code for Recent Conferences

Whitepapers:

• An Introduction to New T-SQL Programmability Features in SQL Server 2008
• OVER Clause and Ordered Calculations - Feature Enhancements Request by Itzik Ben-Gan and Sujata Mehta
• SQL Server 2008 Upgrade Technical Reference Guide
• Partitioned Table and Index Strategies Using SQL Server 2008
• SQL Server 2005 Waits and Queues
• Working with tempdb in SQL Server 2005
• Processing XML Showplans Using SQLCLR in SQL Server 2005
• Troubleshooting Performance Problems in SQL Server 2005
• Batch Compilation, Recompilation, and Plan Caching Issues 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
• Using Table Valued Functions in SQL Server 2005 to Implement a Spatial Data Library
• SQL Server 2005 Transact-SQL Enhancements
• Implementing Referential Integrity and Cascading Actions
• Database Concurrency and Row Level Versioning in SQL Server 2005
• Implementing Row- and Cell-Level Security in Classified Databases Using SQL Server 2005
• 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
• SQL Server 2000 Incremental Bulk Load Case Study
• 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)
• Database Snapshot Performance Considerations under I/O-Intensive Workloads

Magazines/Articles:

• SQL Server Magazine
• T-SQL Black Belt Column
• T-SQL 2005 Column
• Brian Moran's articles in SQL Server Magazine
• Opening Microsoft's Performance-Tuning Toolbox / Tom Davidson
• Powerful New T-SQL Syntax Gives SQL Server a Programmability Boost in MSDN
• SQL Injection
• Ordered vs. Unordered Index Scans
  - Part I
  - Part II
  - Part III
• Partitioned Tables and Indexes in SQL Server 2005
  - Part I
  - Part II
  - Part III
  - Part IV

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

• 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

Websites:

• Official Microsoft SQL Server Website
• Microsoft Support and Knowledge Base for SQL Server 2005
• Microsoft Support and Knowledge Base for SQL Server 2000
• MSDN/SQL
• TechNet/SQL
• National Institute of Standards and Technology (NIST) Dictionary of Algorithms and Data Structures
• WikipediA - The free Encyclopedia
• Transaction Processing Performance Council (TPC)
• Independent UK SQL Server User Group / Tony Rogerson
• Steve Kass
• Tibor Karaszi
• SQLDev.Net / Gert Drapers
• Erland Sommarskog
• aspfaq.com / Aaron Bertrand
• BNF Grammars for SQL-92, SQL-99 and SQL-2003
• tsqlunit - a testing framework for Microsoft SQL-Server
• TSQLMacro - macro expansion for sql server
• Introduction to Regular Expressions
• Regular Expressions Quick Reference

Blogs:

• Craig Freedman's SQL Server Blog
• Itzik's Blog at SQL Server Magazine - Puzzled by T-SQL
• 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

Newsgroups:

• Microsoft Public SQL Server Newsgroups

Downloads:

• SQL Server Downloads
• System Views 2008 Poster
• Logical Query Processing Poster
• SQL Server 2008 SP1
• SQL Server 2005 SP3
• SQL Server 2008 Books Online (January 2009)
• SQL Server 2005 Books Online (December 2008)
• Support Tools Available For Stress Testing & Performance Analysis
• ANSI SQL:2003 Standard from the Whitemarsh Information Systems Corporation's website
• 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: