Microsoft SQL Server 2012 Bible

  • 19h 4m
  • Aaron Nelson, Adam Jorgensen, Jorge Segarra, Jose Chinchilla, Patrick LeBlanc
  • John Wiley & Sons (US)
  • 2012

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.

  • 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
  • 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.

About the Authors

Adam Jorgensen is the President of Pragmatic Works Consulting, a Director for the Professional Association of SQL Server (PASS), a SQL Server MVP, and a well-known speaker, author, and executive mentor. His focus is on helping companies realize their full potential using their data in ways they have not previously imagined. Adam is very involved in the community, delivering more than 75 community sessions per year. Based in Jacksonville, FL, Adam has written and contributed to five previous books on SQL Server, analytics, and SharePoint.

Coauthors Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, and Aaron Nelson are well-known experts on SQL Server and Business Intelligence.

In this Book

  • Introduction
  • The World of SQL Server
  • Data Architecture
  • Installing SQL Server
  • Client Connectivity
  • SQL Server Management and Development Tools
  • Introducing Basic Query Flow
  • Relational Database Design and Creating the Physical Database Schema
  • Data Types, Expressions, and Scalar Functions
  • Merging Data with Joins, Subqueries, and CTEs
  • Aggregating, Windowing, and Ranking Data
  • Projecting Data Through Views
  • Modifying Data In SQL Server
  • Working with Hierarchies
  • Using XML Data
  • Executing Distributed Queries
  • Programming with T-SQL
  • Developing Stored Procedures
  • Building User-Defined Functions
  • Configuring SQL Server
  • Policy Based Management
  • Backup and Recovery Planning
  • Maintaining the Database
  • Transferring Databases
  • Database Snapshots
  • Asynchronous Messaging with Service Broker
  • Log Shipping
  • Database Mirroring
  • Replicating Data
  • Clustering
  • Configuring and Managing SQL Server with PowerShell
  • Managing Data in Windows Azure SQL Database
  • Authentication Types in SQL Server
  • Authorizing Securables
  • Data Encryption
  • Row-Level Security
  • Creating Triggers
  • Performance Monitor and PAL
  • Using Profiler and SQL Trace
  • Wait States
  • Extended Events
  • Data Change Tracking and Capture
  • SQL Audit
  • Management Data Warehouse
  • Interpreting Query Execution Plans
  • Indexing Strategies
  • Maximizing Query Plan Reuse
  • Managing Transactions, Locking, and Blocking
  • Data Compression
  • Partitioning
  • Resource Governor
  • Business Intelligence Database Design
  • Building, Deploying, and Managing ETL Workflows in Integration Services
  • Building Multidimensional Cubes in Analysis Services with MDX
  • Configuring and Administering Analysis Services
  • Authoring Reports in Reporting Services
  • Configuring and Administering Reporting Services
  • Data Mining with Analysis Services
  • Creating and Deploying BI Semantic Models
  • Creating and Deploying Power View Reports