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:

    02/05/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 Systems:

    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

    • 01

      Microsoft® SQL Server® 2012 Express

      Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

    • 03

      Microsoft® SQL Server® 2008 Management Studio Express

      Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

    • 04

      Microsoft® SQL Server® 2014 Express

      Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

    • 05

      Microsoft Power Query for Excel

      Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

Loading your results, please wait...

Free PC updates

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