SQL Server 2012

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

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

This demo shows how to replace code that was based on CTEs and ROW_NUMBER() to provide query pagination in earlier versions of SQL Server, to use the new OFFSET and FETCH clauses provided by SQL Server 2012. 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

In this video, Symon Perriman meets with John Allwright, a Senior Product Marketing Manager in Windows Server & Management, to talk about this week's System Center 2012 Service Pack 1 (SP1) launch.  John first gives an overview of the goals of SP1 and how this launch leads us…

This demo shows you the types of queries that received a significant performance improvement when working with spatial data types in SQL Server 2012. Dr Greg Low SQL Server MVP and Microsoft RD

SQL Server 2012 combines the high performance database blob storage capabilities of FILESTREAM with new SMB file sharing capabilities of FileTable to enable rich support for content as an integrated part of a database application.  Once content is managed by SQL Server, exciting new search…

SQL 2012 offers new levels of performance, availability, BI insight, extensibility and cloud integration. Learn how Microsoft IT is integrating new SQL 2012 capabilities across its application portfolio and the results being achieved. If you're interested in learning more about the products or…

Overview of the Power View feature of SharePoint 2010 SP1. Here is a brief description from : http://social.technet.microsoft.com/wiki/contents/articles/3726.power-view-overview.aspx  Power View, a feature of Microsoft SQL Server 2012 Release Candidate 0 (RC 0) Reporting Services Add-in for…

This video covers the main issues that you face in installing PowerPivot and Power View on SharePoint 2010 SP1. There are many nuances to address such as software needed for the install, configuration options, installation order, etc... This video covers installation using SharePoint 2010…