SQL

Columnstore indexes provide an easy way to significantly improve data warehouse and decision support query performance against very large data sets. Joe Sack Principal Consultant, SQLskills

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

SQL Server 2012 offers several important improvements that related to table partitioning, including more partitions per table, improved online operations, better index build performance and new wizards. Joe Sack Principal Consultant, SQLskills

This demo shows how to use the enhanced Partition Wizard to switch out and switch in a partition.  We'll demonstrate this enhanced UI against a table with more than 1,000 partitions (by example demonstrating this new capability as well). Joe Sack Principal Consultant, SQLskills

In this presentation we'll cover SQL Server 2012 improvements that impact security and auditing, including new support for default schema for groups, user-defined server roles and various auditing improvements. Joe Sack Principal Consultant, SQLskills

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 use the new Extended Events wizards and interfaces in SQL Server Management Studio. Jonathan Kehayias Principal Consultant, SQLskills

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