2025-04-09
1,784 reads
2025-04-09
1,784 reads
A short look at the differences in UNION and UNION ALL in a SELECT query.
2025-04-07
3,998 reads
2025-04-02
1,920 reads
Regular expressions (REGEX) let you adaptively investigate, employ, and authenticate text data. This makes it easy to search for simple or complex string patters. There is no direct way to do this in SQL Server, but in this article we look at some SQL functions you can create to emulate regex like functionality.
2025-03-28
Learn about the new string similarity functions in Azure SQL Database.
2025-03-28
4,839 reads
2025-03-26
1,740 reads
2025-03-21
400 reads
2025-03-19
515 reads
2025-03-17
469 reads
2025-03-14
351 reads
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
On May 8, 2025, we hosted our first official event in Switzerland at Prime...
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
Hi, I would love to hear if anyone can tell me why a CAST...
hi, one of our sister division's erp extract view is going thru at least...
hi our corp dw load sqlagent job goes to the next step on the...
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers