My books

SQL Server 2012 Bible

Harness the powerful new SQL Server 2012

Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you’re a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak.

The book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book’s companion web site, which you can use to jumpstart your own projects.

• Serves as an authoritative guide to Microsoft’s SQL Server 2012 for database administrators and developers
• Covers all the software’s new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications
• Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services
• Demonstrates tasks both graphically and in SQL code to enhance your learning
• Provides source code from the companion web site, which you can use as a basis for your own projects
• Explores tips, smart workarounds, and best practices to help you on the job

Get thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.

---

Product Details

• Amazon Sales Rank: #182239 in Books
• Published on: 2012-08-28
• Original language: English
• Number of items: 1
• Dimensions: 8.98″ h x 2.05″ w x 7.36″ l, 4.61 pounds
• Binding: Paperback
• 1416 pages

---

Editorial Reviews

From the Back Cover

Something for you on every page

If you’re a database administrator or developer, this book is your complete, one-stop resource for SQL Server 2012. The authors provide in-depth coverage of core techniques, best practices, and smart workarounds, as well as plenty of examples and sample code. They also fully cover such new features as AlwwaysOn connectivity, new indexes, Power View, Master Data Services, Data Quality Services, PowerPivot for SQL Server 2012, and more.

• Thoroughly explore all new features in SQL Server 2012
• Understand advanced T-SQL data types and querying techniques
• Ensure high availability for mission-critical applications
• Start using SQL Azure for cloud computing
• Master new security and compliance settings
• Leverage your data with tools for BI, data warehousing, and Enterprise Information Management solutions
• Get up to speed on the latest enhancements to the BI toolset

_______________________________________________________________________________________________

Professional Microsoft SQL Server 2012 Administration

An essential how-to guide for experienced DBAs on the most significant product release since 2005!

Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics such as performance tuning, backup and recovery, scaling and replication, clustering, and security.

• Serves as a must-have how-to guide on the new features of the 2012 release of Microsoft SQL Server
• Walks you through ways to manage and monitor SQL Server and automate administration
• Guides you through SQL Azure for cloud computing, data replication, and data warehouse performance improvements
• Addresses client-connectivity enhancements, new features that ensure high availability of mission-critical applications, and tighter integration with Excel and SharePoint for data analysis and reporting
• Highlights major changes to the suite of SQL Server BI tools, including integration, reporting, and analysis services
• Includes real-world case examples and best practices from Microsoft insiders

If you’re a database administrator eager to get started with the newest version of SQL Server, then this book is essential reading.

---

Product Details

• Amazon Sales Rank: #32608 in Books
• Published on: 2012-04-24
• Original language: English
• Number of items: 1
• Dimensions: 9.13″ h x 1.73″ w x 7.32″ l, 3.45 pounds
• Binding: Paperback
• 960 pages

---

Editorial Reviews

From the Back Cover
Tips, tricks, and workarounds for effectively administering SQL Server

This comprehensive guide teaches you the skills needed to successfully administer SQL Server 2012. You’ll learn how to handle the most difficult admin issues including change management, security, performance tuning, monitoring, and backups. And you’ll also discover how to master the latest features of the 2012 release, including client connectivity enhancements, cloud computing, data replication, and business intelligence. This detailed instruction by leading experts will help you improve the efficiency, scalability, and performance of your SQL Server environment so you can do more in much less time.

Professional Microsoft SQL Server 2012 Administration:

• Examines settings and configuration items that improve SQL Server performance
• Shows how to implement strategies for effective indexing for your database
• Takes you through the setup, configuration, and testing of a cluster
• Outlines the options in SQL Server for backups and recoveries, and provides recommendations to make the most of these features
• Covers what you need to know about how SharePoint® 2010 integrates with SQL Server
• Introduces SQL Server Azure and gets you up and running on this exciting new cloud platform