SQL Server 2012 Black Book

Kogent Learning Solutions Inc.

ISBN: 9789350043073

1068 pages

eBook also available for institutional users

Description

It covers the entire spectrum of SQL Server 2012-Transact-Structured Query Language (T-SQL), SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), Integrated Full-Text Search, Database Mirroring, Policy-Based Management, AlwaysOn Availability Groups, Reporting Services, Analysis Services, Integration Services, Master Data Services, Data Quality Services, and PowerPivot.

About the Author

The proficient team at Kogent Solutions Inc. and Dreamtech Press has seized the market of computer books bringing excellent content in software development to the fore. The team is committed to excellence-excellence in the quality of content

Table of Contents

· Introducing SQL Server 2012

· Introducing SQL Server 2012 Tools

· Building SQL Server Databases

· SQL Statements, Operators, and Functions

· Programming with T-SQL - I

· Programming with T-SQL - II

· Stored Procedures and User-Defined Functions

· Triggers in SQL Server 2012

· Cursors in SQL Server 2012

· Managing Transactions and Locking

· Error Handling in SQL Server 2012

· Monitoring, Auditing, and Maintaining SQL Server

· Data Replication

· Log Shipping and Database Mirroring

· Implementing Failover Clustering

· Performing Bulk Copy Operations

· SQL Server Service Broker

· Policy-Based Management

· Automating SQL Server 2012

· Performance Optimization with Query Execution Plans

· Indexing and Partitioning

· Working with Full-Text Search

· Data Compression

· Resource Governor

· Security in SQL Server 2012

· Backing Up and Restoring Databases

· SQL Server Reporting Services

· SQL Server Analysis Services

· SQL Server Integration Services

· SQL Server 2012 and XML

· SQL Server 2012 and Common Language Runtime

· SQL Server 2012 and Language-Integrated Query