Meet Our Experts
Frank Tillinghast
Webinars
SQL Server Partitioning
Partitioning data is an essential part of creating and maintaining large databases. In this session we'll look at how to create partitioned tables and indexes using SQL Server 2012. Then we'll move on to querying partitions and finish up with how to ...
SQL Server 2008; Partitioning
This session will discusses the fundamentals of table-based partitioning in SQL Server 2008. A challenge facing all developers is to design systems that are maintainable, scalable, and perform well. Table-based partitioning is one approach to help to...
Courses
SQL 2014 Developer, Part 13 of 13: Working with XML
In this course we’ll explore SQL Server’s support for XML and how it’s improved since being introduced in SQL Server 2000. We’ll discuss SQL Server’s native XML data type—how to declare it as a variable or table column, how it differs from other data...
SQL 2014 Developer, Part 12 of 13: Coding Techniques
As business systems become more intricate, so does the T-SQL development needed to get at that data. In this course we’ll discuss some of the challenges facing developers including complex data types and structures; the “art” of writing efficient que...
SQL 2014 Developer, Part 11 of 13: Complex Querying
We’ll start off by discussing the specifics of a topic you might not expect—handling NULLs! I know it sounds surprising, but it’s important to really understand how to work with NULL values—especially if you plan to integrate with the Common Language...
SQL 2014 Developer, Part 10 of 13: Partitions
In this course we’ll explore partitioning, and specifically how it’s implemented using SQL Server. Partitioning is a way to manage large amounts of data, and while certainly not a new concept, SQL Server has made improvements over the years that make...
SQL 2012 Developer, Part 13 of 13: Working with XML
In this course we’ll explore SQL Server’s support for XML and how it’s improved since being introduced in SQL Server 2000. We’ll discuss SQL Server’s native XML data type—how to declare it as a variable or table column, how it differs from other data...
SQL 2012 Developer, Part 12 of 13: Coding Techniques
As business systems become more intricate, so does the T-SQL development needed to get at that data. In this course we’ll discuss some of the challenges facing developers including complex data types and structures; the “art” of writing efficient que...
SQL 2012 Developer, Part 11 of 13: Complex Querying
We’ll start off by discussing the specifics of a topic you might not expect—handling NULLs! I know it sounds surprising, but it’s important to really understand how to work with NULL values—especially if you plan to integrate with the Common Language...
SQL 2012 Developer, Part 10 of 13: Partitions
In this course we’ll explore partitioning, and specifically how it’s implemented using SQL Server 2012. Partitioning is a way to manage large amounts of data, and while certainly not a new concept, SQL Server has made improvements over the years that...
Blogs
SQL 2012: Developer: NULLs and SqlBoolean
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.
Microsoft SQL 2012 Developer: Creating Partitioned Tables
SQL Server 2012 includes the T-SQL extensions to allow for partitioned tables and indexes.