Posts

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 Microsoft RD

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.

Dr Greg Low

SQL Server MVP and Microsoft...

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.

Peter Myers

Mentor,...

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.

Jonathan Kehayias

Principal Consultant, SQLskills

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.

Jonathan Kehayias

Principal Consultant, SQLskills

(http://channel9.msdn.com/posts/SQL11UPD01-REC-022...

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,...

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.

Joe Sack

Principal Consultant, SQLskills

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.

Dr Greg Low

SQL Server MVP and Microsoft RD

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