Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As IT environments evolve, it is important to understand the need to implement changes to the ensure continued uptime whilst also providing improvements, bug fixes

As IT environments evolve, it is important to understand the need to implement changes to the ensure continued uptime whilst also providing improvements, bug fixes to the user base. This is where the change management process comes into place.Your direct supervisor has come to you to get a production software change done to the production Microsoft SQL database server, this change involves updating a stored procedure and adding an index to the respective tables.This request has come done from key stakeholders in the business as it improves the speed at the data is queried and returned.Additional Details:This Microsoft SQL server contains multiple databases that various applications that is used by the business. This change will only affect one database, however, there is a risk of potential downtime and access restriction to the MS SQL server itself.You task is to come up with a plan to get this change scheduled into the production environment.Key items to consider in your plan:1) Will you need to get approvals for this change? What mechanism will you use?2) Is there a need to have this change tested? If so, who will be responsible for this?3) How will you validate that the change will not impact the other databases or the applications that interact with those databases?4) Will an outage need to be declared, if so, how big of a window will be needed?5) What will be your success criteria?6) What other areas/items should you consider?
7. Give me intoduction in briefly?
8. Plan timeline?
9. Breakdown of tasks?
10. Key milsestones ?
11. Plan notification schedule?
12. In the technical overview, describe the detail break down of the problems?
13. Explaining the software impacts?
14. Explaining the window outage and measuring success?
15. Explanaition backup and recovery requirements?
16. References if have?
17. Breif conclusion?
Please give me stepwise answer of evry question in detail ?

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

Concepts Of Database Management

Authors: Joy L. Starks, Philip J. Pratt, Mary Z. Last

9th Edition

1337093424, 978-1337093422

More Books

Students also viewed these Databases questions

Question

What is the principle of thermodynamics? Explain with examples

Answered: 1 week ago