Knowledge Base
Search Results ...
SQL Server Database Projects with Visual Studio
SQL Server Database Projects offer a robust and integrated environment for database developers to work on their data-tier applications using Visual Studio. With support for SQL Server 2019, Azure SQL, Azure Synapse, MySQL 8.0, and DB2 11.5, SQL Server Data[.....]
MySQL Horizontal Partitioning in Large Databases
One of the challenges that administrators face as databases grow is managing the performance and storage of these large systems. For databases with large amounts of data, horizontal partitioning can be a great solution. Horizontal partitioning involves div[.....]
Building a DevOps Pipeline for SSIS and SSRS
Building a DevOps Pipeline for SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) involves a combination of robust database management systems and cloud services. The focus here is on SQL Server 2019, MySQL 8.0, DB2 11.5, Azure[.....]
SSRS Report Caching and Snapshots Explained
As a SQL Server Reporting Services (SSRS) developer or administrator, one of your challenges could be optimizing report performance. Two useful features to help with this are report caching and snapshots. Both aim to minimize the time it takes to generate[.....]
DB2 Triggers for Audit Enforcement
Triggers are an essential component of database management, providing an automated response to events, such as table updates, that can aid in maintaining data integrity and enforcing business rules. In this blog post, we will focus on DB2 triggers and how[.....]
SQL Server Ledger Tables for Immutable Audit Trails
In the ever-evolving world of data management and database administration, maintaining an accurate and immutable audit trail is crucial. With the help of Ledger tables in SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Azure Synapse, creating an uncha[.....]
MySQL HeatWave In-Memory Query Acceleration
The emergence of Oracle's MySQL HeatWave, an integrated, high-performance query accelerator for MySQL Database Service, has raised the bar in the world of SQL performance. This revolutionary technology continues to push the boundaries of what we thought wa[.....]
SSIS ForEach Loop Containers Explained
In the world of SQL Server Integration Services (SSIS), the ForEach Loop Container is a powerful tool that enables users to iterate through a collection of objects or data rows. This is particularly useful when you need to execute a task multiple times wit[.....]
Using Azure Data Studio for Cross-Platform SQL Work Note from the Data Whisperer
The world of database management is rapidly evolving and with it comes the need for powerful tools that can handle these changes. One such tool is Azure Data Studio, a cross-platform database tool for data professionals using the Microsoft family of on-pre[.....]
DB2 Query Parallelism for Faster Results
In the world of data management, speed and efficiency are of utmost importance. As database administrators, we're always looking for ways to optimize our systems to deliver faster results. One way to achieve this is through query parallelism. This approach[.....]