Question: complete the following steps: 1 - Install a new SQL Server instance on your xxxx - DB 1 server called ASSIGNMENT 1 a . [

complete the following steps:
1- Install a new SQL Server instance on your xxxx-DB1 server called ASSIGNMENT1
a.[ASSESSMENT]: Please provide a screenshot showing the successful creation of the instance (SSMS > INSTANCE NAME).
2- Restore the BigPubs2008 backup onto your ASSIGNMENT1 instance
a.[ASSESSMENT]: Please provide a screenshot showing the successful restore of the database (SSMS > INSTANCE NAME > Databases).
3- Using TSQL, add yourself as an employee in the Employee table with the following details:
a. Position: Operations Manager
b. Job Pay (Level): $75K/Year
c. Publisher: Binnet & Hardley
d. Start Date: Todays Date
e.[ASSESSMENT]: Please provide the SQL query you used to perform this task (Query can be saved as .SQL file).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!