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

SQL ServerSQL Developer


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 Developer


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

SQL ServerSQL Developer


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 DeveloperSQL Server


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

SQL DeveloperSQL Server


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

SQL Developer