Learn it from developers who built it.
Tutorials, how-tos and deep dives on AI, .NET, C#, cloud and developer tools, written by the community.
Learn how to plan and test SQL Server database failover in an ASP.NET Core application, including failover-aware connections, EF Core retries, and safe transaction recovery.
Learn how to migrate SQL Server text columns to UTF-8 collations safely, including storage limits, comparison changes, unique indexes, and schema inventory.
Learn how SQL Server Always Encrypted protects column data, why traditional encrypted queries are limited, and how secure enclaves enable additional operations.
Learn how SQL Server columnstore indexes improve large analytical queries, when to use clustered or nonclustered indexes, and how compression, row groups, and batch mode affect performance.
Learn how to test SQL Server columnstore indexes for reporting workloads by comparing rowstore and columnstore query performance, execution plans, reads, CPU use, and write overhead.
Learn how to use SQL Server Row-Level Security to isolate customer data with security policies, filter predicates, and session context in an ASP.NET Core application.
Learn why SQL Server escalates locks, how escalation can cause blocking, and how to identify blocking sessions and lock waits using DMVs.
Learn to import large CSV files into SQL Server with BULK INSERT, configure loading options, use staging tables, and compare BULK INSERT with bcp and SqlBulkCopy.
Learn how to use SQL Server window functions to rank records within groups, handle ties, compare rows, and calculate running totals.
Learn how SQL Server filtered indexes work, when they improve query performance, and why SQL Server may not choose them for a query.
Learn how to make SQL Server schema changes without downtime using compatible deployments, staged data migration, and the expand-and-contract pattern.
Learn how to enable SQL Server Query Store, identify regressed queries, compare performance across time intervals, and investigate execution-plan changes.
Learn how to import large CSV files into SQL Server with BULK INSERT, staging tables, TABLOCK, and index considerations for faster bulk data loads.
Learn how SQL Server deadlocks occur, how to analyze deadlock graphs with Extended Events, and how to reduce conflicts and safely handle error 1205 retries.
Learn why SQL Server parameter sniffing can cause inconsistent query performance, how to identify it with execution plans and Query Store, and which factors to investigate.
Learn how to diagnose SQL Server deadlocks with deadlock graphs, fix conflicting locking patterns, and apply safe, controlled retries for error 1205.
Learn how to create and query SQL Server system-versioned temporal tables to automatically retain row history after updates and deletes.
Learn how SQL Server parameter sniffing affects cached execution plans, how to diagnose it, and how to choose fixes for inconsistent query performance.
Learn how SQL Server system-versioned temporal tables preserve row history, replace many audit triggers, and support historical queries with FOR SYSTEM_TIME.
Learn how SQL Server parameter sniffing affects cached execution plans, how to diagnose it with execution plans and Query Store, and how to investigate slow queries.
Learn how to capture and interpret SQL Server deadlock graphs with Extended Events, identify competing locks and transactions, and determine the root cause of deadlocks.
Learn how to enable SQL Server Query Store, compare historical execution plans and runtime statistics, and identify query performance regressions.
Configure Fail2Ban on Ubuntu to detect failed SQL Server logins, ban brute-force clients, enable startup persistence, and verify MSSQL jail status.
Learn how Azure SQL time-zone support helps convert UTC timestamps to local time, preserve time-zone IDs, and handle daylight-saving rules in database operations.
Learn how to run SQL Server 2025 in a Podman container on Windows. This step-by-step guide covers Podman Desktop setup, SQL Server installation, persistent storage, SSMS connection, useful commands, and common troubleshooting tips.
Learn how to perform zero-downtime SQL Server schema changes for .NET applications using safer deployment strategies, compatibility techniques, and database migration practices.
Learn how to use Microsoft.Data.SqlClient retry logic in .NET to handle transient SQL Server connection failures, improve application resilience, and build reliable database applications.
Learn how to use the Azure SQL Developer container to build local and offline .NET development environments with consistent database behavior for development and CI/CD.
Compare Azure SQL Free Tier and SQL Server Express for .NET applications using performance, latency, storage, connections, resource limits, and cost considerations.
Benchmark migration from SQL Server Express to Azure SQL and explore compatibility, performance, configuration, and application changes when moving .NET workloads.
Everything on SQL Server, not only its articles: the SQL Server page →
Write an article and earn +1,000 SHARP when it is approved.
Write an article
