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.
Announcing two technical sessions at the virtual PASS Summit 2020: migrating SQL Server to Azure VMs and using Columnstore Indexes.
Analyzes SQL Server disk caching on Azure VMs, questioning Microsoft's best practices with performance data.
A guide to essential security practices for protecting SQL Server instances running on Azure Virtual Machines, focusing on encryption and access controls.
Explains SQL Server backup throttling issues in Azure VMs due to disk throughput limits exceeding VM caps, causing performance problems.
Analyzes limitations of SQL Server's Resource Governor IOPS_PER_VOLUME for I/O throttling in complex storage setups, like Azure VMs with multiple drives.
Explains SQL Server licensing options and compliance steps when migrating virtual machines to Microsoft Azure.
SQLPort celebrates its 10th anniversary with a series of 10 technical webinars on Microsoft Data Platform topics like Always Encrypted and Azure Synapse.
