A guide to optimizing SQL Server indexes for tables with high rates of data insertion, updates, and deletions to combat fragmentation.
Announcing a full-day SQL Server performance monitoring and troubleshooting PreCon session at SQLSaturday NYC 2025, led by a former Microsoft PM.
SQL Server 2019 has ended mainstream support, leaving users with only security patches. This article outlines the implications and next steps.
A developer announces the return of their technical blog after a 3-year hiatus, hinting at future posts on databases, cloud, AI, and more.
SQL Server auditing fails to capture permission change attempts, creating a security gap. Article details the issue and a temporary workaround.
Analyzes challenges implementing the Principle of Least Privilege in Microsoft SQL Server, focusing on tasks that still require the powerful sysadmin role.
A technical guide comparing SQL Server data-at-rest encryption methods: Transparent Data Encryption, Backup Encryption, and Always Encrypted.
A guide for SQL Server DBAs on using Ansible to automate database administration tasks like installation, backup, and user management.
A technical guide on enforcing TLS 1.2 and trusted certificates for SQL Server connections to secure data in transit, covering FedRAMP compliance.
A guide to obfuscating sensitive data directly within SQL Server using a user-defined function, focusing on securing development environments.
A guide to implementing fine-grained permissions for SQL Server Extended Events to enforce the Principle of Least Privilege with role separation examples.
A former Azure SQL security engineer outlines seven key improvements needed for access control and security in SQL Server and Azure SQL.
A tutorial on using Docker Compose to containerize an ASP.NET Core Web API and connect it to a SQL Server database running in separate containers.
Explains how to filter on JSON array columns in Entity Framework Core 7 using SQL workarounds when LINQ translation fails.
A technical guide on using jOOQ to pass table-valued parameters (TVPs) to T-SQL functions from Java, with code examples.
Entity Framework 8 adds native SQL Server support for .NET's DateOnly and TimeOnly types, eliminating the need for custom converters.
A guide to automating SQL Server database backups as BACPAC files and uploading them to Azure Blob Storage using SqlPackage and AzCopy.
Discusses a bug where DatabaseMailUserRole prevents SQL Server from starting after patching, based on MVP and customer reports.
Learn how to use OpenTelemetry to monitor, identify, and fix common database performance issues in a .NET application.
Author previews their upcoming SQL Managed Instance presentations at the SQLBits 2022 conference, highlighting new features and demos.
