Knowledge Base
Search Results ...
Avoiding Parameter Sniffing in Stored Procedures
One of the performance aspects to consider when working with SQL Server, MySQL, DB2 and Azure SQL is the issue of parameter sniffing in stored procedures. Parameter sniffing is a process where the SQL Server's query optimizer uses the parameter values prov[.....]
Dynamic Data Masking for SQL Server Security
Dynamic Data Masking (DDM) is a security feature that Microsoft introduced with SQL Server 2016. It is designed to limit the exposure of sensitive data to non-privileged users by masking it. DDM is a policy-based security feature that hides the sensitive d[.....]
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[.....]