I build SQL Server reports, queries, and data jobs, and I make slow ones faster.

I've worked in IT for more than 35 years, most of it close to the data. I take part-time and project work, and I do the work myself.

Get in touch

What I do

Development and reporting

T-SQL views, scheduled SQL Agent jobs, SSRS reports, SSIS, and Power BI dashboards.

Performance tuning

I find the queries doing the most damage, rewrite them, and work out which indexes to add, drop, or consolidate. On one contract, I led a small team through 46 application queries and tracked run time and reads for each one.

Part-time DBA

Installs, backups, restores, logins, and day-to-day care for on-premises SQL Server and Azure SQL.

Migrations

Planning on-premises moves to Azure, then creating and sizing the SQL instances.

Background

I lead with SQL Server and have also worked with Oracle PL/SQL and MySQL. I've also run development teams of up to 50 people, so I know how to work with your team, document what I change, and explain it to the people paying for it.