SQL Server 2012

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…

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…

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

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…

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 ideal for applications or tools that need an embedded database that is API compatible with SQL Server.…