SQL Server 2012

Demo 2 of 4 from the Shawn Bice keynote at SQLConnections

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 Secondary Replicas.  This demo will show how to extend the automated seamless failover capabilities to…

This is a video by Serge Luca (SharePoint MVP), presented at the SharePoint Summit 2012 in Toronto, Canada.

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 Professional, and extends beyond the features available in PowerPivot.  PowerPivot has been…

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 Index using partitioning. Joe Sack Principal Consultant, SQLskills

This video is a demo of a full lifecycle of the BI Semantic Model (BISM) starting with PowerPivot and ending with Power View in SQL Server 2012.

Demo 3 of 4 from the Shawn Bice keynote at SQLConnections  

This session provides an overview of SQL Server deployment options and database types; understanding SQL Server and SharePoint integration, schema overview, database structure, schema restrictions and SharePoint database descriptions. Learn how to efficiently manage multiple instances on one…

Demo 4 of 4 from the Shawn Bice keynote at SQLConnections

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 and reporting. Jonathan Kehayias Principal Consultant, SQLskills