Knowledge Base
Search Results ...
SSIS Package Protection Levels Demystified
Understanding the concept of SSIS Package Protection Levels can be a bit challenging for many database administrators. However, a comprehensive understanding of this concept is crucial for the effective management and security of your database. In this blo[.....]
Building Audit Frameworks Across Multiple Platforms
In the era of data-driven decision making, auditing your databases across multiple platforms has become a critical task. It is essential to ensure that your data is consistent, accurate, and secure. As such, we will explore how to build an audit framework[.....]
Creating SSRS Drillthrough Reports with Parameters
Welcome to SQLSupport.org! Today, we will be delving into a popular subject: creating SSRS Drillthrough Reports with parameters. These reports are valuable tools that allow users to navigate from one report to another while passing information. They provid[.....]
Using Common Table Expressions in SSIS Scripts
Common Table Expressions (CTEs) are a powerful tool in SQL that can simplify complex queries by breaking them down into more manageable pieces. In SQL Server Integration Services (SSIS) scripts, they can be used to improve readability and maintainability.[.....]
Implementing Data Governance with SQL Tags Note from the Data Whisperer
Welcome to the SQL Support blog. Today, we delve into an important element of database management, which is Data Governance. Data Governance entails the overall management of the availability, integrity, and security of the data employed in an enterprise.[.....]
Automating SSIS Package Deployment
The automation of SSIS package deployment is a critical aspect of the SQL Server Integration Services (SSIS) framework that can significantly improve efficiency and productivity. SSIS is a tool provided by Microsoft that enables complex data transformation[.....]
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[.....]