SQL Server
36 posts tagged with this.
-
Parameter Sniffing Fixes for ASP.NET SQL Workloads
One cached plan can make the same ASP.NET query fly or crawl. Spot parameter sniffing on SQL Server and fix it without blanket recompiles.
-
SQL Connection Pools and Timeouts on IIS Hosts
Pool exhaustion often surfaces as random SQL timeouts under load. Tune Max Pool Size, Connect Timeout, and CommandTimeout for ASP.NET apps on IIS before traffic spikes.
-
Query Store for ASP.NET Deploys on SQL Server
A page that was fine before an IIS publish suddenly waits on SQL. Query Store shows plan and duration changes without Profiler. Enable it, tag app traffic, and read regressions on SQL Server 2022/2025.
-
SQL Deadlock Retries for ASP.NET Core on IIS
Error 1205 becomes a user-facing 500 unless ASP.NET Core retries the unit of work. Enable provider retry, shorten transactions, and cut lock cycles on SQL Server 2022/2025.
-
Patch Discipline for .NET on IIS and SQL Server
Unpatched runtimes beat fancy headers as a breach path. Build a repeatable patch cadence for the Hosting Bundle, IIS, and SQL Server on Windows hosts.
-
EF Core rowversion Checks Against Lost SQL Updates
Stop silent last-write-wins bugs in multi-user ASP.NET apps. Map SQL Server rowversion, catch DbUpdateConcurrencyException, and keep edits honest under load.
-
Least Privilege for ASP.NET on IIS and SQL Server
Shrink IIS app pool rights and SQL logins so a compromised ASP.NET site cannot roam the box. Concrete ACL, identity, and T-SQL patterns for production hosts.
-
SQL Server Restore Checklist for ASP.NET Apps
Bad cutovers and orphaned logins break restores more often than corrupt backups. Use this SQL Server checklist before you point ASP.NET back at production.
-
SQL Timeouts and Pooling for Hosted ASP.NET Apps
Most ASP.NET SQL timeouts on Windows hosting are pool exhaustion or bad plans, not a dead engine. Fix connection strings, timeouts, indexes, and EF Core habits.
-
Harden ASP.NET on IIS: Headers, Cookies, Secrets
Most hosted ASP.NET breaches start with missing headers, weak cookies, and secrets in Web.config. Harden IIS and .NET 10 apps with concrete config you can ship today.
-
Tuning T-SQL Queries for SQL Server Production Workloads
Effective SQL Server performance starts with rewriting queries to reduce logical reads and leverage indexes efficiently. This post outlines practical T-SQL patterns and monitoring steps that deliver measurable gains on production systems.
-
Tuning SQL Server Queries with Execution Plans and Indexes
Query performance in SQL Server improves most reliably through systematic analysis of execution plans and targeted indexing. This post outlines concrete T-SQL patterns and monitoring techniques for production workloads.
-
Tuning T-SQL Queries in Modern SQL Server
Modern SQL Server provides built-in tools that surface slow queries and execution plans without external monitoring. Applying these capabilities reduces guesswork and improves throughput on production workloads.
-
Tuning SQL Server Queries with Window Functions
Window functions in T-SQL let you compute aggregates and rankings over row sets without self-joins or staging tables. This approach often cuts query runtime and simplifies maintenance on current SQL Server releases.
-
Tuning T-SQL Queries on Modern SQL Server Workloads
Effective query optimization in SQL Server starts with execution plans and targeted indexes rather than guesswork. This post covers practical patterns that reduce CPU and I/O in production databases running recent SQL Server releases.