Knowledge Base
Search Results ...
SQL Server 2022: Memory Grant Feedback v2
With the release of SQL Server 2022, a multitude of new and enhanced features have been introduced. Among them, one that particularly stands out is the improved version of Memory Grant Feedback – version 2. This feature, which was initially introduced in S[.....]
DB2 Replication Setup Using Q Replication
In an increasingly data-driven world, efficient database replication is pivotal. DB2 Q Replication, a technology provided by IBM, enables high-volume, low-latency, data capture and delivery among a variety of heterogeneous data sources. In this blog post,[.....]
SSIS Incremental Extract with Change Data Capture
Welcome to SQLSupport.org's blog. Today, we will delve into the world of SSIS (SQL Server Integration Services) and its role in implementing an incremental extract using Change Data Capture (CDC) in SQL Server 2022. In the landscape of Big Data, CDC plays[.....]
MySQL Innodb Redo Log Configuration Tuning
Every database administrator knows that tuning the MySQL InnoDB Redo Log is a critical step in optimizing database performance. The Redo Log in MySQL InnoDB engine is designed to ensure data integrity by recording changes made to data, which can be used to[.....]
SQL Server Stretch Database for Historical Data
Welcome to SQLSupport.org, where we provide you with the latest news and best practices in the SQL world. Today, we'll be discussing the SQL Server Stretch Database, an innovative feature in SQL Server 2022 that is designed to store and manage your histori[.....]
DB2 Error Logging with ADMIN_CMD and Event Monitors
In the world of database management, error logging has always been a crucial aspect of maintaining a healthy and efficient system. It is an invaluable troubleshooting tool, allowing administrators to gain insights into the inner workings of their databases[.....]
MySQL Derived Tables vs Common Table Expressions
In the realm of database management, ongoing developments such as SQL Server 2022, Azure SQL, Microsoft Fabric, Delta Lake, OpenAI + SQL, and Databricks continuously bring forth enhanced features and tools that enable us to handle data more efficiently. On[.....]
SSRS Custom Code for Conditional Formatting
In the world of SQL Server Reporting Services (SSRS), the need for customization is often inevitable, especially when it comes to creating dynamic and interactive reports. One of the most useful custom features is conditional formatting, which allows us to[.....]
SQL Server Row-Level Security with Dynamic Filters Note from the Data Whisperer
Welcome to SQLSupport.org, the home of the dedicated SQL Server community. I am your Data Whisperer, here to guide you through the magical realm of SQL Server 2022 and Azure SQL. Today, we delve into the intricacies of SQL Server Row-Level Security (RLS) w[.....]
DB2 Index Design for OLAP vs OLTP Workloads
Welcome to SQLSupport.org! Today, we are diving into the intriguing world of DB2 index design, focusing on the contrasting necessities of Online Analytical Processing (OLAP) and Online Transaction Processing (OLTP) workloads. Correct index design is pivota[.....]