]]>https://channel9.msdn.com/posts/SQL11UPD02-REC-02This 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 544https://channel9.msdn.com/posts/SQL11UPD02-REC-02
Thu, 08 Mar 2012 17:14:17 GMThttps://channel9.msdn.com/posts/SQL11UPD02-REC-02Aaron LowerAaron Lower1https://channel9.msdn.com/posts/SQL11UPD02-REC-02/rssSQLSQL ServerSQL Server 2012Demo: Maximizing Hardware Utilization with SQL Server 2012 AlwaysOn Active Secondary ReplicasThis 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 Read Only applications using the Availability Group Listeners Read Only Routing capabilities.

Jonathan Kehayias

Principal Consultant, SQLskills

]]>https://channel9.msdn.com/posts/SQL11UPD01-REC-06This 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 Read Only applications using the Availability Group Listeners Read Only Routing capabilities. Jonathan Kehayias Principal Consultant, SQLskills 360https://channel9.msdn.com/posts/SQL11UPD01-REC-06
Thu, 08 Mar 2012 17:14:01 GMThttps://channel9.msdn.com/posts/SQL11UPD01-REC-06Aaron LowerAaron Lower1https://channel9.msdn.com/posts/SQL11UPD01-REC-06/rssSQLSQL ServerAlwaysOnSQL Server 2012Presentation: Introducing SQL Server 2012 AlwaysOn Readable Secondary ReplicasThis 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.

]]>https://channel9.msdn.com/posts/SQL11UPD02-REC-03SQL 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 414https://channel9.msdn.com/posts/SQL11UPD02-REC-03
Thu, 08 Mar 2012 17:13:31 GMThttps://channel9.msdn.com/posts/SQL11UPD02-REC-03Aaron LowerAaron Lower2https://channel9.msdn.com/posts/SQL11UPD02-REC-03/rssSQLSQL ServerSQL Server 2012Demo: Table Partitioning in SQL Server 2012This 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

]]>https://channel9.msdn.com/posts/SQL11UPD02-REC-04This 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 439https://channel9.msdn.com/posts/SQL11UPD02-REC-04
Thu, 08 Mar 2012 17:13:15 GMThttps://channel9.msdn.com/posts/SQL11UPD02-REC-04Aaron LowerAaron Lower1https://channel9.msdn.com/posts/SQL11UPD02-REC-04/rssSQLSQL ServerSQL Server 2012Presentation: Introducing SQL Server 2012 Security and Auditing ImprovementsIn 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

]]>https://channel9.msdn.com/posts/SQL11UPD02-REC-05In 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 660https://channel9.msdn.com/posts/SQL11UPD02-REC-05
Thu, 08 Mar 2012 17:12:58 GMThttps://channel9.msdn.com/posts/SQL11UPD02-REC-05Aaron LowerAaron Lower1https://channel9.msdn.com/posts/SQL11UPD02-REC-05/rssSQLSQL ServerSQL Server 2012Demo: Customizing Server Roles in SQL Server 2012This 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 catalog views.

Joe Sack

Principal Consultant, SQLskills

]]>https://channel9.msdn.com/posts/SQL11UPD02-REC-06This 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 catalog views. Joe Sack Principal Consultant, SQLskills 209https://channel9.msdn.com/posts/SQL11UPD02-REC-06
Thu, 08 Mar 2012 17:12:21 GMThttps://channel9.msdn.com/posts/SQL11UPD02-REC-06Aaron LowerAaron Lower1https://channel9.msdn.com/posts/SQL11UPD02-REC-06/rssSQLSQL ServerTSQLSQL Server 2012Demo: SQL Server 2012 Extended Events EnhancementsThis demonstration shows how to use the new Extended Events wizards and interfaces in SQL Server Management Studio.

]]>https://channel9.msdn.com/posts/SQL11UPD03-REC-03Developers who exploit spatial data types in their applications will find some helpful improvements in SQL Server 2012, including support for new shapes and methods, full globe support and spatial index enhancements. Dr Greg Low SQL Server MVP and Microsoft RD 724https://channel9.msdn.com/posts/SQL11UPD03-REC-03
Thu, 08 Mar 2012 17:11:13 GMThttps://channel9.msdn.com/posts/SQL11UPD03-REC-03Aaron LowerAaron Lower2https://channel9.msdn.com/posts/SQL11UPD03-REC-03/rssSQLSQL ServerSQL Server 2012Demo: Declarative Database Development with SQL Server Data ToolsThis 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 database project based upon an existing database, make changes to it, and test it locally using the integrated Local Database Runtime (LocalDb).

Dr Greg Low

SQL Server MVP and Microsoft RD

]]>https://channel9.msdn.com/posts/SQL11UPD04-REC-02This 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 database project based upon an existing database, make changes to it, and test it locally using the integrated Local Database Runtime (LocalDb). Dr Greg Low SQL Server MVP and Microsoft RD 344https://channel9.msdn.com/posts/SQL11UPD04-REC-02
Thu, 08 Mar 2012 17:10:57 GMThttps://channel9.msdn.com/posts/SQL11UPD04-REC-02Aaron LowerAaron Lower2https://channel9.msdn.com/posts/SQL11UPD04-REC-02/rssDatadata toolsSQLSQL ServerSQL Server Management StudioSQL Server 2012Presentation: What's New in .NET 4.0 and SQL Server 2012This presentation covers new features that impact SQL Server developers in .NET 4.0.