SQL Server Database Expert lab 2
A learner provisions an isolated sql server database environment and completes a guided operational task.
Business context
Ultiblob uses this exercise to train database administrator and data platform engineer candidates on realistic private-cloud lab operations rather than static videos.
Technical objective
Configure the core sql server database services, verify health, and record the result in the lab progress view.
Student instructions
- 1Open the lab workspace and review the topology map.
- 2Launch the required templates and wait for all provisioning checks to complete.
- 3Complete the configuration task in the course module.
- 4Run validation and capture the result for instructor review.
- 5Create a snapshot before any risky troubleshooting or failure exercise.
Troubleshooting
- If access fails, confirm the bastion session is active and the instance is not expired.
- If validation fails, inspect the lab event log before rerunning the check.
- If configuration drifts, restore the latest clean snapshot and repeat the module task.
Cleanup
- Export notes or reports required by the instructor.
- Restore or delete temporary snapshots created during the exercise.
- Use the teardown action when the module is complete or allow the TTL policy to expire the lab.
Provisioning readiness
Click Launch lab to start the provisioning flow and watch each stage complete.
- Request accepted
- Capacity reserved
- Templates queued
- Validation running
- Workspace ready
Required templates
- Windows Server 2022 base - defined
- SQL Server template - defined
- Windows Admin Center template - defined
Validation checks
- VM reachable: The VM reports boot complete and responds through the tenant bastion path.
- SQL reachable: The SQL endpoint accepts a least-privilege validation login.
- Snapshot created: A named checkpoint exists before the exercise stage.
- Rollback tested: The instance returns to the expected baseline state.
Expected result
The lab reaches Healthy state for VM reachable, SQL reachable, Snapshot created, Rollback tested.
Reset policy: Student can reset to the last clean snapshot; instructor can force reset from admin view. Teardown policy: Automatic teardown at TTL expiry with manual instructor override for cohorts.