Database design and T-SQL
Schemas, stored procedures and views that fit the application and the people who query it.
Service · Run
Microsoft SQL Server practice
Database design and T-SQL, performance tuning and indexing, SSIS and SSRS, Azure SQL migration, security hardening, disaster recovery and the fractional DBA work that keeps a line-of-business system alive after the person who set it up has gone.
What we do
Nine kinds of SQL Server work.
Performance tuning
Waits, plans and indexes. Most engagements end with the slow report running in seconds.
SSIS development
Packages built, inherited ones documented and made changeable, Azure Data Factory when it fits.
SSRS reporting
Operational reports and subscriptions on views the business agrees on.
SSAS and warehousing
Models and marts when the history and volume justify them.
Azure SQL migration
An honest answer on whether to move, then the migration with a rollback plan.
Upgrades
Off 2008 through 2017 and onto a version Microsoft patches, with the application vendor's blessing.
Security and compliance
Least privilege, encryption, auditing, and the evidence your insurer asks for.
Disaster recovery and DBA
Backups that restore, Always On where it earns its keep, and a fractional DBA on retainer.
Common problems we solve
The calls we get most.
The month-end report takes forty minutes
Usually three missing indexes and a parameter-sniffing problem, found in the first afternoon.
The ERP runs on SQL Server 2016
Out of support since July 2026; the upgrade is planned with the vendor's compatibility matrix in hand.
Nobody knows what the SSIS packages do
We read them, document them, and make the one that broke changeable.
Common questions
Before you book.
Should we move to Azure SQL?
Sometimes. A line-of-business ERP with a vendor that supports only on-premises SQL Server should not; a custom application with variable load often should. The health check or assessment gives you the answer with the costs.
Do you offer ongoing DBA support?
Yes, as a fractional DBA retainer or inside a care plan: patching, backup tests, growth, and the week something breaks.
Which versions do you support?
SQL Server 2008 through 2022 on premises, Azure SQL Database and Managed Instance. Anything before 2017 is out of Microsoft support, and we will say so plainly.
Tell us which query, which version, or which backup worries you.
Thirty minutes, no obligation. We reply within one business day.