Recent Blogs
Implementation for SQL DB PITR using the portal
Azure policy covers much more than SQL; here we are using a small portion of its capabilities. The bits we are using are
A policy definition, on ...
Sep 08, 2025171Views
1like
0Comments
Introduction
When migrating partitioned tables from Oracle to Azure PostgreSQL Flexible Server, many customers prefer to preserve their existing Oracle table design exactly as defined in the origin...
Aug 20, 2025276Views
0likes
0Comments
10 MIN READ
Overview
This blog dives into the mechanics of implicit data type conversions and their impact during the post-migration performance optimization phase of heterogeneous database migrations. Dr...
Aug 20, 2025249Views
1like
2Comments
Introduction
Enterprises upgrading legacy databases often face challenges in migrating complex schemas and efficiently transferring large volumes of data. Transitioning from SAP ASE (Sybase ASE) to...
Aug 14, 2025276Views
1like
0Comments
Introduction
Transactional replication is a SQL Server feature that copies and synchronizes data and database objects across servers. It generally begins with a snapshot of the publication database...
Jul 16, 2025313Views
0likes
0Comments
Migrating data across SQL platforms, be it SQL Server, Azure SQL Database, Managed Instance, or SQL Server on IaaS, often involves operational complexity and potential downtime. Azure Data Factory (A...
Jul 01, 2025668Views
2likes
0Comments
If you have been relying on Oracle Database as your primary system for analytics and the generation of MIS reports, you are probably familiar with the use of temporary tables within stored procedures...
Jun 20, 2025328Views
1like
0Comments
Introduction
Mainframe/Midrange data is often stored in fixed-length format, where each record has a predetermined length, or variable-length format, where each record’s length may vary. The data i...
May 09, 2025646Views
0likes
0Comments
Introduction
As enterprises migrate mission-critical workloads from heterogeneous databases like Oracle to Azure Database for PostgreSQL Flexible Server, managing large datasets while ensuring comp...
Apr 07, 2025528Views
11likes
3Comments
Our team has a blog on this site which describes the process of moving an Azure SQL DB from one tenant to another. When doing this, the Entra (was AAD) logins and users defined in the database will n...
Apr 02, 2025252Views
1like
0Comments
Resources
Tags
- database platform cse60 Topics
- database platform cse – sql49 Topics
- database platform cse – oracle17 Topics
- database platform cse – mainframe14 Topics
- database platform cse – db214 Topics