[Pluralsight.com] SQL Server - TSQL [2010, ENG]

Содержание

T-SQL and the CLR
T-SQL and CLR Overview
Why use the CLR?
Visual Studio and Extensions
Demo:Simple UDF
Demo:Directly adding UDF
Demo:Debugging Extension
Assembly Permission
Demo:Create Assembly Permission
Demo:CLR Enable
Demo:External Access Trustworthy
Demo:External Access Signed
CLR in a Box
SqlFunction Attribute
Data Access
Table Valued Functions
Conclusion
T-SQL and the CLR II
T-SQL and CLR II Overview
SqlTypes
SqlTypes vs. .NET Types
Equivalent Types
Null Support
SqlString
Stored Procedures
Stored Procedure Basics
SqlContext
SqlPipe Messages
Constructed Resultset
Fibonacci Series
Implementing Fibonacci Series
Stored Procedure Database Access
Aggregate Functions
SqlUserDefinedAggregate
SumSpecial User Defined Aggregate
Summary
References
T-SQL I
Title
Overview
Table Row Constructor
Table Row Constructor Examples
Output Clause
Output Clause Examples
Large Datatypes
Large Datatypes Examples
Covering Index
Covering Index Examples
Summary
T-SQL II
Overview
Top
Top Example
Top and Modifications
Exceptions
Exception Information
Exception Example
Exception and Fatal Error
Uncommitable Transaction
Error Functions
Error Severity
Summary
T-SQL III
Overview
Isolation
Snapshot implements isolation
Transaction and isolation
Missing Update
Incoherent Data
Serialized Access
Most data not shared
Transactions run in isolation
Implementing serializable isolation
Locks and blocking
Implementing snapshot isolation
Example read committed
Example snapshot
Snapshots and writes
Version lifetime
Read committed snapshot
Example read committed snapshot
Snapshot management
Summary

Скриншоты