SQL

Microsoft IT improved the user experience and increased productivity by streamlining the migration from previous Windows operating systems to Windows 8 Beta. The solution leveraged a polished Modern UI featuring Windows 8 client/server technologies, USMT 5.0, Microsoft Deployment Toolkit, SQL…

At [04:50] Symon Perriman meets with Joseph Chan, a Principal PM Manager on the System Center team, to talk about System Center Advisor and how it now integrates with System Center 2012. Joseph first gives an introduction to Advisor and how people can start using this free cloud service.…

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

Module 1 provides an understanding of the two major components of a database system. The database constitutes the files that store data, and the instance is the collection of server resources that provide a powerful, high performance interface to the data. It also illustrates how the two interact to…

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

This demonstration creates a new model and then uses the Master Data Services (MDS) Add-in for Excel to create and load two entities. Then in the Master Data Manager web application, the loaded members are explored. A new member is added, and an existing member is updated. Finally, a subscription…

SQL Server 2012 Integration Services introduces a host of new improvements of interest to developers and IT Professionals alike.  Developers will appreciate a greatly improved package design experience, and IT Professionals will find a powerful new set of tools and services that will greatly…

This demonstration explores the new features of SQL Server 2012 Integration Services (SSIS). Specifically it covers project conversion, parameters, project connection managers, deployment to the SSIS catalog, package execution and viewing the built-in reports. Peter Myers Mentor, SolidQ

SQL Server 2012 Express Edition introduces a new deployment option called Local Database Runtime. LocalDb is a small shared component (not a service) that installs in five minutes or less that is ideal for applications or tools that need an embedded database that is API compatible with SQL Server.…

SQL Server 2012 Master Data Services is a set of tools and services that can be used to integrate disparate information systems that share common data sets into a common master data management solution.  This new release offers several key improvements centered around usability, robustness,…