Microsoft{R} SQL Server{R} 2012 Internals

Microsoft{R} SQL Server{R} 2012 Internals
Kalen Delaney (Author)

New!: $61.99 $42.91 (as of 03/02/2013 03:55 PST)

Software Engineering

Dive deep inside the core engine of Microsoft SQL Server 2012—and put that practical knowledge to work. Led by a team of SQL Server experts, you’ll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for building, expanding, shrinking, and moving databases—whether you’re a database developer, architect, or administrator.

Discover how to:

• Significantly reduce your query execution time using the right indexes
• Use event tracking—from triggers to the Extended Events Engine
• Transcend normal row-size limits with new storage capabilities
• Troubleshoot problematic query plans using multiple techniques
• Force SQL Server to reuse a cached query plan—or create a new one
• Choose among five isolation levels and two concurrency models
• Check SQL Server internal operations by running Database Console Commands

• Rank: #76388 in Books
• Published on: 2013-05-02
• Original language: English
• Number of items: 1
• Dimensions: .0 pounds
• Binding: Paperback
• 992 pages

Description #1 by OnlineBookPlace.com:

Dig into the architecture and internals of Microsoft Dynamics AX 2012-with firsthand insights from the team that designed and developed it. Targeted for solution developers and system implementers, this guide focuses on programming and customization capabilities-including key architectural principles, the application model, framework, and tools. Topics include: Architecture and development environment, including morphx Microsoft Visual Studio tools for Microsoft Dynamics AX X++ programming language Microsoft sql Server reporting and analytics Models Core development concepts Extending and customizing Microsoft Dynamics AX Performance and security considerations Workflow Best practices Note: Readers should have working knowledge of sql and oop concepts to gain max benefit from this book.

Description #2 by Bookdepository.com:

Microsoft SQL Server 2012 Internals : Paperback : Microsoft Press,US : 9780735658561 : 0735658560 : 31 Jul 2013 : Dive deep inside the core engine of Microsoft(R) SQL Server(R) 2012 - and put that practical knowledge to work. Led by a team of SQL Server experts, you'll learn the skills you need to exploit key architectural features.