Book description
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.
Table of contents
- Cover
- Part I: Laying the Foundations
-
Part II: Building Databases and Working with Data
- Chapter 6: Introducing Basic Query Flow
- Chapter 7: Relational Database Design and Creating the Physical Database Schema
- Chapter 8: Data Types, Expressions, and Scalar Functions
- Chapter 9: Merging Data with Joins, Subqueries, and CTEs
- Chapter 10: Aggregating, Windowing, and Ranking Data
- Chapter 11: Projecting Data Through Views
- Chapter 12: Modifying Data In SQL Server
- Part III: Advanced T-SQL Data Types and Querying Techniques
- Part IV: Programming with T-SQL
-
Part V: Enterprise Data Management
- Chapter 19: Configuring SQL Server
- Chapter 20: Policy Based Management
- Chapter 21: Backup and Recovery Planning
- Chapter 22: Maintaining the Database
- Chapter 23: Transferring Databases
- Chapter 24: Database Snapshots
- Chapter 25: Asynchronous Messaging with Service Broker
- Chapter 26: Log Shipping
- Chapter 27: Database Mirroring
- Chapter 28: Replicating Data
- Chapter 29: Clustering
- Chapter 30: Configuring and Managing SQL Server with PowerShell
- Chapter 31: Managing Data in Windows Azure SQL Database
- Part VI: Securing Your SQL Server
- Part VII: Monitoring and Auditing
-
Part VIII: Performance Tuning and Optimization
- Chapter 44: Interpreting Query Execution Plans
- Chapter 45: Indexing Strategies
- Chapter 46: Maximizing Query Plan Reuse
-
Chapter 47: Managing Transactions, Locking, and Blocking
- The ACID Properties
- Programming Transactions
- Default Locking and Blocking Behavior
- Monitoring Locking and Blocking
- Dealing with Deadlocks
- Understanding SQL Server Locking
- Transaction Isolation Levels
- Application Locks
- Application Locking Design
- Transaction-Log Architecture
- Transaction Performance Strategies
- Summary
- Chapter 48: Data Compression
- Chapter 49: Partitioning
- Chapter 50: Resource Governor
-
Part IX: Business Intelligence
- Chapter 51: Business Intelligence Database Design
- Chapter 52: Building, Deploying, and Managing ETL Workflows in Integration Services
- Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX
- Chapter 54: Configuring and Administering Analysis Services
- Chapter 55: Authoring Reports in Reporting Services
- Chapter 56: Configuring and Administering Reporting Services
- Chapter 57: Data Mining with Analysis Services
-
Chapter 58: Creating and Deploying BI Semantic Models
- What Is a BI Semantic Model?
- The Development Environment
- Creating BI Semantic Models Using PowerPivot
- Extending a BI Semantic Model with PowerPivot
- Deploying BI Semantic Models to SharePoint
- Managing Automatic Data Refresh of PowerPivot Workbooks in SharePoint 2010
- Creating BI Semantic Models Using SQL Server Data Tools
- Extending a BI Semantic Model with SQL Server Data Tools
- Deploying BI Semantic Models to an Analysis Services Instance
- Summary
- Chapter 59: Creating and Deploying Power View Reports
- Introduction
Product information
- Title: Microsoft SQL Server 2012 Bible
- Author(s):
- Release date: August 2012
- Publisher(s): Wiley
- ISBN: 9781118106877
You might also like
book
Microsoft SQL Server 2012 Internals
Dive deep inside the architecture of SQL Server 2012 Explore the core engine of Microsoft SQL …
book
Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server
Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This …
book
SQL Server 2017 Administrator's Guide
Implement and administer successful database solution with SQL Server 2017About This Book Master the required skills …
book
SQL Server 2019 Administrator's Guide - Second Edition
Use Microsoft SQL Server 2019 to implement, administer, and secure a robust database solution that is …