SQL Server 2012 Database Server Programmability This content in this unit provides an overview of improvements in SQL Server 2012 that affect server programmability, including Transact-SQL, spatial types, and handing unstructured data. Hands-On Labs Exploring Transact-SQL Improvements in SQL Server 2012 (RTM Update) In this lab, you will learn to use three improved features in the new SQL Server 2012. These features include creating sequences and using them to insert new rows in any table, querying data through pages iteratively, and raising and catching exceptions using Throw/Catch statements. Managing Rich Unstructured Data in SQL Server 2012 (RTM Update) This lab describes the Filetable feature, and how to use it with the Microsoft SQL Server 2012 Semantics Language Statistics database. Videos Presentation: Introducing SQL Server 2012 Transact-SQL Improvements SQL Server 2012 introduces several Transact-SQL improvements that impact developer productivity and support for key standards, including easier query results pagination and sequence generators. Demo: Simplified Result Set Paging with SQL Server 2012 This demo shows how to replace code that was based on CTEs and ROW_NUMBER() to provide query pagination in earlier versions of SQL Server, to use the new OFFSET and FETCH clauses provided by SQL Server 2012 Presentation: Introducing SQL Server 2012 Spatial Improvements Developers who exploit spatial data types in their applications will find some helpful improvements in SQL Server 2012, including support for new shapes and methods, full globe support and spatial index enhancements. Demo: Implementing a 'Nearest Neighbor' Spatial Query with SQL Server 2012 This demo shows you the types of queries that received a significant performance improvement when working with spatial data types in SQL Server 2012. Presentation: Storing and Querying Documents with SQL Server 2012 SQL Server 2012 combines the high performance database blob storage capabilities of FILESTREAM with new SMB file sharing capabilities of FileTable to enable rich support for content as an integrated part of a database application. Once content is managed by SQL Server, exciting new search scenarios can be powered by full text search and statistical semantic search. Demo: Accessing Documents With SQL Server 2012 FileTable This demo shows how to create a FileTable and to view the metadata provided by the FileTable feature. Presentation: Introducing SQL Server 2012 Express Local Database Runtime SQL Server 2012 Express Edition introduces a new deployment option called Local Database Runtime. LocalDb is a small shared component (not a service) that installs in five minutes or less that is ideal for applications or tools that need an embedded database that is API compatible with SQL Server. Demo: Using SQL Server 2012 Express Local Database Runtime as an Embedded Database This demo shows how a developer can redistribute the SQL Server 2012 Express Local Database Runtime with a custom application and use it as an embedded database.