Install SQL Server 2016 Sample Database WideWorldImporters – SQL in Sixty Seconds #081

I have been a very loyal user to sample database AdventureWorks for a while, I really liked the overall database. However, as we know SQL Server releases, new features every year and along with the new features there is always need for a new Sample Database which contains all the necessary data and schema to demonstrate new features of the SQL Server. The SQL Server team has recently released a new sample database WideWorldImporters which can be used to demonstrate new features of the SQL Server.

Install SQL Server 2016 Sample Database WideWorldImporters - SQL in Sixty Seconds #081 81-wideworldimporters-800x450

Personally, I would have preferred that team would have an enhanced AdventureWorks database to accommodate the new features, but I am sure there would be some reason for coming up for entirely new sample database. It will take a while before we can all wrap our head around this sample database.

I have received quite a few requests to write about how to install this new sample database as it is not as simple as installing AdventureWorks due to the new features. I have created a quick video about the same, where I demonstrate how quickly we can install SQL Server 2016 sample database WideWorldImporters.

In this short video we will see how we can install SQL Server 2016 sample database WideWorldImporters.

Here are a few important links:

  1. Download Sample Database and Script from Video
  2. Download SQL Server 2016 Developer Edition for FREE
  3. Install SQL Server 2016 Management Studio

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , , ,
Previous Post
Install SQL Server Management Studio 2016 – SQL in Sixty Seconds #080
Next Post
PostgreSQL – Learn Online in a Single Day – PostgreSQL Learning Path

Related Posts

3 Comments. Leave new

  • R N Pavan Kumar
    August 10, 2016 4:54 pm

    Instead of creating number of repor (.rdl) is there any way to generate the report using dynamic parameter ,data set and fields
    Example : In entry project i will create only one report (table format) , But different store procedure based on dataset , number of columns report should generate

    Reply
  • Error messages:
    Source: mscorlib
    Target Site: Void WinIOError(Int32, System.String)
    Message: Access to the path ‘G:\SQL2012_FILES\MSSQL11.MSSQLSERVER\MSSQL\ReplData\unc\KAUSHIK-PC_DB_REPLICATION_REPLI_PUB\20160810205346\’ is denied.
    Stack: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
    at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity)
    at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity)
    at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory)
    at Microsoft.SqlServer.Replication.Snapshot.SnapshotProvider.CreateSnapshotFolders()
    at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
    at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
    at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: mscorlib, Error number: 0)

    Reply
  • Can we upgrade to SQL Server 2016 now, or should we wait for SP1? We are currently in SQL Server 2008r2.

    Reply

Leave a Reply

Menu