SQL Server 2012 T-SQL Recipes

Jason Brimhall is first and foremost a family man. He has 15+ yrs experience in IT and has worked with SQL Server starting with SQL Server 6.5. He has worked for both large and small companies in varied industries. He has experience in performance tuning, high transaction environments, large environments, and VLDBs. He is currently a DB Architect and an MCITP for SQL 2008. Jason regularly volunteers for PASS and is the VP of the Las Vegas User Group (SSSOLV). You can read more more from Jason on his blog at: http://jasonbrimhall.info.

• * Getting Started with SELECT * Elementary Programming * Nulls and Other Pitfalls * Combining Data from Multiple Tables * Grouping and Summarizing * Advanced SELECT Techniques * Query Techniques for Reporting * Inserting, Updating, Deleting * Working with Strings * Working with Dates * Working with Numbers * Transactions, Locking, Blocking, Deadlocking * Managing Tables * Managing Views * Managing Indexes * Managing Large Tables * Stored Procedures * User-Defined Functions * Triggers * Error Handling * Query Performance * Hints * Index Tuning and Statistics * XML * Files, Filegroups, and Integrity * Backup * Recovery * Principals and Users * Securables and Permissions * Objects and Dependencies