Time for action – Creating the OrderingSystem database
In this first exercise, we want to create a brand new SQL Server database.
- Open SQL Server Management Studio (SSMS) and log in to your SQL Server Express.
- In the Connect to Server dialog, choose Database Engine as Server type. We are accessing the locally installed database server, thus enter either .\SQLExpress or (local)\SQLEXPRESS as Server name. Finally, select Windows Authentication as the Authentication method and click on Connect, as shown in the preceding screenshot.
- You will be presented with a screen similar to the following screenshot. This shows a basic summary of the SQL Server instance ...