Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You work as a database administrator for a software company, Human Scale LLC, which markets hosted software applications that support human resource management. The application

You work as a database administrator for a software company, Human Scale LLC, which markets hosted software applications that support human resource management. The application database resides on a SQL Server 2012 instance, and for security reasons the company has chosen to install a separate instance of SQL Server for each client. When you joined the company, you noticed that they used the installation wizard for all new installations. This was sustainable for a while but now the company is taking on many new clients each week. Additionally, you have noticed several differences in the configuration parameters between instances, even though each instance should be based on standardized configuration settings. You have decided to raise your concerns to the chief technology officer (CTO). Complete the following:

1. Explain why you believe an unattended installation using the command prompt and a configuration file will improve the installation process efficiency and consistency when deploying new instances of SQL Server 2012.

2.The CTO is concerned that there may be other inconsistencies between the different instances of SQL Server 2012. Based on the knowledge that you have gained from Chapter 2, describe how you could check the configuration parameter values that were used for any given installation.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL For Data Science Data Cleaning Wrangling And Analytics With Relational Databases

Authors: Antonio Badia

1st Edition

3030575918, 978-3030575915

More Books

Students also viewed these Databases questions