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 queries over continuous event-stream data that deliver real-time insight.
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 base and matching policy, and then using this matching policy with the MDS Excel add-in.
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 contained users.
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 Availability Group wizards.
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 enables the automated seamless failover capabilities to applications using the Availability Group databases,...
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.