Knowledge Base
Search Results ...
SQL Server 2019: Big Data Clusters Introduction
The release of SQL Server 2019 has brought about a substantial shift in the way we handle big data. With the introduction of Big Data Clusters (BDC), SQL Server 2019 provides a complete AI and big data solution. The BDC feature facilitates the deployment o[.....]
Using TVPs (Table-Valued Parameters) in SQL Server
Table-Valued Parameters (TVPs) are a powerful feature in SQL Server that allow developers to pass sets of data to stored procedures and functions. Before the introduction of TVPs in SQL Server 2008, developers had to resort to complex workarounds, such as[.....]
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[.....]