Knowledge Base
Search Results ...
Managing SQL Server Logins Across Environments
Managing SQL Server logins across different environments can be a challenging task. The environments can range from on-premise SQL Server instances to cloud-based platforms like Azure SQL. One of the critical aspects of managing SQL Server logins is ensuri[.....]
MySQL Triggers for Business Logic Enforcement
MySQL triggers are powerful SQL features that allow developers to enforce business logic at the database level. They offer the ability to automatically perform actions when certain events occur within the database. In this blog post, we will go over how yo[.....]
Calculating Running Totals with Window Functions
In this blog post, we will explore how to calculate running totals using window functions across multiple SQL technologies - SQL Server 2016 and 2017, MySQL 5.7, DB2 11.1, and Azure SQL. Window functions are a powerful tool in SQL that allow you to perform[.....]
DB2 Stored Procedures with Dynamic SQL
In today's data-driven world, stored procedures can be crucial for the efficient handling and processing of database operations. As a DBA or developer, there may be instances where you need to write a stored procedure with dynamic SQL. In this blog post, w[.....]
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,[.....]