Limit search to available items
Book Cover
E-book
Author Lobel, Leonard.

Title Programming Microsoft SQL Server 2008 / Leonard Lobel, Andrew J. Brust, Stephen Forte ; project editor, Kathleen Atkins ; technical reviewer, Kenn Scribner
Published Redmond, Wash. : Microsoft Press, ©2009

Copies

Description 1 online resource
Series Safari Books Online
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
Summary Provides programming instructions and code examples for Microsoft SQL Server 2008
SUBJECT SQL server. http://id.loc.gov/authorities/names/n90684343
SQL server. blmlsh
SQL server fast
Subject Client/server computing.
Programming (Computers)
COMPUTERS -- Database Management -- General.
COMPUTERS -- Desktop Applications -- Databases.
COMPUTERS -- System Administration -- Storage & Retrieval.
Client/server computing.
Client/server computing
Engineering & Applied Sciences.
Computer Science.
Form Electronic book
Author Brust, Andrew J.
Forte, Stephen.
Atkins, Kathleen.
Scribner, Kenn.
LC no. 2008935426
ISBN 0735625999
9780735625990
9780735636293
073563629X
9780735638198
0735638195
Other Titles ITPro