When working on an SSIS project with multiple developers, a merge conflict can occur in the git repository. In this tip we'll show you how to resolve this type of conflict and provide alternative options.
2021-02-22
This article is focused on beginners who have already started writing SQL queries and are now diving deep towards more data processing and complex queries in SQL. When we talk about data processing, an important concept that comes to our mind is performing ETL workloads to a data warehouse. ETL is a very complex topic […]
2021-01-26
4,844 reads
In this tip we will cover how to use merge and append in Power BI to add additional data to a dataset that can then be used in reports and visuals
2021-01-22
Introduction This article shows how to script a basic merge between two tables, without using MERGE. This can be handy when you're merging a pair of tables with hundreds of columns, since the script doesn't know anything about them. This technique introduces and populates some auditing columns (IS_DELETED, IS_INSERTED, IS_UPDATED, TRANSACTION_DATE) for each record, and runs fast. […]
2023-02-20 (first published: 2020-04-14)
18,738 reads
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Comments posted to this topic are about the item FinOps - the new name...
Comments posted to this topic are about the item Which Object Definitions Are Available?
Comments posted to this topic are about the item What's Your Theme Music?
For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)
See possible answers