# JBRhoylle DBA Suite v2.4.0
# Customer Installation Quick Start Guide

---

## BEFORE YOU BEGIN

### You Should Have Received:
- [ ] DBAOps_Ultimate_v2.4.0_XXXXXXXX.zip (Installation package)
- [ ] license.json (Your license file)

### Requirements:
- Windows Server 2016+ with SQL Server 2016+
- PowerShell 5.1+
- Network access to all SQL Servers you want to monitor
- Windows Authentication (domain)

---

## INSTALLATION STEPS (30-45 minutes)

### Step 1: Prepare Server (5 min)

```powershell
# Run as Administrator on your central server

# Install IIS for web dashboard
Install-WindowsFeature -Name Web-Server -IncludeManagementTools

# Install dbatools PowerShell module
Install-Module dbatools -Force
Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true -Register

# Create installation folder
New-Item -ItemType Directory -Path "E:\DBAOps" -Force
```

### Step 2: Extract Files (2 min)

```powershell
# Extract the ZIP file
Expand-Archive -Path "C:\Temp\DBAOps_Ultimate_v2.4.0_*.zip" -DestinationPath "E:\DBAOps" -Force

# Copy your license file
Copy-Item "C:\Temp\license.json" "E:\DBAOps\Config\" -Force

# Verify
Get-ChildItem "E:\DBAOps"
```

### Step 3: Run Installer (10 min)

```powershell
# Run the installer
cd E:\DBAOps\Installer
.\Install-DBAOpsUltimate.ps1 -CentralServer "localhost" -CreateDatabase

# Follow the prompts
```

### Step 4: Add Your Servers (10 min)

```powershell
# Add each SQL Server to monitor
# Replace SERVER01, SERVER02 with your actual server names

Add-DbaRegServer -SqlInstance localhost -ServerName "SERVER01" -Group "Production"
Add-DbaRegServer -SqlInstance localhost -ServerName "SERVER02" -Group "Production"
Add-DbaRegServer -SqlInstance localhost -ServerName "DEVSERVER01" -Group "Development"

# Add to DBAOps inventory
Invoke-DbaQuery -SqlInstance localhost -Database JBRhoylleRepository -Query @"
INSERT INTO config.ServerInventory (ServerName, Environment, IsActive, IsSQLServer) VALUES
('SERVER01', 'PROD', 1, 1),
('SERVER02', 'PROD', 1, 1),
('DEVSERVER01', 'DEV', 1, 1)
"@
```

### Step 5: Configure Dashboard (5 min)

```powershell
# Create IIS website
Import-Module WebAdministration
New-Website -Name "DBAOpsDashboard" -Port 80 -PhysicalPath "E:\DBAOps\WebDashboard"

# Refresh dashboard data
& E:\DBAOps\PowerShell\Update-JBRhoylleDashboard.ps1

# Open in browser
Start-Process "http://localhost/"
```

### Step 6: Set Up On-Call (2 min)

```powershell
# Add your DBA team
Invoke-DbaQuery -SqlInstance localhost -Database JBRhoylleRepository -Query @"
INSERT INTO config.OnCallRotation 
(PrimaryDBA, PrimaryPhone, PrimaryEmail, BackupDBA, RotationStartDate, RotationEndDate, IsActive)
VALUES 
('Your Name', '+1234567890', 'your.email@dbaopsframework.com', 'Backup DBA', GETDATE(), DATEADD(DAY, 7, GETDATE()), 1)
"@
```

### Step 7: Verify Installation (5 min)

```powershell
# Load modules
. E:\DBAOps\PowerShell\Import-JBRhoylleModules.ps1

# Test commands
Get-OnCallDBA
Get-PredictiveAnalyticsSummary

# Open dashboard
Start-Process "http://dbaopsdash/"
```

---

## SET UP DBA WORKSTATIONS

Run this on each DBA's laptop:

```powershell
# Create folder and copy files
New-Item -ItemType Directory -Path "C:\DBAOps\PowerShell" -Force
Copy-Item "\\YOURSERVER\E$\DBAOps\PowerShell\*" "C:\DBAOps\PowerShell\" -Recurse -Force

# Install dbatools
Install-Module dbatools -Force -Scope CurrentUser
Set-DbatoolsConfig -FullName sql.connection.trustcert -Value $true -Register

# Test
. C:\DBAOps\PowerShell\Import-JBRhoylleModules.ps1
Get-OnCallDBA
```

---

## DAILY OPERATIONS

### Morning Health Check
```powershell
. C:\DBAOps\PowerShell\Import-JBRhoylleModules.ps1
Get-OnCallDBA
Get-PredictiveAnalyticsSummary
```

### Or Use Dashboard
Open: **http://dbaopsdash/**

---

## QUICK REFERENCE

| Task | Command |
|------|---------|
| Load modules | `. C:\DBAOps\PowerShell\Import-JBRhoylleModules.ps1` |
| Who's on call | `Get-OnCallDBA` |
| Health check | `Get-PredictiveAnalyticsSummary` |
| Capacity forecast | `Get-CapacityForecast` |
| Refresh dashboard | `& E:\DBAOps\PowerShell\Update-JBRhoylleDashboard.ps1` |

---

## NEED HELP?

**Support Email:** dbaops-support@dbaopsframework.com
**Documentation:** See User_Guide.pdf in the installation package

---

## LICENSE INFORMATION

Your license details are stored in: `E:\DBAOps\Config\license.json`

To view:
```powershell
Get-Content "E:\DBAOps\Config\license.json" | ConvertFrom-Json | Select-Object -ExpandProperty License
```

---

*JBRhoylle DBA Suite v2.4.0*
*Thank you for your purchase!*
