| Description |
1 online resource |
| Series |
Safari Books Online.
|
| Summary |
Provides programming instructions and code examples for Microsoft SQL Server 2008. |
| Contents |
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 |
| Subject |
SQL server.
|
|
SQL server. |
|
SQL server |
|
Client/server computing.
|
|
Programming (Computers)
|
|
Architecture client-serveur (Informatique) |
|
Client/server computing. |
|
Client/server computing |
|
Engineering & Applied Sciences. |
|
Computer Science. |
| Added Author |
Brust, Andrew J. Author.
|
|
Forte, Stephen. Author.
|
|
Atkins, Kathleen. Editor.
|
|
Scribner, Kenn. Reviewer.
|
| Other Form: |
Print version: Lobel, Leonard. Programming Microsoft SQL Server 2008. Redmond, Wash. : Microsoft Press, ©2009 9780735625990 (DLC) 2008935426 (OCoLC)274184172 |
| ISBN |
0735625999 |
|
9780735625990 |
|
9780735636293 (electronic bk.) |
|
073563629X (electronic bk.) |
|
9780735638198 (electronic bk.) |
|
0735638195 (electronic bk.) |
|
More Resources