{"product_id":"microsoft-sql-server-2012-internals","title":"Microsoft SQL Server 2012 Internals","description":"\u003cp\u003e\u003cb\u003eDive deep inside the architecture of SQL Server 2012\u003c\/b\u003e \u003c\/p\u003e \u003cp\u003e Explore 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 creating, expanding, shrinking, and moving databases—whether you’re a database developer, architect, or administrator. \u003c\/p\u003e \u003cp\u003e Discover how to: \u003c\/p\u003e \u003cul\u003e \u003cli\u003eDig into SQL Server 2012 architecture and configuration \u003c\/li\u003e\n \u003cli\u003eUse the right recovery model and control transaction logging \u003c\/li\u003e\n \u003cli\u003eReduce query execution time through proper index design \u003c\/li\u003e\n \u003cli\u003eTrack events, from triggers to the Extended Event Engine \u003c\/li\u003e\n \u003cli\u003eExamine internal structures with database console commands \u003c\/li\u003e\n \u003cli\u003eTranscend row-size limitations with special storage capabilities \u003c\/li\u003e\n \u003cli\u003eChoose the right transaction isolation level and concurrency model \u003c\/li\u003e\n \u003cli\u003eTake control over query plan caching and reuse \u003c\/li\u003e\n \u003c\/ul\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":46287712485614,"sku":"9780735670198","price":50.6,"currency_code":"AUD","in_stock":true}],"url":"https:\/\/bookland.com.au\/products\/microsoft-sql-server-2012-internals","provider":"Book Land AU","version":"1.0","type":"link"}