Programming Microsoft SQL Server 2008 /

Provides programming instructions and code examples for Microsoft SQL Server 2008.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Lobel, Leonard, Brust, Andrew J. (Autor), Forte, Stephen (Autor)
Otros Autores: Atkins, Kathleen (Editor ), Scribner, Kenn (Revisador)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Redmond, Wash. : Microsoft Press, ©2009.
Colección:Safari Books Online.
Temas:
SQL server.
SQL server
Client/server computing.
Programming (Computers)
Architecture client-serveur (Informatique)
COMPUTERS > Database Management > General.
COMPUTERS > Desktop Applications > Databases.
COMPUTERS > System Administration > Storage & Retrieval.
Client/server computing
Engineering & Applied Sciences.
Computer Science.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
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

Ejemplares similares