cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Modernization Best Practices and Reusable Assets Blog
Options
588

Optimizing Performance: Oracle to SQL Server Migration using JDBC

rashmishuklaSQLCSE on Apr 30 2024 09:10 AM
Have you encountered high CPU issues after migrating to SQL from Oracle and using a JDBC application? Optimizations are ...
1,644

Database Schema Compare Tool

skhandelwal on Apr 23 2024 09:00 AM
Migration to Azure SQL is far easier than before. Availability of Schema migration, Database migration, Database compari...
1,555

Migrate SQL Server to Azure SQL Managed Instance at Scale

Vijay_Kumar on Mar 26 2024 02:47 PM
In this blog post, we'll walk you through the entire process of migrating your SQL Server databases to Azure SQL Managed...
1,671

Azure SQL Managed Instance - Log Space Growth Alert using Azure Runbook/PowerShell

Vijay_Kumar on Feb 13 2024 08:25 AM
Azure SQL Managed Instance - Log Space Growth Alert using Azure Runbook/PowerShell.
2,225

SQL Server - Minimum downtime schema updates

Mitch van Huuksloot on Feb 12 2024 10:01 AM
This blog describes the result of some proof of concept work to explore minimizing downtime by using the Blue/Green serv...
1,791

SQL Managed Instance DTC implementation – lessons learnt

David_Lyth on Jan 19 2024 07:33 AM
Lessons learnt working with customers setting up their DTC workloads on Azure SQL Managed Instance
1,916

How to handle Large Objects (LOB) migration from Db2, Oracle to Azure SQL & Datalake - Part 2

anilkota on Nov 27 2023 09:00 AM
Want to migrate high volume Large Objects from Db2, Oracle to Azure SQL and ADLS ? Here is the Apache Spark based soluti...
3,701

Best practices for utilizing Azure SQL to host Mainframe Data Tier & Workloads

skhandelwal on Sep 13 2023 07:10 AM
In this technical blog, we have explained the best practices that should be followed to get the best performance on Azur...
3,611

Oracle migration insights from the real-world customer use cases | DBMS_OUTPUT ≠ RAISE NOTICE

KapilSamant on Aug 22 2023 10:47 AM
There exists a common misunderstanding that RAISE NOTICE functions similarly to DBMS_OUTPUT. However, this notion is qui...
5,671

Copy Data from Azure SQL Database to OneLake using Microsoft Fabric

narenan on Aug 11 2023 09:50 AM
How to copy data from Azure SQL Database to OneLake using Microsoft Fabric ?
5,792

Optimizing Log Throughput Consumption on Azure SQL: Effective Workarounds and Best Practices

KapilSamant on Aug 11 2023 09:39 AM
Are you struggling with high Log IO usage during data Ingestion on Azure SQL DB/MI? Uncover remedies to reduce consumpti...
3,843

Oracle to Azure PostgreSQL - Flexible Server Incremental Load Using ADF Data Flows - Part 2

VenkatMR on Aug 03 2023 03:19 PM
This blog post provides a step by step guide for incremental data load from Oracle to Azure Database for PostgreSQL – Fl...
4,833

Oracle to Azure PostgreSQL - Flexible Server Incremental Load Using ADF Data Flows - Part 1

VenkatMR on Aug 03 2023 03:18 PM
This blog post provides a step by step guide for incremental data load from Oracle to Azure Database for PostgreSQL – Fl...
5,124

Mainframe Db2 Data Virtualization using SQL Server PolyBase

skhandelwal on Jul 03 2023 11:03 AM
Looking for easy solution to combine data between Db2 and SQL Server in single query? Want to know more about how to acc...
6,067

How to handle Large Objects (LOBs) migration from Db2, Oracle to Azure SQL & Datalake - Part 1

anilkota on Jun 26 2023 10:12 AM
Want to migrate Large Objects from Db2, Oracle to Azure SQL and Azure Datalake ? Here is the low code / no-code solution...
7,045

Copy data between Azure Data Services at scale with Microsoft Fabric

addy on Jun 21 2023 10:18 AM
Did you know that you can use Microsoft Fabric to copy data at scale from supported data sources to Azure SQL Database o...
7,276

Bring your Mainframe DB2 z/OS data to Microsoft Fabric

PDasgupta on Jun 17 2023 08:35 PM
Do you need mission critical data from your mainframes to be utilized in Microsoft Fabric. In this blog we showcase how ...
3,541

Impact of schema changes in the primary replica on read-only queries in the secondary replica

nataraje on May 25 2023 09:25 AM
Commonly, it is believed that a read-only replica is isolated, and queries running on the primary read-write replica won...
12K

Mainframe EBCDIC Data File to ASCII conversion using Azure Logic App

skhandelwal on Mar 20 2023 06:40 PM
Wondering how to perform Mainframe file EBCDIC data conversion to ASCII on Azure Cloud? Look at the below detailed techn...
5,445

Automatically Enable LTR and PITR Policy upon a Database creation on Azure SQL Managed Instance

ashricky89 on Mar 03 2023 09:40 AM
Automatically Enable LTR and PITR Policy upon a Database creation on Azure SQL Managed Instance
8,683

Monitoring CDC using Extended Events in SQL Server 2022

LaReyes314 on Jan 31 2023 02:49 PM
What do the new SQL 2022 CDC extended events track? CDC jobs include: Capture Job - Captures changes into capture table....
6,237

Part 2 - Azure SQL DB Hyperscale Table Partitioning - Best Practices & Recommendations

diegoc on Jan 31 2023 09:40 AM
Implementing table partitioning on a table that is exceptionally large in Azure SQL Database Hyperscale is not trivial d...
7,321

Part 1 - Azure SQL DB Hyperscale Table Partitioning - Best Practices & Recommendations

diegoc on Jan 31 2023 09:37 AM
Implementing table partitioning on a table that is exceptionally large in Azure SQL Database Hyperscale is not trivial d...
34.5K

Automating the setup of Azure SQL Managed Instance Link

DesFitz on Jan 24 2023 10:19 AM
In this post we will be discussing how to automate the setup of the Managed Instance Link feature which enables near rea...
7,525

Hack for speeding up data migration for large tables using SSMA for Oracle

KapilSamant on Jan 03 2023 12:00 AM
Learn how to manually multithread SSMA data migration for a large table.
11.8K

Convert and unpack Mainframe/Midrange File System data from EBCDIC to ASCII Using Azure Data Factory

Ramanath_Nayak on Sep 20 2022 09:35 AM
Mainframe File Data Mapper is a custom connector which has been built to convert Mainframe EBCDIC datatypes to ASCII dat...
14.4K

Db2 to Azure SQL DB parallel data copy by generating ADF copy activities dynamically

skhandelwal on Aug 26 2022 08:41 AM
Want to utilize near to full network bandwidth / CPU resources on source and target to perform efficient data copy from ...
6,764

Mainframe Dataset (Files) Transfer to Azure Storage (Blob) using Mainframe JCL

Ramanath_Nayak on Aug 16 2022 08:35 AM
This article shows the steps involved in moving mainframe file data to Azure Blob using Java on Mainframe. Mainframe fil...
8,998

Sybase ASE to Azure SQL full and incremental data copy using ASE Transfer Table Tool and ADF

vishal on Jul 18 2022 05:01 AM
In this BLOG post we will be covering the SAP ASE Data Transfer Utility, which offers the T-SQL command ‘transfer table ...

Latest Comments

Nigel370
in Migrate SQL Server to Azure SQL Managed Instance at Scale on Apr 25 2024 09:25 AM
Very Insightful! NM,www.sqlops.com
0 Likes
Ramanath_Nayak
in Convert and unpack Mainframe/Midrange File System data from EBCDIC to ASCII Using Azure Data Factory on Feb 08 2024 09:05 PM
Hello Hari At this point of time we do not have a connector for ASCIItoEBCDIC. Request you to write to datasqlninja@microsoft.com with additional details so that we can evaluate and invest in creating one. Thanks, Ramanath.
0 Likes
Hari_Daliparthi
in Convert and unpack Mainframe/Midrange File System data from EBCDIC to ASCII Using Azure Data Factory on Feb 08 2024 12:00 PM
Hi Ramanath, Is its passible to write MAINFRAME EBCIDIC FILES? Do we have any connector from ascii2ebcidic? We want to write mainframe file from azure. ThanksHari
0 Likes
gsiciliano
in Automating the setup of Azure SQL Managed Instance Link on Feb 02 2024 06:27 AM
Hello, thanks for the explain the solution-I am trying to configure it between a SQL MI and a SQL in VM (secondary read replica). I do all the steps and it fails in the last one. (I have all the ports added in the network test, I get this message)Thanks Guillermo
0 Likes
amethyst
in Oracle to Azure PostgreSQL - Flexible Server Incremental Load Using ADF Data Flows - Part 1 on Dec 19 2023 11:53 AM
Hi @immafrank Here is the link to part 2 Oracle to Azure PostgreSQL - Flexible Server Incremental Load Using ADF Data Flows - Part 2 - Microsoft Community Hub
0 Likes