{"product_id":"9781430272120","title":"Expert SQL Server 2008 Development","description":"\u003cp\u003e\u003cem\u003eExpert SQL Server 2008 Development\u003c\/em\u003e is aimed at SQL Server developers ready to move beyond Books Online. Author and experienced developer \u003cstrong\u003eAlastair Aitchison\u003c\/strong\u003e shows you how to think about SQL Server development as if it were any other type of development. You’ll learn to manage testing in SQL Server and to properly deal with errors and exceptions. The book also covers critical, database-centric topics such as managing concurrency and securing your data and code through proper privileges and authorization. \u003c\/p\u003e  \u003cp\u003eAlastair places focus on sound development and architectural practices that will help you become a better developer, capable of designing high-performance, robust, maintainable database applications. He shows you how to apply notable features in SQL Server such as encryption and support for hierarchical data. If developing for SQL Server is what puts the bread on your table, you can do no better than to read this book and to assimilate the expert-level practices that it provides.\u003c\/p\u003e  \u003cul\u003e   \u003cli\u003ePromotes expert-level practices \u003c\/li\u003e   \u003cli\u003eLeads to high performance, scalable code \u003c\/li\u003e   \u003cli\u003eImproves productivity, getting you home in time for dinner \u003c\/li\u003e  \u003c\/ul\u003e  What you’ll learn\u003cul\u003e   \u003cli\u003eHow to productively handle errors and exceptions. \u003c\/li\u003e   \u003cli\u003eHow to exploit features for managing spatial and temporal data. \u003c\/li\u003e   \u003cli\u003eHow to manage tree-structured data using the new, hierarchid type. \u003c\/li\u003e   \u003cli\u003eHow to write code that easily survives high concurrency. \u003c\/li\u003e   \u003cli\u003eHow to program defensively. \u003c\/li\u003e   \u003cli\u003eHow to create proper and reusable test environments for your code. \u003c\/li\u003e   \u003cli\u003eHow to secure code and data through encryption and proper application of privilege. \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     SQL Server developers and administrators.         \u003c\/p\u003e     Table of Contents\u003col\u003e   \u003cli\u003eSoftware Development Methodologies for the Database World \u003c\/li\u003e   \u003cli\u003eBest Practices for Database Programming \u003c\/li\u003e   \u003cli\u003eTesting Database Routines \u003c\/li\u003e   \u003cli\u003eErrors and Exceptions \u003c\/li\u003e   \u003cli\u003ePrivilege and Authorization \u003c\/li\u003e   \u003cli\u003eEncryption \u003c\/li\u003e   \u003cli\u003eSQLCLR: Architecture and Design Considerations \u003c\/li\u003e   \u003cli\u003eDynamic T-SQL \u003c\/li\u003e   \u003cli\u003eDesigning Systems for Application Concurrency \u003c\/li\u003e   \u003cli\u003eWorking with Spatial Data \u003c\/li\u003e   \u003cli\u003eWorking with Temporal Data \u003c\/li\u003e   \u003cli\u003eTrees, Hierarchies, and Graphs \u003c\/li\u003e  \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47122664128752,"sku":"9781430272120","price":38.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430272120_p0.jpg?v=1763751143","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430272120","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}