Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

This download contains several sample databases for the SQL Server 2014 Developer Training Kit which showcase many of the new and improved features of SQL Server 2014, including Clustered Columnstore, Online Operations, and Resource Governor IO.

• The purpose of these databases is to help DBAs and Developers become familiar with some of the new and improved features and functionality in SQL Server 2014. The databases included in these downloads focus on three important features of SQL Server 2014; Resource Governor IO, Online Operations, and the Columnstore Index.With the new enhancements to the Columnstore for DW, SQL Server 2014 now delivers both clustered and non-clustered columnstore indexes, and both of these indexes are updateable. These indexes can speed up data warehouse query processing in SQL Server 2014 in many cases by a factof ro 10 to 100. Resource Governor now adds IO governance which provides critical predictible performance. The new online operations greatly increase enterprise application availability by reducing maintenance downtime impact.Microsoft SQL Server 214 builds on the mission-critical capabilities delivered in SQL Server 2012 by providing breakthrough performance, availability, and manageability for mission-critical applications. SQL Server 2014 delivers new capabilities built into the core database for OLTP and data warehousing, which complement our existing OLTP, data warehousing, and BI capabilities for the most comprehensive database solution in the market.SQL Server 2014 takes advantage of new Windows Server 2012 and Windows Server 2012 R2 capabilities to give you unparalleled scalability for your database applications in a physical or virtual environment.

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to August 2020.

File	Size
AdventureWorksDW.exe SHA1: 8aecf93964f962dc37586ab08ae7099b5ee215b5	262.17 MB
ADWorks.exe SHA1: c03a7cac1b3afb40c590b2e810c085bb0af4d22c	53.10 MB
IORGDemo.exe SHA1: 86ad829ecab21d5b4af721b596442621e145ff06	280.93 MB

• Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2012SQL Server 2014 CPT2 or later.

• Download and run the desired executable to install the contenst to a folder of your choice. The default Folder is C:\SQLServer2014SampleDBs. The installed contents is a zip file which contains the necessary SQL Server database backup file (.BAK) file for the appropriate lab. Using SQL Server Managmeent Studio for SQL Server 2014, restore the database backup.