SQL Server
31 posts tagged with this.
-
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.
-
Reading SQL Server Execution Plans Effectively
Execution plans reveal how SQL Server executes queries and where bottlenecks occur. Learning to interpret them allows targeted improvements in indexing, statistics, and query structure for production workloads.
-
T-SQL Optimization Patterns for SQL Server Production
Effective query optimization in SQL Server begins with execution plan analysis and targeted indexing rather than broad configuration changes. This post outlines practical T-SQL patterns and maintenance steps that deliver measurable gains on production workloads.
-
Tuning T-SQL Queries for SQL Server Production Workloads
Small, targeted changes to T-SQL patterns often deliver the largest performance gains on recent SQL Server releases. This post outlines practical steps for analyzing execution plans, refining queries, and applying indexing strategies that hold up under production load.
-
Query Optimization Techniques for Production SQL Server
Effective query optimization in SQL Server begins with execution plan analysis and targeted index selection. This post outlines practical T-SQL patterns that reduce CPU and I/O pressure in production environments.
-
Query Optimization Techniques for SQL Server Workloads
Performance issues in SQL Server often stem from suboptimal queries and missing indexes. Learn proven techniques to analyze and tune your T-SQL for better throughput in production databases.