Posts

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

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

SQL Server 2012 introduces several Transact-SQL improvements that impact developer productivity and support for key standards, including easier query results pagination and sequence generators.

Dr Greg Low

SQL Server MVP and Microsoft RD

Developers 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

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

This presentation covers new features that impact SQL Server developers in .NET 4.0.

Dr Greg Low

SQL Server MVP and Microsoft RD