Knowledge Base
Search Results ...
Azure SQL Database Failover Group Implementation
The Azure SQL Database provides a fully managed, scalable and intelligent relational database service. One key feature of Azure is its built-in support for high-availability and disaster recovery. The feature we'll be focusing on today is the Azure SQL Dat[.....]
SSIS Logging with Custom Event Handlers
In the world of ETL processes, logging plays a crucial role in understanding the flow of data, identifying bottlenecks and resolving issues. SQL Server Integration Services (SSIS) provides a robust logging mechanism, but at times, the default logging optio[.....]
DB2 Query Execution Control with FETCH FIRST ROW ONLY
As database professionals, we are often tasked with optimizing SQL statements for more efficient execution. This is particularly crucial when dealing with large data sets where the difference between an optimized and unoptimized query can mean hours of pro[.....]
MySQL Replica Lag Monitoring and Resolution
SQL replication is a critical feature for database administrators (DBAs) to ensure data availability and consistency across multiple environments. However, one of the most common issues faced during the replication process is replica lag. In this post, we[.....]
SQL Server 2022: Built-in Query Hints for Stability
Welcome to SQLSupport.org, the forum where SQL Server enthusiasts, both budding and veteran, come together to explore the fascinating world of SQL Server. Today, we delve into the built-in query hints of SQL Server 2022, the big brother in the SQL Server f[.....]
Using JSON_TABLE in MySQL 8.0 Note from the Data Whisperer
Welcome to another insightful blog from SQLSupport.org. In this post, we explore the use of JSON_TABLE in MySQL 8.0. JSON_TABLE is a powerful function that enables the conversion of JSON data into tabular format for easier querying. It is part of MySQL's c[.....]
SQL Server Dedicated SQL Pools vs Serverless
In the world of databases, SQL Server has long been a go-to solution for many organizations. With the release of SQL Server 2019, Microsoft introduced a slew of new features, including big data clusters and data virtualization. Alongside these, Azure SQL a[.....]
DB2 JCC Driver Performance Tips
Welcome to SQLSupport.org, your one-stop destination for all your SQL Server needs. Today, we're going to provide some performance tips for the DB2 Java Connector (JCC) driver, a powerful middleware that facilitates seamless integration between Java applic[.....]
SSIS vs Azure Data Factory: ETL Migration Considerations
As organizations move their data to the cloud, they are faced with the decision of choosing the right data integration tool. Two popular options are SQL Server Integration Services (SSIS) and Azure Data Factory (ADF). Both serve as ETL (Extract, Transform,[.....]
SQL Server Database Project Deployment with Azure DevOps
The integration of SQL Server Database Project with Azure DevOps has revolutionized the way we handle database operations. This fusion provides a seamless and efficient environment for managing and deploying your database projects. Let's explore this integ[.....]