SQL Server 2012

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 catalog, package execution and viewing the built-in reports. Peter Myers Mentor, SolidQ

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

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…

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

An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary databases and one to four sets of corresponding secondary databases. An availability group fails over…

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 new tabular model pioneered by PowerPivot under a single unified platform – the BI…

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

Get ready to understand model and Tempdb database settings, database file placement, and how to determine the number of content databases. This module goes over how to modify model database to reflect configuration of new databases and configure Tempdb for improved performance, and much more.…

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 change the role name.  Along the way we'll validate the changes we've made using security…

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…