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.
Explains the Principle of Least Privilege (POLP) for security in SQL Server, covering user permissions, service accounts, and attack surface reduction.
Explains how to use DDL Triggers in SQL Server to log database schema changes for troubleshooting, contrasting it with formal SQL Auditing for security.
A guide to converting SQL Server Profiler templates to Extended Events (XEvents) sessions using the SSMS GUI for performance monitoring.
A developer shares the value of SQL Server Profiler for debugging and performance analysis, offering tips for creating effective custom trace templates.
Explains the need for write permissions on Azure Blob Storage files when restoring SQL Server backups and the implications for lifecycle management.
Troubleshooting guide for resolving Azure SQL Server connectivity issues caused by Windows Firewall blocking port 1433.
