Knowledge Base
Search Results ...
MySQL Stored Routines with OUT Parameters
In the world of SQL development, stored procedures are a fundamental tool that every developer should have a good understanding of. They are used to encapsulate a sequence of operations into a single executable unit. Not only do they enhance the performanc[.....]
Writing SQL Audit Triggers for Compliance
In today's data-driven business world, it is more crucial than ever to ensure that your data is secure and compliance is maintained. SQL Server, as one of the most popular database platforms, offers various features to help you achieve this. One such featu[.....]
SQL Server Extended Events vs Profiler
In the world of SQL Server, the decision between using SQL Server Profiler and SQL Server Extended Events is a critical one. While both tools provide profound insights into your database's performance, they differ significantly in their capabilities and us[.....]
DB2 Column Masking for Sensitive Data
In today's data-driven world, sensitive data protection is of utmost importance. One of the effective methods to secure sensitive data in databases is data masking, specifically column masking. For this post, we will focus on column masking in IBM's DB2 11[.....]
Generating Excel Files from SSIS
As data professionals, we are frequently tasked with exporting data from SQL Server and other databases into Excel files. In this blog post, we will explore how to generate Excel files from SQL Server Integration Services (SSIS), using SQL Server 2016, SQL[.....]
SSRS Subreports and Performance Optimization
In the world of business intelligence, SSRS (SQL Server Reporting Services) is a powerful tool that allows users to create, deploy, and manage reports. One feature of SSRS that is often used, but sometimes misunderstood, is the concept of subreports. Subre[.....]
MySQL Replication Monitoring Scripts
Replication is a critical aspect in database management systems, providing data availability, system scalability and load balancing; and MySQL is no exception. With MySQL 5.7, we've seen the introduction of enhanced features that make replication monitorin[.....]
Query Store for Historical Plan Analysis Note from the Data Whisperer
Query Store, a feature introduced in SQL Server 2016, has revolutionized how DBAs perform historical plan analysis. Before this feature, DBAs had to rely on plan cache to analyze execution plans, which could be quite challenging given that the plans could[.....]
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[.....]