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
1,104

Copy Data to Azure SQL Database from Mainframe Db2 using Microsoft Fabric Data pipelines

skhandelwal on Sep 06 2024 09:33 AM
To migrate data from Db2 on a mainframe to an Azure SQL Database, leveraging Fabric Data Pipelines provides a streamline...
1,465

Recovering and Validating Data After Unexpected SQL Server Failovers

Mitch_van_Huuksloot on Aug 12 2024 12:10 PM
SQL Server Geographic replication using distributed availability groups (DAGs) provide an extra layer of data security o...
1,109

Setting Up CDC for Seamless Operations in Azure SQL Managed Instances with Failover Groups

diegoc on Jul 15 2024 03:57 PM
Customers leverage Change Data Capture (CDC) with Azure SQL Managed Instance in various configurations. Although CDC ope...
993

Converting database objects from Db2 to Azure Database for PostgreSQL

naruldoss on Jun 26 2024 11:07 AM
For customers migrating from Db2 to Azure database for PostgreSQL, we have built a custom tool that can convert database...
1,162

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...
1,486

Azure Database for PostgreSQL - Latency comparison between PGBouncer and Npgsql

akumaranchath 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,854

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...
1,262

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 ...
3,225

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...
2,523

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...
2,278

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.
3,307

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...
2,651

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

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...
4,353

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...
4,390

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

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 ?
7,534

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...
4,525

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...
5,777

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

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

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

Copy data between Azure Data Services at scale with Microsoft Fabric

akumaranchath 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...
8,906

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 ...
4,245

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

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...
6,221

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
10.4K

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

Latest Comments

shruthigr
in Azure SQL Managed Instance – Sync Agent Jobs and Logins in Failover Groups on Aug 29 2024 06:20 AM
Hi @narenan ,1. If CHECK_POLICY=ON in Primary Instance, then StoredProcedure [dbo].[CreateLoginsInSecondary] script is getting failed on secondary instance, in case of "Alter Login" with below errorError: a hashed password cannot be set for a login that has check_policy turned onSolution: Need to ad...
0 Likes
skhandelwal
in Copy files from Mainframe to Azure Data Platform using ADF FTP Connector on Aug 01 2024 12:04 AM
@Tnvy04 // prefix is necessary to specify fully qualified name of the file i.e. //servername/filename. This is standard FTP connector used to get files from Windows / Linux. Mainframe files are not organized the way Windows / Linux files are. So, wildcard will not work. In case if you want to copy m...
0 Likes
Tnvy04
in Copy files from Mainframe to Azure Data Platform using ADF FTP Connector on Jul 31 2024 09:07 PM
@skhandelwal thank you for the write up. It was very helpful. Can you explain why the // prefix is necessary and how you figured that out? I'm trying to use the filename wildcard, but am not able to because of the prefix.
0 Likes
KA_Rieshan101645
in Part 1 - Azure SQL DB Hyperscale Table Partitioning - Best Practices & Recommendations on Jun 24 2024 06:42 AM
Hi Diego Caracciolo, Thanks for the detailed info. May I know how to handle when the table is involved in transactional replication with CDC? If we need to partition this kind of setup when involved in Transactional replication or on Always-on databases with CDC how can we achieve implementing table...
0 Likes
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