SQL Server 2012

This presentation provides an overview of the key improvements in SQL Server 2012 from a developer perspective in the context of Microsoft's overall platform strategy. Roger Doherty Senior Program Manager, Microsoft

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

SQL Server 2012 Analysis Services introduces an impressive array of improvements designed to expand the reach a broader user base.  SSAS brings together the existing  multi-dimensional model with the new tabular model pioneered by PowerPivot under a single unified platform – the BI…

Join Tim Huckaby, Founder of InterKnowlogy and Actus Interactive Software, and Kimberly Tripp, President/Founder of SQLskills.com, as they discuss why SQL Server and SQL Azure is important to Developers. Kimberly delves into SQL Server indexing as well as the good and bad of GUID. She also provides…

News: [00:20] SQL Server 2008 R2 SP2 is now available! http://aka.ms/SQL2008R2SP2 [00:45] SQL Server 2012 has released its Community Technology Preview (CTP) for SP1 http://aka.ms/SQL2012SP1CTP3 [01:20] An update rollup is now available for System Center 2012 http://aka.ms/SC2012Update2 [02:55]…

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 presentation covers application connectivity to AlwaysOn Availability Groups using Availability Group Listeners. Jonathan Kehayias Principal Consultant, SQLskills

This demo provides a quick tour of the new SQL Server Data Tools. SSDT makes it easy to develop powerful database solutions that target both your on-premise environment and the cloud. Roger Doherty Senior Program Manager, Microsoft

This presentation provides an overview of the new high availabilty and disaster recovery capabilities provided by SQL Server 2012 AlwaysOn, including Availability Groups, partial containment and contained users. Jonathan Kehayias Principal Consultant, SQLskills