Nielsen Paul, Parui Uttam. Microsoft SQL Server 2008 Bible (With Source Code)

Wiley, 2009. — 1680 p. — ISBN: 978-0-470-25704-3.
Language: English.Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible. Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release. 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 partitioningForeword.Laying the Foundation.
The World of SQL Server.
Data Architecture.
Relational Database Design.
Installing SQL Server 2008.
Client Connectivity.
Using Management Studio.
Scripting with PowerShell.Manipulating Data with Select.
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.Beyond Relational.
Traversing Hierarchies.
Manipulating XML Data.
Using Integrated Full-Text Search.Developing with SQL Server.
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.Data Connectivity.
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.Enterprise Data Management.
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.Security.
Authenticating Principals.
Authorizing Securables.
Data Cryptography.
Row-Level Security.Monitoring and Auditing.
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.Performance Tuning and Optimization.
Interpreting Query Execution Plans.
Indexing Strategies.
Query Plan Reuse.
Managing Transactions, Locking, and Blocking.
Data Compression.
Partitioning.
Resource Governor.Business Intelligence.
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.Appendixs
SQL Server 2008 Specifications.
Using the Sample Databases.