# DBAOps Ultimate v2.4.0

## Enterprise SQL Server Infrastructure Management Platform

**Author:** JB Gakumba - Sr SQL DBA / DBAOps Architect  
**Package Created:** 2026-01-29

---

## Quick Start Installation

### Prerequisites
- Windows Server 2016 or higher
- SQL Server 2016 or higher (for central repository)
- PowerShell 5.1 or higher
- dbatools PowerShell module

### Installation Steps

1. **Extract Package**
   ```
   Extract to your desired location (e.g., E:\DBAOps_Package)
   ```

2. **Install dbatools** (if not already installed)
   ```powershell
   Install-Module dbatools -Force
   ```

3. **Run Installation Script**
   ```powershell
   .\Install-DBAOpsUltimate.ps1 -CentralServer "YOUR_SERVER" -CreateDatabase
   ```

4. **Deploy Database Schema**
   ```powershell
   # Run these in order on your central SQL Server
   sqlcmd -S YOUR_SERVER -d DBAOpsRepository -i "Schema\01_CreateSchema.sql"
   sqlcmd -S YOUR_SERVER -d DBAOpsRepository -i "Schema\02_CreateViews.sql"
   sqlcmd -S YOUR_SERVER -d DBAOpsRepository -i "Schema\03_CreateProcedures.sql"
   ```

5. **Configure Your Environment**
   - Edit Config\DBAOps.config.template.json with your settings
   - Rename to DBAOps.config.json
   - Update server names in PowerShell modules

6. **Add Your Servers**
   ```sql
   INSERT INTO config.ServerInventory (ServerName, Environment, IsActive, IsSQLServer)
   VALUES ('SERVER1', 'PROD', 1, 1), ('SERVER2', 'DEV', 1, 1);
   ```

7. **Test Installation**
   ```powershell
   . E:\DBAOps\PowerShell\Import-DBAOpsModules.ps1
   Get-OnCallDBA
   ```

---

## Package Contents

| Folder | Description |
|--------|-------------|
| PowerShell | PowerShell modules and scripts |
| WebDashboard | Web-based dashboard files |
| Schema | Database creation scripts |
| Config | Configuration templates |
| Documentation | This documentation |

---

## Support

For issues or questions, contact your DBA team.

---

*DBAOps Ultimate - Simplifying SQL Server Management*
