Press releases

Two New Books on SQL Server 2012 from Microsoft Press

Microsoft® SQL Server® 2012 T-SQL Fundamentals
by Itzik Ben-Gan (@ItzikBenGan)

Get started with the fundamentals of Transact-SQL and learn how to write efficient and powerful database queries. With this hands-on guide, you'll gain a solid understanding of T-SQL and good programming practices through the right balance of conceptual and practical content. Learn the steps required to develop T-SQL code for retrieving and modifying data, with exercises to help you apply what you've learned—ideal for T-SQL programmers, DBAs, BI practitioners, report writers, analysts, and architects.

Discover how to:

• Apply T-SQL fundamentals, create tables, and define data integrity
• Understand logical query processing
• Query multiple tables using joins and subqueries
• Simplify code and improve maintainability with table expressions
• Write code to insert, update, delete, and merge data
• Go beyond the fundamentals with pivoting techniques and set grouping
• Isolate inconsistent data and address deadlock and blocking scenarios

Training Kit Exam 70-462: Administering Microsoft® SQL Server® 2012 Databases
by Orin Thomas, Peter Ward, boB Taylor

Ace your preparation for the skills measured by Exam 70-462—and on the job—with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you've learned through real-world case scenarios and practice exercises.

Maximize your performance on the exam by mastering the skills and experience measured by these objectives:

• Install and configure SQL Server
• Maintain instances and databases
• Optimize and troubleshoot SQL Server
• Manage data
• Implement security