1 min read
Synapse Pathway: Accelerating Data Warehouse Migration
Synapse Pathway translates SQL code from various sources to Azure Synapse Analytics SQL syntax: Teradata to Synapse Netezza to Synapse Snowflake to Synapse…
SQL Server
8 articles
2 min read
Link Feature for Azure SQL Managed Instance
The Link feature for Azure SQL Managed Instance enables replicating databases from SQL Server 2019 and SQL Server 2022 to Azure SQL Managed Instance in…
1 min read
Contained Availability Groups in SQL Server 2022
Contained AGs maintain their own system databases (master and msdb) within the AG, ensuring instance-level objects replicate automatically.
2 min read
SQL Server 2022 Preview: Key Features for Developers
SQL Server 2022 entered public preview in late 2021 and continued preview through 2022 with a feature set deliberately designed to bridge the gap between…
1 min read
Azure Arc-Enabled SQL Managed Instance
Azure Arc-enabled SQL Managed Instance delivers enterprise SQL Server capabilities with cloud-native operations on any infrastructure.
2 min read
SQL Server to Azure SQL Migration - A Complete Guide
SQL Server to Azure SQL migration is the database journey I've been on more times than any other, and the first decision that shapes everything else is…
1 min read
Azure Database Migration Service - Strategies for Database Modernization
1. Assess compatibility first Use DMA for SQL Server 2. Test migrations in non prod Validate before production 3. Plan for downtime Even online migrations…
1 min read
Azure SQL Managed Instance: SQL Server in the Cloud
Things you can't do in Azure SQL Database but can in Managed Instance. Real-time replication from on-premises SQL Server to Managed Instance - useful for…