Tag

SQL Server

25 posts tagged with this.

All posts RSS
  1. Official Blog
    · 2 min read

    Separate Liveness From Database Readiness

    Load balancer probes that open SQL on every hit will starve the pool under recycle storms. Split liveness from readiness before the next deploy.
  2. Official Blog
    · 2 min read

    SqlClient Encrypt Defaults Break Quietly After NuGet Bumps

    A Microsoft.Data.SqlClient bump can flip Encrypt on and drop SQL connections from IIS overnight. The failure mode, and how to set Encrypt on purpose.
  3. Official Blog
    · 4 min read

    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.
  4. Official Blog
    · 4 min read

    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 on IIS.
  5. Official Blog
    · 4 min read

    Query Store for ASP.NET Deploys on SQL Server

    A page that was fine before an IIS publish now waits on SQL. Query Store shows plan and duration changes without Profiler, so regressions are easy to read.
  6. Official Blog
    · 4 min read

    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, cut lock cycles.
  7. Official Blog
    · 4 min read

    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.
  8. Official Blog
    · 4 min read

    EF Core rowversion Checks Against Lost SQL Updates

    Stop silent last-write-wins bugs in multi-user ASP.NET apps. Map SQL Server rowversion and catch DbUpdateConcurrencyException.
  9. Official Blog
    · 5 min read

    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.
  10. Official Blog
    · 4 min read

    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.
  11. Official Blog
    · 4 min read

    SQL Timeouts and Pooling for Hosted ASP.NET Apps

    Most ASP.NET SQL timeouts on Windows hosting are pool exhaustion or bad plans. Fix connection strings, timeouts, indexes, and EF Core habits.
  12. Official Blog
    · 4 min read

    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.
  13. Official Blog
    · 1 min read

    Tuning T-SQL Queries for SQL Server Production Workloads

    Rewrite SQL Server queries to cut logical reads and use indexes well. Practical T-SQL patterns and monitoring steps for production workloads.
  14. Official Blog
    · 1 min read

    Tuning SQL Server Queries with Execution Plans and Indexes

    Improve SQL Server query performance with execution plan analysis and targeted indexing: concrete T-SQL patterns and monitoring techniques.
  15. Database VaultKnowledge BaseWHMCS Modules
    · 4 min read

    Does Database Vault Support Remote SQL Server Database Backups?

    Database Vault does not support creating database backups from a remote SQL Server system. It relies on Microsoft's SMO library which requires direct access to the local file system of the SQL Server instance. This article explains the technical reasons, demonstrates SMO usage, outlines alternatives