Knowledge Base
Search Results ...
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[.....]
Version Control for SQL Objects Using GIT
In the realm of database management, the importance of version control cannot be overstated. It is the catalyst for a streamlined workflow, ensuring that modifications in the database are tracked, facilitating collaboration among team members, and providin[.....]
Advanced Lookup Transformations in SSIS
In the world of data integration and transformation, lookup transformations are one of the most commonly used tasks. SQL Server Integration Services (SSIS) provides a powerful and flexible platform for performing these operations. In this blog post, we wil[.....]
Using SQLCMD for Automated Deployments
Welcome to SQLSupport.org! This blog post is going to guide you through using SQLCMD for automated deployments with a focus on SQL Server 2016, SQL Server 2017, MySQL 5.7, DB2 11.1, and Azure SQL. SQLCMD is a versatile tool which allows developers and data[.....]
SSRS Expressions for Conditional Formatting
SQL Server Reporting Services (SSRS) is a comprehensive tool that allows developers to create, deploy, and manage reports for business data. An essential part of creating meaningful and visually appealing reports is the use of expressions for conditional f[.....]
Partition Switching in Large Fact Tables Note from the Data Whisperer
As data warehouses continue to balloon with the exponential rise in data generation, SQL Server admins are faced with the challenge of optimizing their environment for improved performance. One such optimization technique that has proven useful for large f[.....]
Common Table Expressions for Hierarchical Queries
Understanding and navigating hierarchical relationships in data is a common challenge for many database professionals. Whether you're dealing with organizational structures, product categories, or nested comments, hierarchical data can be difficult to wran[.....]
SSIS Lookup Cache Modes and Their Impact
In the realm of SQL Server Integration Services (SSIS), the Lookup transformation is an essential tool for comparing data sources. It allows for the comparison of an input column from the data source to a column from the reference data set. The Lookup tran[.....]
SQL Agent Job Schedules for Enterprise Workflows
SQL Agent Job Schedules are a fundamental part of managing enterprise workflows, especially when it comes to automating tasks and ensuring mission-critical operations are executed efficiently. SQL Agent Job Schedules, available in SQL Server 2016, SQL Serv[.....]
Implementing Data Quality Audits via SSIS
Data quality becomes increasingly important in an age where data is the primary currency for businesses. Ensuring data quality is fundamental to the reliability of business decisions, and to the overall success of data-driven strategies. In this post, we w[.....]