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.
A personal retrospective on founding and leading the SQLPort user group for SQL Server and Microsoft Data Platform over its first decade.
Explores methods for automatically deleting old SQL Server backup files stored in Azure Blob Storage, comparing tools like SQL Agent and Azure Automation.
A guide to integrating data from MSSQL linked servers into Entity Framework Core applications using database views.
Explains the evolution and technical details of striping SQL Server backups to Azure Blob Storage, covering performance improvements and limitations.
Announcement of a technical workshop on SQL Server Columnstore Indexes, covering versions, features, and practical techniques.
Explores SQL Server 2019's session context functions and their unexpected impact on query parallel execution plans.
Explains limitations of ONLINE rebuild for Rowstore indexes on tables with Columnstore Indexes in older SQL Server versions (2016, 2017).
A technical guide on setting up and using a Linked Server in SQL Server to query data from a MySQL database.
Announcement of a pre-conference workshop on SQL Server Columnstore Indexes at SQLSaturday Cincinnati, covering versions, batch mode, and Azure Synapse features.
Overview of new Database Scoped Configurations in SQL Server 2019, including VERBOSE_TRUNCATION_WARNINGS and LAST_QUERY_PLAN_STATS.
Announcing a SQLBits 2020 workshop on migrating, optimizing, and running SQL Server workloads on Azure Virtual Machines.
Announcement for a full-day workshop on SQL Server Columnstore Indexes at SQLSaturday Vienna 2020, covering practical techniques across multiple versions.
