Knowledge Base
Search Results ...
Using SQLCMD Variables in Deployment Scripts Note from the Data Whisperer
SQLCMD mode in SQL Server 2019 is an interactive command line tool for SQL Server that allows users to execute Transact-SQL commands directly, execute script files, and execute commands in an operating system. One of the powerful features of SQLCMD mode is[.....]
Using SSIS Script Task for REST API Calls
In today's data-driven world, integrating and synchronizing data across various platforms is a common necessity. With SQL Server Integration Services (SSIS), you can accomplish this task with ease. One of the powerful features of SSIS is the Script Task, w[.....]
Staging Strategies in ETL Using SSIS
Extract, Transform, Load (ETL) is a critical aspect of the data pipeline in any business. When working with SQL Server Integration Services (SSIS), understanding the best staging strategies is crucial to ensure efficient data flow, performance optimization[.....]
Writing Cross-Platform SQL Compatible Queries
SQL, short for Structured Query Language, has been the de facto standard for interacting with relational databases for many years. However, with the advent of numerous database management systems like SQL Server 2019, MySQL 8.0, DB2 11.5, Azure SQL, and Az[.....]
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[.....]
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[.....]
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[.....]
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[.....]
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[.....]