The Curious Engineer

All blogs / DevOps / SRE / infrastructure

Modernization Best Practices and Reusable Assets Blog

techcommunity.microsoft.com/category/azuredatabases/blog/modernizationbestpracticesblog

DevOps / SRE / infrastructureDatabasesMicrosoft blogsMicrosoft Tech Community

’21’22’23’24’25’26
Posts
89 from 21 Oct 2021 to 8 Sep 2026
Posting
monthly (14 in the last year)
Kind
company blog

2026 10

  1. Azure SQL DB HS Data Load Using Microsoft JDBC Driver Instead of Apache Spark Connector for SQL
  2. Automating Oracle to SQL Migration Using SSMA Console Skill in GitHub Copilot
  3. Memory-Optimized Table Variables: Performance Under the Microscope
  4. Microsoft Options to Migrate SQL Server Databases
  5. Unlocking the Power of Azure Resource Graph Explorer for Comprehensive Database Inventory
  6. The Odd Couple - Latches and KEEP_NULLS
  7. Redefining Database Maintenance after Migrating from Db2 on Mainframe to Azure SQL DB Hyperscale
  8. Azure SQL’s Native JSON Type: Optimized for Performance
  9. Handling Sybase BIGTIME Data Type During Migration to Azure SQL
  10. Implementing Oracle Autonomous Transactions in Azure SQL for Seamless Logging

2025 22

  1. Data Migration Strategies for Large-Scale Sybase to SQL Migrations Using SSMA, SSIS and ADF- Part 1
  2. Data Migration Strategies for Large-Scale Sybase to SQL Migrations Using SSMA, SSIS and ADF- Part 2
  3. Faster Data Copy between Source and target for partitioned table using Partition Switch in ADF
  4. AI-Powered Db2 LUW to Azure Database for PostgreSQL Schema Converter
  5. Enforcing SQL PaaS backup retention with Azure Policy
  6. Migrating Oracle Partitioned Tables to Azure PostgreSQL Without Altering Partition Keys
  7. Key Considerations to avoid Implicit Conversion issues in Oracle to Azure SQL Modernization
  8. Optimized Data Transfer from Sybase ASE to Azure SQL via Chunked BCP Processing
  9. Temporal Table Replication in SQL Server: Common Barriers and Solutions
  10. Seamless Online Homogeneous SQL Family Migration via Azure Data Factory using SQL CDC
  11. Hidden pitfalls of Temporary Tables in Oracle to PostgreSQL Migrations
  12. Ingesting Mainframe File System Data (EBCDIC) into SQL DB on Fabric Using OSS Cobrix
  13. Optimizing Data Archival with Partitioning in Azure PostgreSQL for Oracle Migrations
  14. Script Entra Logins and Users for Azure SQL DB Utility
  15. Seamlessly Moving SQL Server Enabled by Azure Arc to a New Resource Group or Subscription
  16. Best practices for modernizing large-scale Text-Search from legacy data systems to Azure SQL
  17. SQL Unicode comparisons
  18. Optimizing Query Store Memory Usage for Ad hoc Workloads
  19. TempDB Size Considerations to Ensure Successful SQL VM Deployments from Marketplace Images
  20. Seamless Cross-Tenant Migration of Azure SQL Databases without Modifying Connection Strings
  21. Oracle to Azure SQL Post Migration Optimization: Handling Oracle Function-Based Indexes in Azure SQL
  22. Ingest Db2 data into Fabric Native SQL Database

2024 20

  1. Enhancing SQL PaaS Security: Automating Azure Blob SAS Key Rotation Using Azure Runbooks
  2. Enhancing SQL Server Transactional Replication Initialization Performance
  3. Diagnosing and Resolving Oracle to Azure PostgreSQL Migration Failures with Ora2Pg
  4. Resolving ADF Copy Upsert Failures in SQL DB for XML Columns
  5. Troubleshooting page-related performance issues in Azure SQL
  6. Implementing Oracle Data Masking capabilities in Azure PostgreSQL- Flexible Server
  7. Building Bronze Layer of Medallion Architecture in Fabric Lakehouse using WAL2JSON
  8. Copy Data to Azure SQL Database from Mainframe Db2 using Microsoft Fabric Data pipelines
  9. Recovering and Validating Data After Unexpected SQL Server Failovers
  10. Setting Up CDC for Seamless Operations in Azure SQL Managed Instances with Failover Groups
  11. Converting database objects from Db2 to Azure Database for PostgreSQL
  12. Apply Azure Hybrid Benefits at Scale for Azure SQL
  13. Azure Database for PostgreSQL - Latency comparison between PGBouncer and Npgsql
  14. Azure SQL Managed Instance Point-In-Time Restore Service Level Expectation
  15. Optimizing Performance: Oracle to SQL Server Migration using JDBC
  16. Database Schema Compare Tool
  17. Migrate SQL Server to Azure SQL Managed Instance at Scale
  18. Azure SQL Managed Instance - Log Space Growth Alert using Azure Runbook/PowerShell
  19. SQL Server - Minimum downtime schema updates
  20. SQL Managed Instance DTC implementation – lessons learnt

2023 20

  1. How to handle Large Objects (LOB) migration from Db2, Oracle to Azure SQL & Datalake - Part 2
  2. Azure SQL Hyperscale – Steps to Create a Named Replica on Zone Redundant Secondary Replica
  3. Best practices for utilizing Azure SQL to host Mainframe Data Tier & Workloads
  4. Oracle migration insights from the real-world customer use cases | DBMS_OUTPUT ≠ RAISE NOTICE
  5. Copy Data from Azure SQL Database to OneLake using Microsoft Fabric
  6. Optimizing Log Throughput Consumption on Azure SQL: Effective Workarounds and Best Practices
  7. Oracle to Azure PostgreSQL - Flexible Server Incremental Load Using ADF Data Flows - Part 2
  8. Oracle to Azure PostgreSQL - Flexible Server Incremental Load Using ADF Data Flows - Part 1
  9. Mainframe Db2 Data Virtualization using SQL Server PolyBase
  10. How to handle Large Objects (LOBs) migration from Db2, Oracle to Azure SQL & Datalake - Part 1
  11. Copy data between Azure Data Services at scale with Microsoft Fabric
  12. Bring your Mainframe DB2 z/OS data to Microsoft Fabric
  13. Impact of schema changes in the primary replica on read-only queries in the secondary replica
  14. Mainframe EBCDIC Data File to ASCII conversion using Azure Logic App
  15. Automatically Enable LTR and PITR Policy upon a Database creation on Azure SQL Managed Instance
  16. Monitoring CDC using Extended Events in SQL Server 2022
  17. Part 2 - Azure SQL DB Hyperscale Table Partitioning - Best Practices & Recommendations
  18. Part 1 - Azure SQL DB Hyperscale Table Partitioning - Best Practices & Recommendations
  19. Automating the setup of Azure SQL Managed Instance Link
  20. Hack for speeding up data migration for large tables using SSMA for Oracle

2022 16

  1. Db2 to Azure SQL DB parallel data copy by generating ADF copy activities dynamically
  2. Mainframe Dataset (Files) Transfer to Azure Storage (Blob) using Mainframe JCL
  3. Sybase ASE to Azure SQL full and incremental data copy using ASE Transfer Table Tool and ADF
  4. Data Archiving Strategies for SQL Server
  5. Mainframe files transfer to Azure Data Platform using SFTP
  6. Database Migration / Reverse Migration between Azure SQL (DB/MI) and SQL Server using SmartBulkCopy
  7. Database Comparison Tool
  8. Database migrations to Azure SQL Managed Instance - Restore with Full and Differential backups
  9. SQL Server Replication as a tool to migrate very large databases
  10. Migrating Mainframe RACF user identities to Microsoft Entra ID Users
  11. Accelerating Oracle Estate Assessment for Migrations to SQL Server
  12. SQL Server Regular Expressions Library Sample
  13. PowerShell script to help migrate from DTU to vCore model of Azure SQL DB.
  14. Mainframe Data Modernization to Azure
  15. Using Heterogeneous Linked Servers from Azure SQL MI
  16. Copy files from Mainframe to Azure Data Platform using ADF FTP Connector

2021 1

  1. Azure SQL Managed Instance – Sync Agent Jobs and Logins in Failover Groups