Knowledge Base
Search Results ...
Temporal Tables for Change Tracking in SQL Server
SQL Server 2016 introduced Temporal Tables, a game-changing feature for tracking historical data changes. Temporal tables, also known as system-versioned tables, keep a full history of data changes and allow easy point-in-time analysis. This is an essentia[.....]
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[.....]
Creating Materialized Query Tables in DB2
In the world of databases, sometimes we need to process complex queries that involve joining multiple tables, grouping data, or performing extensive computations. These operations can be time-consuming, especially if dealing with large volumes of data. For[.....]
SSIS Error Handling with Row Redirects
SQL Server Integration Services (SSIS) is a powerful tool that allows developers to perform ETL (Extract, Transform, Load) operations, as well as data integration, transformation, and migration tasks. SSIS provides a wide range of tools to build efficient[.....]
Performance Impacts of Scalar Functions
Scalar functions in SQL Server can have a significant impact on the performance of your database operations. They are a type of function that return a single value, rather than a table. This can be useful in certain situations, but it also has some drawbac[.....]
Using TRY_CONVERT in SQL Server for Safer Casting
SQL Server is a highly robust and versatile database management system, employed by businesses of all sizes across the globe. One of the functionalities that sets it apart is its ability to handle data conversion errors more gracefully. In this blog post,[.....]
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[.....]