Blog: SQL Developer
SQL 2012: Developer: NULLs and SqlBoolean
By Frank Tillinghast
When integrating T-SQL with the CLR, remember to declare variables, parameters, and return values of data types exposed through the System.Data.SqlTypes namespace.
This blog entry was originally posted March 06, 2014 by Frank Tillinghast
Microsoft SQL 2012 Developer: Creating Partitioned Tables
By Frank Tillinghast
SQL Server 2012 includes the T-SQL extensions to allow for partitioned tables and indexes.
This blog entry was originally posted February 04, 2014 by Frank Tillinghast
SQL 2012: Aggregates
Excerpt by Don Kiely
One of the more exciting types of SQLCLR code modules is custom aggregates.
This course excerpt was originally posted January 08, 2014 from the online courseware SQL 2012 Developer, Part 06 of 13: Advanced SQL CLR by Don Kiely
Isolation Levels and Transactions - Microsoft SQL
Excerpt by Don Kiely
An isolation level defines how much a transaction is isolated from changes made by other, concurrent transactions.
This course excerpt was originally posted January 01, 2014 from the online courseware SQL 2012 Developer, Part 08 of 13: Advanced T-SQL Queries by Don Kiely
SQL 2012 Developer: Aggregates
Excerpt by Don Kiely
One of the more exciting types of SQLCLR code modules is custom aggregates.
This course excerpt was originally posted September 11, 2013 from the online courseware SQL 2012 Developer, Part 06 of 13: Advanced SQL CLR by Don Kiely
Introduction to Views
Excerpt by Don Kiely
You can use a SQL SELECT statement to read data from one or more tables in a relational database. This is such a common operation that SQL provides a way to save a SELECT statement as a persistent database object, called a view.
This course excerpt was originally posted July 24, 2013 from the online courseware SQL 2012 Developer, Part 01 of 13: Views by Don Kiely