Category: Database
-
Find Your Slowest SQL Queries With Azure Log Analytics (KQL Recipes)
When a .NET application running on Azure feels slow, the database is the usual suspect — but “the database is slow” is a hunch, not a diagnosis. If your app sends telemetry to Application Insights, every SQL call is already being recorded as a dependency, and a handful of KQL queries in Log Analytics will…
-
How Two Indexes Cut a 15-Minute Stored Procedure to 30 Seconds
Slow stored procedures are one of the most common and most misdiagnosed problems we are called in to fix. The instinct is often to throw more hardware at the database or to rewrite the whole procedure. In most cases neither is necessary. On a recent engagement we cut a reporting procedure from over 15 minutes…
-
Choosing the Right Database for Your .NET API: SQL Server, MongoDB, PostgreSQL, and More
When developing APIs with .NET, selecting the right database is crucial for performance, scalability, and ease of integration. Whether you need the structured reliability of SQL Server, the flexibility of MongoDB, or the simplicity of SQLite, we provide tailored solutions to match your project requirements. Our experienced team helps businesses make the best choice for…