SQL Server 2012

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 session provides an overview of SQL Server deployment options and database types; understanding SQL Server and SharePoint integration, schema overview, database structure, schema restrictions and SharePoint database descriptions. Learn how to efficiently manage multiple instances on one…

How to create modern BI solutions using Microsoft SharePoint 2013, PowerPivot and Power View in Excel 2013.

Get ready to understand model and Tempdb database settings, database file placement, and how to determine the number of content databases. This module goes over how to modify model database to reflect configuration of new databases and configure Tempdb for improved performance, and much more.…

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

Demo 1 of 4 from the Shawn Bice keynote at SQLConnections

In this segment you will learn how to modify memory settings to control memory usage by SQL Server, how to change default file locations, how to leave MAXDOP at 1 for SharePoint and how to verify operating system set to 64KB allocation unit size. Get ready for some great demos and rich dialogue.…

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…

Demo 2 of 4 from the Shawn Bice keynote at SQLConnections

This module will show you how to avoid ginormous T-Logs by performing regular T-Log backups, how to have multiple copies of your backups, how to configure AlwaysOn for high availability and verify integrity of SQL Server databases. Lastly the instructors will cover SQL Server for SharePoint best…