Setting up our database

In this section, we will set up our database and get our project ready for benchmarking. We will be benchmarking different methods of inserting, updating, selecting, and deleting data. Let's start with setting up our database:

1. Visit https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs.
2. Download the instnwnd.sql file.
3. Once the file has been downloaded, open it in SQL Server Management Studio.
4. Execute the file. This will install the database.
5. Open a new query window and enter the following SQL code:

   USE [Northwind]
   GO
   SET ANSI_NULLS ON
   GO
   SET QUOTED_IDENTIFIER ON
   GO
   CREATE PROCEDURE [dbo].[InsertProduct] 
       @ProductName NVARCHAR(40),
       @CategoryID INT,
       @SupplierID INT,
       @Discontinued BIT
   AS
   BEGIN
   SET NOCOUNT ON;
   INSERT INTO 
           Products (
       ...