SQL Server 2012 | Tags

28 minutes, 19 seconds

Edge Show 17 - Configuring Service Delivery and Automation for the Private Cloud with System Center…

Edge Mar 16, 2012 at 8:00 AM

0

(1)

News: Symon Perriman and David Tesar covered the following: Download the new product releases for Windows Server 8 Beta & SQL Server 2012 RTM Sign up for the Private Cloud Jump Start on April 3 & 4. The last one sold out, so register today: http://aka.ms/PCJS Learn more about these upcoming…

13 minutes, 38 seconds

Presentation: Introducing SQL Server 2012 AlwaysOn Failover Clustering

Mar 08, 2012 at 9:15 AM

1

This presentation provides an overview of failover clustering imporvements introduced in SQL Server 2012 AlwaysOn. Jonathan Kehayias Principal Consultant, SQLskills

3 minutes, 56 seconds

Demo: Configuring SQL Server 2012 AlwaysOn Failover Clustering

Mar 08, 2012 at 9:14 AM

1

This demonstration shows how to configure the flexible failover policy for SQL Server 2012 AlwaysOn Failover Clustering. Jonathan Kehayias Principal Consultant, SQLskills

22 minutes, 12 seconds

Presentation: Introducing SQL Server 2012 Columnstore Indexes

Mar 08, 2012 at 9:14 AM

1

(2)

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

9 minutes, 4 seconds

Demo: Accelerating Data Warehouse Queries with SQL Server 2012 Columnstore Indexes

Mar 08, 2012 at 9:14 AM

1

(1)

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

6 minutes, 0 seconds

Demo: Maximizing Hardware Utilization with SQL Server 2012 AlwaysOn Active Secondary Replicas

Mar 08, 2012 at 9:14 AM

1

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…

11 minutes, 31 seconds

Presentation: Introducing SQL Server 2012 AlwaysOn Readable Secondary Replicas

Mar 08, 2012 at 9:13 AM

1

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

6 minutes, 54 seconds

Presentation: Introducing SQL Server 2012 Table Partitioning Improvements

Mar 08, 2012 at 9:13 AM

2

(1)

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

7 minutes, 19 seconds

Demo: Table Partitioning in SQL Server 2012

Mar 08, 2012 at 9:13 AM

1

(1)

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

11 minutes, 0 seconds

Presentation: Introducing SQL Server 2012 Security and Auditing Improvements

Mar 08, 2012 at 9:12 AM

1

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