Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Part I: Laying the Foundations
Chapter 1: The World of SQL Server
SQL Server History
SQL Server in the Database Market
SQL Server Components
Editions of SQL Server 2012
Notable SQL Server 2012 Enhancements
Summary
Chapter 2: Data Architecture
Information Architecture Principle
Database Objectives
Smart Database Design
Summary
Chapter 3: Installing SQL Server
Preparing the Server
Selecting the Edition
The Installation Process
Summary
Chapter 4: Client Connectivity
Enabling Server Connectivity
SQL Server Native Client Features
Summary
Chapter 5: SQL Server Management and Development Tools
Organizing the Interface
Registered Servers
Object Explorer
Using the Query Editor
Using the Solution Explorer
Getting a Jumpstart on Code with Templates and Code Snippets
Summary
Part II: Building Databases and Working with Data
Chapter 6: Introducing Basic Query Flow
Understanding Query Flow
FROM Clause Data Sources
WHERE Conditions
(0 row(s) affected)Columns, Stars, Aliases, and Expressions
Ordering the Result Set
Select Distinct
TOP ()
Summary
Chapter 7: Relational Database Design and Creating the Physical Database Schema
Database Basics
Data Design Patterns
Normal Forms
Strategy Considerations
Summary
Chapter 8: Data Types, Expressions, and Scalar Functions
Data Types
Building Expressions
Scalar Functions
String Functions
Soundex Functions
Data-Type Conversion Functions
Server Environment Information
Summary
Chapter 9: Merging Data with Joins, Subqueries, and CTEs
Using Joins
Set Difference Queries
Using Unions
Subqueries
Summary
Chapter 10: Aggregating, Windowing, and Ranking Data
Aggregating Data
Grouping Within a Result Set
Windowing and Ranking
Ranking Functions
Summary
Chapter 11: Projecting Data Through Views
Why Use Views?
The Basic View
A Broader Point of View
Locking Down the View
Using SQL Synonyms
Summary
Chapter 12: Modifying Data In SQL Server
Inserting Data
Updating Data
Deleting Data
Merging Data
Returning Modified Data
Summary
Part III: Advanced T-SQL Data Types and Querying Techniques
Chapter 13: Working with Hierarchies
HierarchyID
HierarchyID Methods
Indexing Strategies
Hierarchical Data Alternatives
Summary
Chapter 14: Using XML Data
The XML Data Type
XML Data Type Methods
FOR XML
XQuery and FLWOR Operations
Summary
Chapter 15: Executing Distributed Queries
Distributed Query Overview
Developing Distributed Queries
Performance Consideration
Summary
Part IV: Programming with T-SQL
Chapter 16: Programming with T-SQL
Transact-SQL Fundamentals
Working with Variables
Procedural Flow
Examining SQL Server with Code
Temporary Tables and Table Variables
What's New in T-SQL for 2012
Error Handling
Bulk Operations
Summary
Chapter 17: Developing Stored Procedures
Managing Stored Procedures
Passing Data to Stored Procedures
Returning Data from Stored Procedures
Summary
Chapter 18: Building User-Defined Functions
Scalar Functions
Inline Table-Valued Functions
Multistatement Table-Valued Functions
Best Practices with User-Defined Functions
Summary
Part V: Enterprise Data Management
Chapter 19: Configuring SQL Server
Setting the Options
Configuration Options
Summary
Chapter 20: Policy Based Management
Defining Policies
Evaluating Policies
Summary
Chapter 21: Backup and Recovery Planning
Recovery Concepts
Recovery Models
Backing Up the Database
Working with the Transaction Log
Recovery Operations
System Databases Recovery
Performing a Complete Recovery
Summary
Chapter 22: Maintaining the Database
DBCC Commands
Managing Database Maintenance
Summary
Chapter 23: Transferring Databases
Copy Database Wizard
Working with SQL Script
Detaching and Attaching
Import and Export Wizard
Data-Tier Application (DAC)
Summary
Chapter 24: Database Snapshots
How Do Database Snapshots Work?
Using Database Snapshots
Summary
Chapter 25: Asynchronous Messaging with Service Broker
Configuring a Message Queue
Working with Dialogs
What's New in Service Broker for SQL Server 2012?
Monitoring and Troubleshooting Service Broker
Summary
Chapter 26: Log Shipping
Availability Testing
Warm Standby Availability
Defining Log Shipping
Checking Log Shipping Configuration
Monitoring Log Shipping
Modifying or Removing Log Shipping
Switching Roles
Summary
Chapter 27: Database Mirroring
Database Mirroring Overview
Defining and Configuring Database Mirroring
Checking Database Mirroring Configuration
Monitoring Database Mirroring
Pausing or Removing Database Mirroring
Role Switching
High Availability/AlwaysOn
Summary
Chapter 28: Replicating Data
Moving Data Between Servers
Replication Concepts
Configuring Replication
Summary
Chapter 29: Clustering
What Does Clustering Do?
Configuring Clustering
Summary
Chapter 30: Configuring and Managing SQL Server with PowerShell
Why Use PowerShell?
Basic PowerShell
SQL Server PowerShell Extensions
Communicating with SQL Server via SMO
Scripting SQL Server Tasks
Summary
Chapter 31: Managing Data in Windows Azure SQL Database
Overview of Azure SQL Database
Managing Windows Azure SQL Database
High Availability and Scalability
Migrating Data to SQL Database
Summary
Part VI: Securing Your SQL Server
Chapter 32: Authentication Types in SQL Server
Windows Authentication
SQL Authentication
Differences Between SQL and Windows Authentication
Kerberos and Windows Authentication Delegation
Summary
Chapter 33: Authorizing Securables
Permission Chains
Object Ownership
Securables Permissions
Object Security
A Sample Security Model
Views and Security
Summary
Chapter 34: Data Encryption
Introducing Data Encryption
Summary
Chapter 35: Row-Level Security
The Security Table
Assigning Permissions
Checking Permissions
Summary
Part VII: Monitoring and Auditing
Chapter 36: Creating Triggers
Trigger Basics
Working with the Transaction
Multiple-Trigger Interaction
Transaction-Aggregation Handling
DDL Triggers
Managing DDL Triggers
Developing DDL Triggers
Summary
Chapter 37: Performance Monitor and PAL
Using PerfMon
Summary
Chapter 38: Using Profiler and SQL Trace
Features of SQL Server Profiler
Running Profiler
Using SQL Trace
Summary
Chapter 39: Wait States
The SQL Server OS
Examining Wait Statistics
Common Red-Flag Wait Types
Other Ways to Gather Wait data
Summary
Chapter 40: Extended Events
The Extended Events Object Model
The system_health Session
The Extended Events Profiler
Summary
Chapter 41: Data Change Tracking and Capture
Configuring Change Tracking
Querying Change Tracking
Removing Change Tracking
Change Data Capture
New in SQL Server 2012
Enabling CDC
Working with Change Data Capture
Removing Change Data Capture
Summary
Chapter 42: SQL Audit
SQL Audit Technology Overview
Creating an Audit
Server Audit Specifications
Database Audit Specifications
Viewing the Audit Trail
Summary
Chapter 43: Management Data Warehouse
Using the Management Data Warehouse
Configuring MDW
Setting Up Data Collection
Viewing MDW Reports
Creating Custom Data Collector Sets
Summary
Part VIII: Performance Tuning and Optimization
Chapter 44: Interpreting Query Execution Plans
Viewing Query Execution Plans
Understanding Execution Plan Operators
Summary
Chapter 45: Indexing Strategies
Zen and the Art of Indexing
Indexing Basics
The Path of the Query
A Comprehensive Indexing Strategy
Specialty Indexes
Summary
Chapter 46: Maximizing Query Plan Reuse
Query Compiling
Query Recompiles
Summary
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
Understanding Data Compression
Applying Data Compression
Summary
Chapter 49: Partitioning
Partitioning Strategies
Partitioned Views
Partitioned Tables and Indexes
Summary
Chapter 50: Resource Governor
Exploring the Fundamentals of the Resource Governor
Performance Monitoring of Resource Governor
Views and Limitations
Summary
Part IX: Business Intelligence
Chapter 51: Business Intelligence Database Design
Data Warehousing
Designing a Data Warehouse Using a Star Schema
Designing Your Data Warehouse Using a Snowflake Schema
Ensuring Consistency within a Data Warehouse
Loading Data
Summary
Chapter 52: Building, Deploying, and Managing ETL Workflows in Integration Services
Exploring the SSIS Environment in Brief
Exploring the SSIS Environment in More Detail
Deploying and Executing Projects and Packages
Summary
Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX
Analysis Services Quick Start
Analysis Services Architecture
Building a Database
Dimensions
Cubes
Data Storage
Cube Processing
Summary
Chapter 54: Configuring and Administering Analysis Services
Installing Analysis Services
Configuring Basic Analysis Services Settings
Advanced SSAS Deployments
Reviewing Query Performance with SQL Profiler
Summary
Chapter 55: Authoring Reports in Reporting Services
Report Authoring Environments
The Basic Elements of a Report
Building a Report with the Report Wizard
Authoring a Report from Scratch
Exploring the Report Designer
Using Reporting Services Features to Visualize Your Data
Designing the Report Layout
Building Reports with Report Builder
Summary
Chapter 56: Configuring and Administering Reporting Services
Installing Reporting Services
Deploying Reporting Services Reports
Managing Security with Reporting Services
Disaster Recovery
Summary
Chapter 57: Data Mining with Analysis Services
The Data Mining Process
Modeling with Analysis Services
Algorithms
Cube Integration
Summary
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
Power View Requirements
Creating and Deploying Reports with Power View
Deploying Power View Reports
Summary
Introduction
← Prev
Back
Next →
← Prev
Back
Next →