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
611

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

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

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

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

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

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

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

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

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

Sandip_Khandelwal 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 ...
1,769

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

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

Data Archiving Strategies for SQL Server

Mitch van Huuksloot on May 17 2022 11:59 AM
As databases grow, keeping them performing well becomes increasingly more difficult. Often pruning data that is no longe...
5,310

Mainframe files transfer to Azure Data Platform using SFTP

Sandip_Khandelwal on May 06 2022 02:05 PM
This article provides information about how to perform secured file transfer from Mainframe to Azure Data Lake Storage d...
2,873

Database Migration / Reverse Migration between Azure SQL (DB/MI) and SQL Server using SmartBulkCopy

DesFitz on Mar 28 2022 08:57 AM
The purpose of this blog post is to accelerate and automate database migrations between different SQL Server Source and ...
4,371

Database Comparison Tool

Mitch van Huuksloot on Mar 07 2022 12:59 PM
Migrating data between databases often requires verification. This tool allows a flexible, high performance way of compa...
3,916

Database migrations to Azure SQL Managed Instance - Restore with Full and Differential backups

ashricky89 on Feb 18 2022 04:03 AM
This blog will guide organizations to help accelerate migrations from on-premises, IaaS and/or relevant SQL Server imple...
5,507

SQL Server Replication as a tool to migrate very large databases

Sonali_Solanki on Feb 18 2022 02:06 AM
SQL Replication can be used as a viable tool for some migration scenarios, especially when there is a need to move trans...
4,271

Migrating Mainframe RACF user identities to Azure Active Directory Users

Ramanath_Nayak on Feb 17 2022 11:30 AM
RACF[Resource Access Control Facility] is one of the main security components which does authorization and authenticatio...
1,702

Oracle Estate Migration to SQL Server Scripting Tools

Mitch van Huuksloot on Feb 09 2022 08:06 AM
Collecting information to perform migration assessments for many servers is a painful manual effort. To alleviate some o...
5,195

SQL Server Regular Expressions Library Sample

Mitch van Huuksloot on Feb 03 2022 11:00 AM
When migrating from another database platform to SQL Server, the lack of regular expressions support can sometimes be a ...
2,163

PowerShell script to help migrate from DTU to vCore model of Azure SQL DB.

Mitch van Huuksloot on Feb 03 2022 10:44 AM
If you already own SQL Server licenses, there are cost advantages of switching from the DTU model to vCore model in the ...
4,120

Mainframe Data Modernization to Azure

Ramanath_Nayak on Jan 27 2022 03:30 PM
Data is a critical part in all Businesses. When there is modernization involved, transfer or migration of data from sour...
4,495

Using Heterogeneous Linked Servers from Azure SQL MI

Mitch van Huuksloot on Jan 27 2022 03:25 PM
Today, Azure SQL Managed Instance has the ability to create linked servers, but only to SQL Server targets. Although ext...
7,700

Copy files from Mainframe to Azure Data Platform using ADF FTP Connector

Sandip_Khandelwal on Jan 12 2022 01:08 PM
Mainframe to Azure Storage File Transfer using Azure Data Factory. 
5,978

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

narenan on Oct 21 2021 01:09 PM
In an Azure SQL Managed Instance setup with Failover Group, the schema, data, and database-level users will always be sy...

Latest Comments

anuvratB
in Mainframe files transfer to Azure Data Platform using SFTP on Dec 07 2022 08:47 AM
Hi! Sandip Great article, I am trying to implement this in my organization but facing connectivity issues with Mainframe USS and Azure storage Is there any private endpoint or anything else that needs to be enabled on the storage for the Organization Mainframe (Private Network) to connect?
0 Likes
Ramanath_Nayak
in Convert and unpack Mainframe/Midrange File System data from EBCDIC to ASCII Using Azure Data Factory on Nov 03 2022 04:30 AM
Hello Imran, Request you to please write to datasqlninja@microsoft.com. We will take it forward from there. Thanks, Ramanath.
0 Likes
ImranArshid
in Convert and unpack Mainframe/Midrange File System data from EBCDIC to ASCII Using Azure Data Factory on Nov 02 2022 11:06 AM
@Ramanath_Nayak Can you please update the 'download link' for the custom connector? Reference: "The package for custom connector has been provided in the download link. Please download it."@Venkat_Ramakrishnan kindly advise if you have this link?
0 Likes
Venkat_Ramakrishnan
in Convert and unpack Mainframe/Midrange File System data from EBCDIC to ASCII Using Azure Data Factory on Oct 10 2022 03:18 PM
Thank you, for the detailed write up with steps. This will be a very useful accelerator for data migration!!
0 Likes
AlinSelicean
in Database migrations to Azure SQL Managed Instance - Restore with Full and Differential backups on Sep 27 2022 05:25 AM
Hi AshishThis article contains misleading / wrong information. Or at least as of now (2022-09-26). NORECOVERY is not supported (or no longer) in Azure SQL Database Managed Instance: Msg 41901, Level 16, State 2, Line 39One or more of the options (norecovery) are not supported for this statement in S...
1 Likes