Latest Blog Articles
Introduction
Query store (QDS) is great at collecting performance tuning telemetry, and to achieve this it uses resources including disk and memory. While the best practices documentation looks at ...
Jan 28, 202514Views
0likes
0Comments
2 MIN READ
Deploying a SQL VM using a marketplace image can sometimes lead to deployment failures, particularly when the selected size for the tempdb exceeds the capacity of the Windows OS disk. This issue aris...
Jan 21, 2025176Views
0likes
0Comments
3 MIN READ
Transferring an Azure SQL Database between tenants involves several steps, but it can be done efficiently without changing your connection strings. There are several reasons why an organization might...
Jan 13, 2025256Views
2likes
0Comments
5 MIN READ
Why Post-Migration Optimization Matters
For customers migrating from Oracle to Azure SQL Databases, understanding Azure SQL optimization techniques can make a significant difference in overall...
Jan 13, 2025165Views
2likes
0Comments
Introduction
Mainframes are purpose-built systems with specialized hardware and software designed for high-throughput, reliability, and scalability. They excel at handling large, transaction-heavy ...
Jan 02, 2025183Views
0likes
0Comments
In today’s cloud environment, security and efficient management of storage resources are paramount for organizations. Azure Blob Storage, known for its scalability and robust security, is a popular s...
Dec 17, 2024237Views
3likes
0Comments
Initializing SQL Server Transactional Replication with default settings can be significantly slow when working with large table migrations. Increasing MaxBCPThreads allows SQL Server to perform multi...
Dec 17, 2024165Views
2likes
0Comments
Introduction
Migrating from Oracle to Azure PostgreSQL is a complex endeavor with multiple coordinated steps. Ora2Pg is a widely used tooling to accelerate the migration for both schema conversion ...
Nov 13, 2024566Views
19likes
7Comments
Customers modernizing their Oracle, Mainframe/Midrange Db2, Sybase and other databases to Azure SQL often use Azure Data Factory (ADF) for data transfer. For large datasets, an initial copy is made a...
Nov 12, 2024244Views
4likes
0Comments
Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud. Though Azure SQL is built upon the familiar SQL Server engine, there are...
Oct 16, 2024971Views
6likes
0Comments
Resources
Tags
- database platform cse45 Topics
- database platform cse – sql38 Topics
- Database Platform CSE – Mainframe13 Topics
- database platform cse – oracle13 Topics
- Database Platform CSE – Db212 Topics