Making changes to your enterprise database environment without considering best practices can:
Lead to extended downtime.
Result in decreased ROI.
Produce more project dead ends and increased operational costs.
Planning your implementation up front will help:
Improve database performance and unlock new features.
Transition smoothly to the new environment.
Communicate the project’s business value to stakeholders.
Module 1: Identify Opportunities and Challenges
The Purpose
Review the project rationale and identify project value add.
Identify challenges to overcome and opportunities to improve.
Key Benefits Achieved
Create an inventory of your current database environment.
Activities:
Outputs:
1.1
Identify pain points in the current system.
1.2
Identify project drivers, risks, and expected outcomes.
Identify project value proposition
1.3
Identify stakeholders, SMEs, and roles and responsibilities.
Complete the project opportunity assessment
1.4
Establish project parameters and deliverables and collect system data.
Create an inventory identifying system interdependencies
1.5
Identify new features in SQL Server that can provide business value.
Module 2: Plan the Optimization Project
The Purpose
Develop a project plan to guide implementation.
Key Benefits Achieved
Develop project scope and get sign-off.
Activities:
Outputs:
2.1
Review key factors for your platform, such as security and availability, to identify the optimal path for modifications.
Document prioritized criteria to guide any modifications to your environment
2.2
Identify the paths to optimization that can help you meet business goals.
Complete the opportunity assessment and identify initial steps on the project checklist
2.3
Identify servers to upgrade, performance tune, and consolidate.
Complete the TCO budget tool
Module 3: Test, Execute, Stabilize, and Debrief
The Purpose
Establish a plan to execute and test modifications to your environment.
Communicate project successes to stakeholders.
Key Benefits Achieved
Ensure your plan to modify your SQL Server environment will minimize disruption to business processes.
Build a roadmap for next steps to streamline future projects.
Activities:
Outputs:
3.1
Create a step-by-step plan for modifications with your SMEs.
Complete the execution checklist
3.2
Identify steps for roll back and backup to deal with unexpected complications.
Complete the roll back checklist
3.3
Review your project plans with stakeholders.
Review the executive presentation
3.4
Discuss and document lessons learned.
Update the issue resolution template
Book Your Workshop
Onsite Workshops offer an easy way to accelerate your project. If you are unable to do the project yourself, and a Guided Implementation isn’t enough, we offer low-cost onsite delivery of our Project Workshops. We take you through every phase of your project and ensure that you have a road map in place to complete your project successfully.
Book Your Workshop