Microsoft SQL Server 2008 Bible
- 27h 5m
- Mike White, Paul Nielsen, Uttam Parui
- John Wiley & Sons (US)
- 2009
Whether you're a database developer, DBA, or BI Developer, SQL Server 2008 promises to change the way you deliver enterprise data solutions. Open this detailed, experience-based guide for clear explanations of the concepts balanced with real-world examples and best practices gleaned from years of field and consulting experience. SQL Server is an immense product — this book is your guide to the strategies and details that matter most.
- Master the data architecture concepts that drive database technologies
- Write elegant set-based queries that respond well to a comprehensive indexing strategy
- Code an efficient and robust data abstraction layer with stored procedures
- Learn the best way to connect to SQL Server with ADO or Microsoft Access
- Use PowerShell and Policy-based Management to better administer your servers
- Use Analysis Services, MDX, and Excel to analyze data trends
- Optimize performance with data compression, resource governor, and partitioning
In this Book
-
Foreword
-
Introduction
-
The World of SQL Server
-
Data Architecture
-
Relational Database Design
-
Installing SQL Server 2008
-
Client Connectivity
-
Using Management Studio
-
Scripting with PowerShell
-
Introducing Basic Query Flow
-
Data Types, Expressions, and Scalar Functions
-
Merging Data with Joins and Unions
-
Including Data with Subqueries and CTEs
-
Aggregating Data
-
Windowing and Ranking
-
Projecting Data through Views
-
Modifying Data
-
Modification Obstacles
-
Traversing Hierarchies
-
Manipulating XML Data
-
Using Integrated Full-Text Search
-
Creating the Physical Database Schema
-
Programming with T-SQL
-
Kill the Cursor!
-
T-SQL Error Handling
-
Developing Stored Procedures
-
Building User-Defined Functions
-
Creating DML Triggers
-
DDL Triggers
-
Building Out the Data Abstraction Layer
-
Dynamic SQL and Code Generation
-
Bulk Operations
-
Executing Distributed Queries
-
Programming with ADO.NET 3.5
-
Sync Framework
-
LINQ
-
Asynchronous Messaging with Service Broker
-
Replicating Data
-
Performing ETL with Integration Services
-
Access as a Front End to SQL Server
-
Configuring SQL Server
-
Policy-Based Management
-
Recovery Planning
-
Maintaining the Database
-
Automating Database Maintenance with SQL Server Agent
-
Transferring Databases
-
Database Snapshots
-
Log Shipping
-
Database Mirroring
-
Clustering
-
Authenticating Principals
-
Authorizing Securables
-
Data Cryptography
-
Row-Level Security
-
Data Audit Triggers
-
Schema Audit Triggers
-
Performance Monitor
-
Tracing and Profiling
-
Wait States
-
Extended Events
-
Change Tracking
-
Change Data Capture
-
SQL Audit
-
Management Data Warehouse
-
Interpreting Query Execution Plans
-
Indexing Strategies
-
Query Plan Reuse
-
Managing Transactions, Locking, and Blocking
-
Data Compression
-
Partitioning
-
Resource Governor
-
BI Design
-
Building Multidimensional Cubes with Analysis Services
-
Programming MDX Queries
-
Authoring Reports with Reporting Services
-
Administering Reporting Services
-
Analyzing Data with Excel
-
Data Mining with Analysis Services
SHOW MORE
FREE ACCESS