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
SQL 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+1 - SQL Server
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)+4 - SQL Server
SQL 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+2 - Cloud proof of concept
Federated 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, with patient-data processing designed to remain within the partner's own cloud environment.
Databricks Delta SharingUnity CatalogAWS S3 / ECS Fargate+2 - Data platform
Databricks Account Usage & Cost Attribution Dashboard
A custom Databricks Lakeview dashboard that converts raw DBU consumption into estimated list-price dollars and splits spend by workspace, user, project, cluster, and feature (Vector Search, Model Serving, Serverless) - so management can investigate usage and attribution.
DatabricksLakeview DashboardsSpark SQL+2 - Personal lab
MariaDB 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)+2 - Experiment
AI 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+1 - Internal tooling
AI 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+2 - Internal tooling
RunPod 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+2 - Personal tool
Password Manager: A Local Vault for My Passwords and Server Details
A personal offline desktop app with encrypted password values 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)+2
