The Northwind database has been used for years in application samples, training materials, and 3rd party use cases Using SQL Developers Offline Capture feature, the Microsoft SQL Server Northwind sample database has been extracted into offline data files Tables contain records (rows) with data CREATE DATABASE is aborted USE [master] GO -- Create sql database statement USE [master] GO -- Create While this isn't a common database, this database is the Mondrian Data Loader which pre-loads data for mySQL, Postgress, SQL Server, and Sybase databases. World-Wide Importers. This Microsoft sample database is a more updated version to work with SQL Server (starting with 2016) and Azure. Along with the release of SQL Server 2016 the Wide World Importers sample database was created. Being a modern database it is provided in bacpac format which is fully compatible with Azure SQL. You will however need SQL server management studio to import it. The full guide to running it in Azure can be found on the official documentation The SQL Server 2000 sample database scripts are available as an installation file, SQL2000SampleDb The file is assumed to be saved on C: We'll be working quite a bit in the windows command prompt to enter SQL commands Anyway you can download the script to create this database here Anyway you can download the script to create this database WideWorldImporters is a sample for SQL Server and Azure SQL Database, that replaced AdventureWorks from SQL Server 2016. WideWorldImporters is a wholesale company. WideWorldImporters homepage (GitHub) WideWorldImporters download WideWorldImportersDW Data warehouse equivalent of WideWorldImporters. WideWorldImportersDW homepage (GitHub) sample databases include the AdventureWorks, Northwind, and Pubs databases. To install the Northwind and Pubs sample databases for SQL Server Go to the Northwind and Pubs Sample Databases web site. Download and run the installer. The installer adds a folder SQL Server 2000 Sample Databases to the root folder on your computer. We'll use a standard report for this - using SSMS, right-click on the AdventureWorks2012 database, go to Reports -> Standard Reports -> Disk Usage by Top Tables. Order by Data (KB) by clicking on the column header (you might wish to do this twice for descending order). You will see the report below. Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience.He holds a Masters of Science degree and numerous database certifications. Pinal has authored 13 SQL Server database books and 40 Pluralsight courses. Install SQL Server sample databases msdn microsoft com The Northwind Database works with SQL Server 2005 and 2008 and was originally created for demonstration purposes for Microsoft Access SelectQuery("SELECT * FROM tblBooks WHERE 1"); DBRow dbRow = dbResult Connections to MS Analysis As far as I can determine, this is the first sample database Step #2: Install New SQL Server. Following the previous step, a new window with the SQL Server Installation Center will pop up. We need to click "Installation" (left panel) and then select "New SQL Server stand-alone installation or add features to existing installation" (right panel). Sql Server Sample Database Northwind Output Logs for Successful Migration of Northwind Written this DB for Sql Server 2000 Explore our samples and discover the things you can build We'll be working quite a bit in the windows comman