01 · Starting point
Situation
An Oracle-oriented administration team needed support with SQL Server 2008, particularly with fault analysis, configuration and performance on production systems.
Constraints
- Changes within an already established IT environment
- Short, clearly scoped engagement
- Internal system and operating details remain confidential
02 · Responsibility
My scope of responsibility
I handled incidents on live systems, supported the database administrators and documented practical guidance for working more efficiently with SQL Server.
- I analysed and fixed SQL Server issues on production systems.
- I supported database configuration and performance optimisation.
03 · Technical work
Documented scope of work
Key decisions
Deliver support in the terminology and operating habits of the existing Oracle team. Technical knowledge transfers faster when differences and similarities between the platforms are made explicit.
- I created practical tips and work instructions for the administration team.
04 · Technical context
Technology in use
SQL Server 2008
SQL Server 2008 was part of the documented toolset in this Data & Automation engagement.
Oracle
Oracle was part of the documented toolset in this Data & Automation engagement.
Performance Tuning
Performance Tuning was part of the documented toolset in this Data & Automation engagement.
Production Support
Production Support was part of the documented toolset in this Data & Automation engagement.
05 · Factual basis
Evidence and limits
The team received direct support for more stable SQL Server operations and a documented knowledge base.
- Role
- Database Administrator
- Period
- January 2012 — February 2012
Lesson from the engagement
Cross-platform support works best when it builds on existing knowledge instead of explaining a second administration world in isolation.
Confidentiality note: Internal architecture and operating data of this engagement are not published.