Demo 2 of 4 from the Shawn Bice keynote at SQLConnections

Demo 1 of 4 from the Shawn Bice keynote at SQLConnections

Demo 3 of 4 from the Shawn Bice keynote at SQLConnections

Demo 4 of 4 from the Shawn Bice keynote at SQLConnections

This presentation provides an overview of failover clustering imporvements introduced in SQL Server 2012 AlwaysOn. Jonathan Kehayias Principal Consultant, SQLskills

This demonstration shows how to configure the flexible failover policy for SQL Server 2012 AlwaysOn Failover Clustering. Jonathan Kehayias Principal Consultant, SQLskills

Columnstore indexes provide an easy way to significantly improve data warehouse and decision support query performance against very large data sets. Joe Sack Principal Consultant, SQLskills

This demonstration shows how to implement Columnstore Indexes, establish the performance impact for a standard data warehouse query and lastly show how to modify rows for a table with a Columnstore…

This demonstration shows how to configure Readable Secondaries in an Availability group to maximize the utilization of the hardware in the environment by offloading Read Only workloads to the…

This presentation provides an overview of SQL Server 2012 AlwaysOn support for readable secondary replicas which can help maximimize hardware utilization by servicing read-only workloads like backup…

SQL Server 2012 offers several important improvements that related to table partitioning, including more partitions per table, improved online operations, better index build performance and new…

This demo shows how to use the enhanced Partition Wizard to switch out and switch in a partition. We'll demonstrate this enhanced UI against a table with more than 1,000 partitions (by example…

In this presentation we'll cover SQL Server 2012 improvements that impact security and auditing, including new support for default schema for groups, user-defined server roles and various auditing…

This demo shows how to create a user-defined server role in Transact-SQL. In five minutes we'll walk through how to create a role, add members, remove a member, grant permissions to the role and…

This demonstration shows how to use the new Extended Events wizards and interfaces in SQL Server Management Studio. Jonathan Kehayias Principal Consultant, SQLskills

SQL Server 2012 introduces an important new utility called Distributed Replay that will change the way you benchmark and test your database workloads. Joe Sack Principal Consultant, SQLskills

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. Dr…

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…

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…

This presentation covers new features that impact SQL Server developers in .NET 4.0. Dr Greg Low SQL Server MVP and Microsoft RD

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. Dr Greg Low SQL Server MVP and…

StreamInsight 1.2 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…

This demonstration identifies and loads unique (non-duplicate) resellers into the Reseller entity of a Master Data Services (MDS) model. It involves creating a Data Quality Services (DQS) knowledge…

This presentation provides an overview of the new high availabilty and disaster recovery capabilities provided by SQL Server 2012 AlwaysOn, including Availability Groups, partial containment and…

This demonstration shows how to create a SQL Server 2012 AlwaysOn Availability Group and how to add an additional replica to an existing Availability Group using the SQL Server Management Studio…

This demonstration shows how to configure an Availability Group Listener for a SQL Server 2012 AlwaysOn Availability Group. The Availability Group Listener provides the Virtual Network Name that…

SQL Server extended events enable rich diagnostic troubleshooting capabilities, and SQL Server 2012 provides new tools and APIs for extended events. Jonathan Kehayias Principal Consultant, SQLskills

This demonstration shows how to launch the Distributed Replay controller and client, pre-process a trace file workload, launch the workload and validate that it is running through SQL Server Profiler.…

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…

This demo shows you the types of queries that received a significant performance improvement when working with spatial data types in SQL Server 2012. Dr Greg Low SQL Server MVP and Microsoft RD

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…

This demo shows how to create a FileTable and to view the metadata provided by the FileTable feature. Dr Greg Low SQL Server MVP and Microsoft RD

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…

This demonstration covers usage of SQL Server 2012 Express Local Database Runtime as an embedded database. Dr Greg Low SQL Server MVP and Microsoft RD

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. Dr Greg Low SQL Server…

SQL Server 2012 Data Quality Services is a new knowledge-driven data cleansing solution that makes it easy to correct and de-duplicate data. DQS makes it easy for domain experts to build and improve…

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…

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…

StreamInsight makes it easy to build standing queries over event-stream data that are continuously evaluated. StreamInsight 1.2 introduces support for observable .NET classes as an event source,…

SQL Server 2012 Integration Services introduces a host of new improvements of interest to developers and IT Professionals alike. Developers will appreciate a greatly improved package design…

This demonstration explores the new features of SQL Server 2012 Integration Services (SSIS). Specifically it covers project conversion, parameters, project connection managers, deployment to the SSIS…

This demonstration creates a new model and then uses the Master Data Services (MDS) Add-in for Excel to create and load two entities. Then in the Master Data Manager web application, the loaded…

SQL Server 2012 Master Data Services is a set of tools and services that can be used to integrate disparate information systems that share common data sets into a common master data management…

SQL Server 2012 Analysis Services introduces an impressive array of improvements designed to expand the reach a broader user base. SSAS brings together the existing multi-dimensional model with the…

This demonstration develops a basic tabular project in Visual Studio. The project will be enhanced in the following demonstration (SQL11UPD06-DEMO-02) by adding new Data Analysis Expressions (DAX)…

The SQL Server 2012 Analysis Services release embraces tabular model development. The tabular development approach, introduced with SQL Server 2008 R2 PowerPivot, is now available to the IT…

This demonstration explores two topics related to Data Analysis Expressions (DAX) improvements in SQL Server 2012. Peter Myers Mentor, SolidQ

SQL Server 2012 Reporting Services has been upgraded with new features and capabilities, including an exciting new self-service visual design experience named Power View, increased end-user…

This demonstration creates a shared data source, uploads an existing report definition, and then relates the report's data source to the newly created data source. Then it proceeds to create a new…

This demonstration shows how to create a SQL Server 2012 AlwaysOn Availability Group and how to add an additional replica to an existing Availability Group using the SQL Server Management Studio…

SQL Server 2012 Reporting Services introduces Power View, an interactive data exploration, visualization, and presentation experience which provides intuitive self-service reporting for business users…

This demo provides a quick tour of the new SQL Server Data Tools. SSDT makes it easy to develop powerful database solutions that target both your on-premise environment and the cloud. Roger Doherty…

This presentation covers application connectivity to AlwaysOn Availability Groups using Availability Group Listeners. Jonathan Kehayias Principal Consultant, SQLskills

This presentation provides an overview of the key improvements in SQL Server 2012 from a developer perspective in the context of Microsoft's overall platform strategy. Roger Doherty Senior Program…

This demonstration uploads an Excel workbook to the SharePoint PowerPivot Gallery library, and then uses it to produce a Power View report. Peter Myers Mentor, SolidQ