$1.$ In a new SQL Server $2019$ instance on either an existing Windows Server image or a new one. Choose appropriate service accounts, enable remote SQL TCP connections, and ensure that all SQL necessary SQL Server services are set to start automatically and accept secure network connections.

$1.$ Design a database that will be used to store information for an IT Consulting Company that provides services for client organizations as well as purchases and resells equipment $($servers$,$ desktops, software, routers, etc.$)$ to clients. Ensure that you diagram the tables, columns$/$datatypes$,$ and table relationships.

$1.$ Create the database and tables from the previous step as well as populate the tables with at least $50$ records $($you can use a bulk import process to save time$).$ Also ensure that the tables have the appropriate indexes and that the database has appropriate database options.

$1.$ Create a SQL login and user that can be used to access and modify records within the database, as well as a separate SQL login that can only read records within the database. Also create a login for the app developer within your organization. Use appropriate names for each one.

$1.$ Ensure that you can isolate performance problems when they occur, as well as monitor ongoing SQL performance and usage. Optimize the performance of your database by performing the appropriate tasks. Ensure that your database is regularly checked for inconsistencies and backed up$.$ Any problems should be emailed to your trioscollege.com email address.

$1.$ Provide suitable fault tolerance for your database.

$1.$ For steps $1-6,$ document what you did to achieve each step $($point$-$form under each step within this document, with appropriate screenshots or code output to illustrate your choices$).$ Hint: You can reuse parts of the code used to mark your SQL$16$A final project!

$1.$ Send me a copy of this document as well as a FULL backup of your database for marking $($either via email or MS Team chat$).$

$1.$ Optional bonus: Design a new database that will be used as a data warehouse for your IT Consulting Company database. Identify which information from your database is most valuable for business intelligence analysis. Next, define your dimensions for the data warehouse as well as the data points to store in the fact table. Finally, select the columns to include in each dimension table, and optionally implement your desig