The content in this unit provides an overview of tools technologies and that impact database application development during the SQL Server 2012 wave.
Hands-On Labs
Exploring the SQL Server 2012 Data Tools for Visual Studio 2010 (RTM Update)
In this lab, you will learn to use the SQL Server Data Tools for Microsoft Visual Studio 2010 that are introduced with the SQL Server 2012 release. The tools provide both connected and disconnected project models. The tools are designed to help to provide a one-stop-shop for developers and to minimize the number of external tools that a developer needs to work with when developing for SQL Server.
Videos
Presentation: Introducing SQL Server Data Tools for Visual Studio 2010
SQL Server Data Tools provides a modern development experience for building database applications, and makes it easy to target both your on-premise environment and the cloud.
Demo: Declarative Database Development with SQL Server 2012 Data Tools
This demo provides a first look at SQL Server Data Tools and connected development with tools like the SQL Server Object Explorer and Query Window which will alleviate the need for developers to install other tools like SQL Server Management Studio. It also shows how to create an offline database project based upon an existing database, make changes to it, and test it locally using the integrated Local Database Runtime (LocalDb).
Presentation: Introducing Data-Tier Applications
Data-Tier Applications, or DAC FX, provides a set of API's, tools and services that dramatically simplify developing, deploying and versioning databases for both your on-premise environment and the cloud. This presentation will talk about what's new with DAC Fx including support for in-place upgrades, integration with SSDT, support for new objects and more.
Demo: Performing an In-Place Upgrade of a SQL Server 2012 Data-tier Application
The Data-Tier Application Framework (DAC Fx) is a powerful new way to deploy and upgrade database projects for both your on-premise and cloud applications. Prior releases of DAC Fx only supported side-by-side upgrades. SQL Server 2012 includes DAC Fx 3.0, which supports the ability to perform in-place upgrades.
Presentation: What's New in .NET 4.0 and SQL Server 2012
Developers leveraging the ADO.NET Entity Framework as an ORM layer will find improved integration with SQL Server 2012 including support for more objects, improved support for stored procedures and improved performance.
Demo: Using ADO.NET Entity Framework Code-First Functionality
This demo shows how to create an ASP.NET MVC application that uses the model-first (also known as code-first) functionality provided by the ADO.NET Entity Framework.
Presentation: Introducing StreamInsight 2.0
StreamInsight 2.0 is a set of APIs and services included with SQL Server 2012 that helps database developers address real-time data processing workloads, and makes it it easy to develop standing queries over continuous event-stream data that deliver real-time insight.
Demo: Developing Standing Queries over Observable .NET Classes with StreamInsight 2.0
StreamInsight makes it easy to build standing queries over event-stream data that are continuously evaluated. StreamInsight 2.0 introduces support for observable .NET classes as an event source, which dramatically simplifies the coding required to start querying many different types of event streams.