Programming Microsoft® SQL Server® 2008
Extend your programming skills with a comprehensive study of the key features of SQL Server 2008. Delve into the new core capabilities, get practical guidance from expert developers, and put their code samples to work. This is a must-read for Microsoft .NET and SQL Server developers who work with d...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627365306719 |
Tabla de Contenidos:
- Programming Microsoft® SQL ServerTM 2008; Introduction; How This Book Is Organized; Code Samples and the Book's Companion Web Site; Using the Sample AdventureWorks2008 Databases; System Requirements; Support for This Book; I. Core Fundamentals; A Book for Developers; A Book by Developers; A Book to Show You the Way; Beyond Relational; Reaching Out; Business Intelligence Strategies; Summary; 2. T-SQL Enhancements; The PIVOT and UNPIVOT Operators; Dynamically Pivoting Columns; The APPLY Operator; TOP Enhancements; Ranking Functions; Grouping and Filtering with ROW_NUMBER; The RANK Function
- The DENSE_RANK and NTILE FunctionsUsing All the Ranking Functions Together; Ranking over Groups Using PARTITION BY; Exception Handling in Transactions; The varchar(max) Data Type; The WAITFOR Statement; DDL Triggers; SNAPSHOT Isolation; Table-Valued Parameters; Working with a Multiple-Row Set; Using TVPs for Bulk Inserts and Updates; Working with a Single Row of Data; Creating Dictionary-Style TVPs; Passing TVPs Using ADO.NET; TVP Limitations; New Date and Time Data Types; More Portable Dates and Times; Time Zone Awareness; Date and Time Accuracy, Storage, and Format
- New and Changed FunctionsThe MERGE Statement; The WHEN MATCHED Clause; The WHEN NOT MATCHED BY TARGET Clause; Using MERGE for Table Replication; The WHEN NOT MATCHED BY SOURCE Clause; MERGE Output; Choosing a Join Method; MERGE DML Behavior; Doing the ""Upsert""; The INSERT OVER DML Syntax; Consuming CHANGES; The GROUPING SETS Operator; Rolling Up All Level Combinations; Returning Just the Top Level; Mixing and Matching; Handling NULL Values; New T-SQL Shorthand Syntax; Summary; 3. Exploring SQL CLR; Visual Studio/SQL Server Integration; Automated Deployment; SQL CLR Code Attributes
- Your First SQL CLR Stored ProcedureCLR Stored Procedures and Server-Side Data Access; Deployment; Deploying Your Stored Procedures; Testing Your Stored Procedures; CLR Functions; CLR Triggers; CLR Aggregates; SQL CLR Types; Security; Examining and Managing SQL CLR Types in a Database; Best Practices for SQL CLR Usage; Summary; 4. Server Management; Latest Features in SMO; Working with SMO in Microsoft Visual Studio; Retrieving Server Settings; Creating Backup-and-Restore Applications; Progress Meter; Log Backup; Verify; Restore; Restoring to a Different Location
- Performing Programmatic DBCC Functions with SMOPolicy-Based Management; Summary; 5. Security in SQL Server 2008; Secure by Default; Secure by Deployment; Secure Communications; SQL Server 2008 Security Overview; Database Users; The guest User Account; Authentication and Authorization; Password Policies; User-Schema Separation; Execution Context; Encryption Support in SQL Server; Encrypting Data at Rest; Transparent Data Encryption in SQL Server 2008; Enabling TDE; Querying TDE Views; Backing Up the Certificate; Restoring an Encrypted Database; SQL Server Audit; Auditing Options; ON_FAILURE
- AUDIT_GUID
