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 touchWhat 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.