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
427

Apply Azure Hybrid Benefits at Scale for Azure SQL

tyrussel on Jun 04 2024 09:28 AM
AHB can be applied at database creation time and can be changed via the Azure Portal. However, there are use cases where...
426

Azure Database for PostgreSQL - Latency comparison between PGBouncer and Npgsql

addy on Jun 04 2024 09:18 AM
Migrating from Oracle to Azure Database for PostgreSQL there are multiple connection pooling options to choose from - sh...
1,023

Azure SQL Managed Instance Point-In-Time Restore Service Level Expectation

diegoc on May 29 2024 11:53 AM
Customers evaluating or already using SQL Managed Instance (SQL MI) need to estimate how much time a database point in t...
718

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,868

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,716

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,778

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,417

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,932

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
2,014

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,798

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,695

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,986

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 ?
6,012

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,967

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,993

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,256

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,196

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,197

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,536

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,642

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...
12.1K

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,573

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,956

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,388

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,512

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.8K

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,700

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.
12K

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...

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