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.
A series of technical how-to guides for Azure SQL Managed Instance, written by a Microsoft employee, with new posts planned.
Explains the security concept of Audit Trails in SQL Server, covering their purpose, implementation, and importance for incident response.
A speaker's experience and session details from presenting on Azure Arc Data Services at Data Saturday #14 in Oslo.
Guide to connecting a .NET 5 application on Linux EC2 to an RDS SQL Server instance using AWS Managed Microsoft AD for authentication.
Explains delegation of authority in security, focusing on SQL Server and Azure AD, covering identity vs. authorization level delegation and practical examples.
Analysis of Database Scoped Configuration changes in SQL Server and Azure SQL Database for the year 2020, noting new options and stability.
Explains the 'Need-to-know' security principle for SQL Server and Azure SQL, detailing access control methods and implementation scenarios.
