Knowledge Base
Search Results ...
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[.....]
Implementing Service Accounts for SQL Server Security
SQL Server is a popular relational database management system, and its security should not be taken lightly. One of the best practices to ensure the security of your SQL Server is by implementing service accounts. In this blog post, we will provide a detai[.....]
DB2 Sequence Objects in Multi-Node Environments
In a multi-node environment, where data is distributed across several nodes for better performance and redundancy, managing Sequence Objects becomes a matter of utmost precision. In this blog post, we will delve into the intricacies of handling DB2 Sequenc[.....]
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[.....]
MySQL Full Text Search vs LIKE
In the realm of database management systems, text searching is an essential feature that aids in data retrieval. Two common methods for executing text searches in MySQL are Full Text Search and the LIKE operator. Each has its advantages and disadvantages,[.....]
Monitoring Database Growth Over Time with T-SQL
One of the most critical tasks of a database administrator (DBA) is monitoring and managing database growth. It can be daunting, especially when dealing with large databases and complex systems, like SQL Server 2016, SQL Server 2017, MySQL 5.7, DB2 11.1, o[.....]
SQL Server Cluster Configuration on Windows Server 2016
SQL Server cluster configuration is a crucial step for any organization that depends on SQL Server for data management. In this blog post, we will guide you through the process of setting up a SQL Server cluster on Windows Server 2016. We will be focusing[.....]
Dynamic SQL in SSIS Packages
Dynamic SQL is a powerful tool that can significantly enhance the functionality of SQL Server Integration Services (SSIS) packages. It allows SQL and T-SQL scripts to build and execute SQL statements dynamically at runtime. This feature provides a great de[.....]
DB2 Table Reorganization for Performance Gains
In the era of data-driven decision making, database performance is of paramount importance. One such performance optimization technique is table reorganization. In this blog post, we will be focusing on DB2 table reorganization and how it can lead to signi[.....]