Knowledge Base
Search Results ...
SSIS Package Logging Strategies
In the world of SQL Server Integration Services (SSIS), logging is paramount. It is the primary mechanism by which ETL processes can be audited and errors can be diagnosed. SQL Server 2019 provides robust and flexible logging options, allowing you to choos[.....]
Handling NULLs in SSRS Aggregates
Aggregating data is a common operation in SQL Server Reporting Services (SSRS), but handling NULL values in these aggregations can often be a challenge. NULLs can sometimes skew results or create inconsistencies, especially when working with SUM and AVG fu[.....]
Using SQL Profiler Filters Effectively
SQL Profiler is an invaluable tool for database administrators and developers. It helps in monitoring and diagnosing problems in SQL Server, MySQL, DB2, Azure SQL, and Azure Synapse. One of the most powerful features of SQL Profiler is the ability to set f[.....]
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[.....]