We’re happy to announce the availability of Programming Microsoft SQL Server 2012 (ISBN 978-0-7356-5822-6), by Leonard Lobel and Andrew Brust. This book is a quintessential guide to the programming features in Microsoft SQL Server 2012, packed with the information you need to design, test, and deploy SQL Server databases. It explores the plethora of ways you can program SQL Server (and its cloud cousin, SQL Azure) to build custom applications and services.
Today, SQL Server is more than a database—it’s a collection of services that includes robust relational data storage and retrieval, backup, security, reliability, reporting, data monitoring, Business Intelligence (BI), data integration, manageability features, and more. Most of these services are accessible to programmers for application and customization purposes, and that programmability is the focus of this book.
This book is intended for developers who already have a basic knowledge of relational database terms and principles—whether that experience is with SQL Server or other platforms. Therefore, the book doesn’t try to teach basic database concepts and principles, such as tables, views, primary and foreign keys, stored procedures, and so on. Instead, this book offers an exploration of the feature set that SQL Server 2012 offers, covering not only extensions to T-SQL and the relational database engine, but also features such as native file streaming, geospatial data, and other types of unstructured data. The book contains chapters on security, transactions, client data access, security, mobile/cloud development, and more, adding up to detailed coverage of the latest and most important SQL Server programming features. However, this is a book intended for programmers, not for administrators, so in general, this book does not discuss non-programmable features.
The book is arranged in three major sections:
• Core SQL Server Development
• Going Beyond Relational
• Applied SQL
You can read two sample chapters (Chapter 1, “Introducing SQL Server Data Tools,” and Chapter 12, “Moving to the Cloud with SQL Azure”) here: http://cdn.oreilly.com/oreilly/booksamplers/msp/9780735658226_sampler.pdf.
You can purchase the book from O’Reilly Media, our official distributor, here: http://shop.oreilly.com/product/0790145322357.do.
There's very good information on SQL Server Audit Logs at www.ultimatewindowssecurity.com/sqlserver