Data and documents
SQL ServerFaster applications and reports
Microsoft's relational database system for storing application data and processing it with SQL.
Business applications
It supports business records, reports and integrations. Reliability also depends on queries, backups and access controls.
How it fits into my work
I work on schema, indexes, execution plans, locks and migrations with before-and-after measurements.
Example scenario
SQL Server: Example scenario
A slow report is diagnosed using Query Store and execution plans before targeted changes are made.
Where should your company start?
Identify a slow screen, report or import. Provide sample data, timing and the load at which the problem occurs.
How will you know it helps?
Compare response time, result correctness and resource use on the same representative scenario.