Pro T-SQL programmer's guide. ([2015])

• Record Type: Book
• Uniform Title: Pro T-SQL 2005 programmer's guide
• Further Information: Note: Miguel Cebollero, Michael Coles, and Jay Natarajan.
• Authors: Cebollero, Miguel; Coles, Michael, 1972-; Natarajan, Jay
• Contents: At a Glance; Introduction; Chapter 1: Foundations of T-SQL; A Short History of T-SQL; Imperative vs. Declarative Languages; SQL Basics; Statements; Databases; Transaction Logs; Schemas; Tables; Views; Indexes; Stored Procedures; User-Defined Functions; SQL CLR Assemblies; Elements of Style; Whitespace; Naming Conventions; One Entry, One Exit; Defensive Coding; The SELECT * Statement; Variable Initialization; Summary; Chapter 2: Tools of the Trade; SQL Server Management Studio; IntelliSense; Code Snippets; Keyboard Shortcut Schemes; T-SQL Debugging; SSMS Editing Options. Context-Sensitive HelpGraphical Query Execution Plans; Project-Management Features; The Object Explorer; The SQLCMD Utility; SQL Server Data Tools; SQL Profiler; Extended Events; SQL Server Integration Services; The Bulk Copy Program; SQL Server 2014 Books Online; The AdventureWorks Sample Database; Summary; Chapter 3: Procedural Code; Three-Valued Logic; Control-of-Flow Statements; The BEGIN and END Keywords; The IF ... ELSE Statement; The WHILE, BREAK, and CONTINUE Statements; The GOTO Statement; The WAITFOR Statement; The RETURN Statement; The CASE Expression; The Simple CASE Expression. The Searched CASE ExpressionCASE and Pivot Tables; The IIF Statement; CHOOSE; COALESCE and NULLIF; Cursors; Summary; Chapter 4: User-Defined Functions; Scalar Functions; Recursion in Scalar User-Defined Functions; Procedural Code in User-Defined Functions; Multistatement Table-Valued Functions; Inline Table-Valued Functions; Restrictions on User-Defined Functions; Nondeterministic Functions; State of the Database; Summary; Chapter 5: Stored Procedures; Introducing Stored Procedures; Metadata Discovery; Natively Compiled Stored Procedures; Managing Stored Procedures. Stored Procedures Best PracticesStored Procedure Example; Recursion in Stored Procedures; Table-Valued Parameters; Temporary Stored Procedures; Recompilation and Caching; Stored Procedure Statistics; Parameter Sniffing; Recompilation; Summary; Chapter 6: In-Memory Programming; The Drivers for In-Memory Technology; Hardware Trends; Getting Started with In-Memory Objects; Step 1: Add a New Memory-Optimized Data FILEGROUP; Step 2: Add a New Memory-Optimized Container; Step 3: Create Your New Memory-Optimized Table; Limitations on Memory-Optimized Tables; In-Memory OLTP Table Indexes. Hash IndexesRange Indexes; Natively Compiled Stored Procedures; Chapter 7: Triggers; DML Triggers; Multiple Triggers; When to Use DML Triggers; Inserted and Deleted Virtual Tables; Auditing with DML Triggers; Using Change Data Capture Instead; Sharing Data with Triggers; Nested and Recursive Triggers; The UPDATE() and COLUMNS_UPDATED() Functions; Triggers on Views; DDL Triggers; DDL Event Types and Event Groups; Logon Triggers; Summary; Chapter 8: Encryption; The Encryption Hierarchy; Service Master Keys; Database Master Keys; Certificates; Asymmetric Keys; Asymmetric Key "Backups."
• Edition: Fourth edition
• Publisher Details: Berkeley, CA : Apress
• Publication Date: 2015
• Copyright Date: 2015
• Extent: 1 online resource
• Subjects: 005.576; Computer science; SQL (Computer program language); Client/server computing; COMPUTERS -- Desktop Applications -- Suites; Client/server computing; SQL (Computer program language); Database management; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484201459; 1484201450; 1484201469; 9781484201466
• Related ISBNs: 9781484201466
• Notes: Note: Online resource; title from PDF title page (EBSCO, viewed March 9, 2015).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.