SplatDev.Database.MSSQLAdmin 1.0.2

SplatDev.Database.MSSQLAdmin

MSSQL database administration utilities for .NET, extending SplatDev.Database. Provides index maintenance, integrity checks, and size monitoring via Microsoft.Data.SqlClient.

Compatibility

Installation

dotnet add package SplatDev.Database.MSSQLAdmin

Configuration

Add to appsettings.json:

{
  "MSSQLAdmin": {
    "ConnectionString": "Server=localhost;Database=MyDb;Trusted_Connection=true;TrustServerCertificate=true",
    "IndexMaintenanceEnabled": true,
    "IntegrityChecksEnabled": true,
    "SizeMonitoringEnabled": true,
    "RebuildThresholdPercent": 30.0,
    "ReorganizeThresholdPercent": 10.0
  }
}

Registration

builder.Services.AddSplatDevMssqlAdmin(options =>
{
    options.ConnectionString = builder.Configuration["MSSQLAdmin:ConnectionString"] ?? "";
    options.RebuildThresholdPercent = 30.0f;
    options.ReorganizeThresholdPercent = 10.0f;
});

Usage

public class DatabaseMaintenanceJob(
    MssqlAdminService mssqlAdmin,
    ILogger<DatabaseMaintenanceJob> logger)
{
    public async Task RunAsync()
    {
        // 1. Index maintenance
        var indexResult = await mssqlAdmin.MaintainIndexesAsync();
        logger.LogInformation("Rebuilt {Rebuilt}, Reorganized {Reorganized}",
            indexResult.RebuiltCount, indexResult.ReorganizedCount);

        // 2. Integrity check
        var integrity = await mssqlAdmin.CheckDatabaseIntegrityAsync();
        if (!integrity.AllChecksPassed)
            logger.LogWarning("DBCC CHECKDB found {Count} errors", integrity.ErrorCount);

        // 3. Size monitoring
        var size = await mssqlAdmin.GetDatabaseSizeInfoAsync();
        logger.LogInformation("DB size: {Total} across {Count} tables",
            size.TotalSizeFormatted, size.TableSizes.Count);
    }
}

API

Index Maintenance

Integrity Checks

Size Monitoring

Dependencies

SplatDev.Database.MSSQLAdmin — part of the SplatDev.Umbraco.Plugins suite. Licensed under MIT. © SplatDev Ltda.

Changelog

1.0.2 — 2026-08-24

Removes a dashboard screenshot that showed an error toast. It was captured against a site where this plugin's API was unreachable, so it advertised a broken dashboard. No screenshot is better than a misleading one; a replacement will be taken against a working install.

1.0.1 — 2026-08-24

Package metadata only: the listing now carries an icon and search tags, and the project and repository links point at the organisation that actually hosts this code. No code changes.

1.0.0 — 2026-08-24

This package now keeps a changelog. Earlier releases predate it and are not reconstructed here — consult the repository history for those. From this version on, every release records what changed for someone using it.