Knowledge Base
Search Results ...
Using OPENJSON to Shred JSON in SQL Server 2016+
With the increasing popularity of JSON (JavaScript Object Notation) as a data interchange format, SQL Server 2016 introduced built-in support for JSON to efficiently deal with JSON data. One of these features is OPENJSON, a table-valued function that parse[.....]
DB2 Buffer Pool Tuning Tips
Buffer pool tuning is a core aspect of database administration, which ensures that the database performs optimally. When it comes to IBM DB2, buffer pool tuning can significantly increase the speed and efficiency of your database. This blog post will provi[.....]
Building ETL Restartability in SSIS
Building ETL (Extract, Transform, Load) restartability into SSIS (SQL Server Integration Services) is a key factor in ensuring the robustness and reliability of your data integration processes. In today’s blog post, we will focus on building ETL restartabi[.....]
MySQL Partitioning Techniques
In the world of databases, partitioning is a common technique used to manage large tables and indexes. It breaks down data into smaller, more manageable pieces, called partitions. Each partition can be managed and optimized independently. This article will[.....]
Using MERGE Statement in T-SQL ETL Loads
The MERGE statement, introduced in SQL Server 2008, is a powerful tool that simplifies the process of performing insert, update, and delete operations in a single statement. It is particularly useful in ETL (Extract, Transform, Load) processes, where data[.....]
Understanding SQL Server Auto Stats Behavior
In the world of database management systems, understanding how systems optimize performance is key to maintaining efficient operations. One of the key features of SQL Server 2016, SQL Server 2017, MySQL 5.7, DB2 11.1, and Azure SQL that assists in performa[.....]
SSRS Custom Code for Advanced Visuals
The SQL Server Reporting Services (SSRS) is a flexible and robust platform that allows developers to create comprehensive, data-driven solutions. Advanced visualization features in SSRS allow you to create reports that are both informative and visually app[.....]
Managing Null Logic in SQL Joins Note from the Data Whisperer
Welcome to SQLSupport.org's blog post where today we'll discuss an integral part of SQL programming: managing null logic in SQL joins. The handling of null values is often a pivotal point in database management and it's essential to understand how differen[.....]
Temporal Tables for Change Tracking in SQL Server
SQL Server 2016 introduced Temporal Tables, a game-changing feature for tracking historical data changes. Temporal tables, also known as system-versioned tables, keep a full history of data changes and allow easy point-in-time analysis. This is an essentia[.....]
Version Control for SQL Objects Using GIT
In the realm of database management, the importance of version control cannot be overstated. It is the catalyst for a streamlined workflow, ensuring that modifications in the database are tracked, facilitating collaboration among team members, and providin[.....]