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,754 reads
This article explores three key areas that need to be considered to make digital transformation occur: as a response to current changes, in preparation for future changes and to enhance the human experience. Read on to find out more!
2023-02-20
Learn about the new functions JSON_OBJECT and JSON_ARRAY to work with JSON formatted data in SQL Server.
2023-02-20
2023-02-17 (first published: 2023-02-10)
11,411 reads
A list of builds for SQL Server 2014, through CU4 for SP2 and CU11 for SP1.
2023-02-17 (first published: 2015-02-23)
19,459 reads
SQL Bits is coming to Wales, home of dragons and D&D, and we’re happy announce we’re supporting them as platinum sponsors again this year. Meet us at our Red Keep and catch sessions by noble Fighter Grant Fritchey, Sorcerer Steve Jones, and more beloved Redgate Paladins and Druids. For a magical 10% discount on your ticket, use 10REDGATE from our spell book.
2023-02-17
This resource includes several links to related to...
2023-02-17
2023-02-15
4,314 reads
A quick demonstration of using Flyway with Oracle, for those of a nervous disposition. We'll use Flyway to run some migrations on an Oracle Autonomous Database, building the initial version of the database then filling it with development data.
2023-02-15
Once data is in a table it needs to be maintained....
2023-02-15
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers