Microsoft SQL Server 2012 Bible (eBook)

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.

I Laying the Foundations

1 The World of SQL Server

2 Data Architecture

3 Installing SQL Server

4 Client Connectivity

5 SQL Server Management and Development Tools

II Building Databases and Working with Data

6 Introducing Basic Query Flow

7 Relational Database Design and Creating the Physical Database Schema

8 Data Types, Expressions, and Scalar Functions

9 Merging Data with Joins, Subqueries, and CTE's

10 Aggregating, Windowing and Ranking Data

11 Projecting Data Through Views

12 Modifying Data in SQL Server

III Advanced T-SQL Data Types and Querying Techniques

13 Working with Hierarchies

14 Using XML Data

15 Executing Distributed Queries

IV Programming with T-SQL

16 Programming with T-SQL

17 Developing Stored Procedures

18 Building User-Defined Functions

V Enterprise Data Management

19 Configuring SQL Server

20 Policy Based Management

21 Backup and Recovery Planning

22 Maintaining the Database

23 Transferring Databases

24 Database Snapshots

25 Asynchronous Messaging with Service Broker

26 Log Shipping

27 Database Mirroring

28 Replicating Data

29 Clustering

30 Configuring and Managing SQL Server with PowerShell

31 Managing Data in SQL Server Azure

VI Securing Your SQL Server

32 Authentication Types in SQL Server

33 Authorizing Securables

34 Data Encryption

35 Row Level Security

VII Monitoring and Auditing

36 Creating Triggers

37 Performance Monitor and PAL

38 Using Profiler and SQL Trace

39 Wait States

40 Extended Events

41 Data Change Tracking and Capture

42 SQL Audit

43 Management Data Warehouse

VIII Performance Tuning and Optimization

44 Interpreting Query Execution Plans

45 Indexing Strategies

46 Maximizing Query Plan Reuse

47 Managing Transactions, Locking, and Blocking

48 Data Compression

49 Partitioning

50 Resource Governor

IX Business Intelligence

51 Business Intelligence Database Design

52 Building, Deploying and Managing ETL Workflows in Integration Services

53 Building MultiDimensional Cubes in Analysis Services with MDX

54 Configuring and Administering Analysis Services

55 Authoring Reports in Reporting Services

56 Configuring and Administering Reporting Services

57 Data Mining with Analysis Services

58 Creating and Deploying BI Semantic Models

59 Creating and Deploying Power View Reports