Servers

    SQL Server 2014 Developer Training Kit Sample Databases

    Language:
    English
    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.
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      1.0.0

      File Name:

      AdventureWorksDW.exe

      ADWorks.exe

      IORGDemo.exe

      Date Published:

      2/5/2014

      File Size:

      262.2 MB

      53.2 MB

      281.0 MB

        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.
    • Supported Operating System

      Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2012

        Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2012 SQL 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.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial