Projects
Tools and automation I have built for database operations, data platforms, and AI-assisted engineering. Each project covers the problem, the architecture, and the lessons learned.
Index
10 projects
SQL Server Health Check Toolkit
A collection of T-SQL and PowerShell scripts that check CPU, memory, wait statistics, blocking, backups, and Availability Group health on SQL Server instances.
T-SQLPowerShellDynamic Management Views (DMVs)+4Password Manager: A Local Vault for My Passwords and Server Details
An offline, encrypted desktop app for storing passwords and internal server details side by side - and linking the two together, so I never have to remember which credential goes with which box.
ElectronReactNode.js Crypto (AES-256-GCM, PBKDF2)+2MariaDB Studio: A Personal SSMS-Style Tool for MariaDB
A self-built web app that replaces a folder of ad-hoc backup/restore scripts and commands with a single SSMS-like interface for MariaDB - logical/physical backups, point-in-time recovery, replication monitoring, and a query editor.
Python / FlaskPyMySQLParamiko (SSH)+2Federated Clinical Data Sharing with Databricks Delta Sharing
A proof-of-concept federated data architecture that lets healthcare and pharma partners query curated clinical trial reference data via Databricks Delta Sharing, without any regulated patient data ever leaving the partner's own cloud environment.
Databricks Delta SharingUnity CatalogAWS S3 / ECS Fargate+2SQL Backup Validation Automation
Automation that validates SQL Server backup reliability - not just that a backup file exists, but that it can actually be restored - and reports on the results.
T-SQLPowerShellSQL Agent+2SQL Server Migration Toolkit
Scripts that automate migrating SQL Server logins, jobs, credentials, certificates, and database configuration between instances during upgrades and cloud migrations.
T-SQLPowerShellSQL Server Configuration+1AI DBA Assistant
An experimental AI-powered assistant that reads SQL Server health data and suggests troubleshooting directions, built to explore how AI-assisted engineering fits into day-to-day DBA work.
PythonGitHub CopilotClaude Models+1RunPod GPU Pod Dashboard: Start/Stop Buttons for On-Demand Dev GPUs
A one-page dashboard that turns a handful of RunPod API calls and SSH commands into two buttons - Start and Stop - so spinning up a GPU box for a developer doesn't need a manual runbook every time.
Python (stdlib only)http.server + Server-Sent EventsRunPod GraphQL API+2AI Coding Assistant Rollout & Governance
Administering GitHub Copilot and Claude for Teams across an organization - license tiers, model selection policy, custom instructions/skills, connector (MCP) enablement, and AI credit/cost governance.
GitHub CopilotClaude for TeamsMCP+2Databricks Account Usage & Cost Attribution Dashboard
A custom Databricks Lakeview dashboard that converts raw DBU consumption into real dollars and splits spend by workspace, user, project, cluster, and feature (Vector Search, Model Serving, Serverless) - so management can see exactly who and what is driving the bill.
DatabricksLakeview DashboardsSpark SQL+2
