BETWEEN the two of us
BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of BETWEEN and also could be implemented.
2021-12-15
BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of BETWEEN and also could be implemented.
2021-12-15
2021-12-08
629 reads
Got a message from the Operation team as below Hi Harsha, I'm seeing a larger than normal rate of change for a week day on the backups for the SQL2000 servers. Did anything run differently yesterday compared to Monday? I have 22 sql servers and all the Weekend and Monthly backups goes to the location […]
2021-12-03
526 reads
Learn about the changes to the STRING_SPLIT function in Azure SQL Database that allows you to specify ordinal position of the output.
2021-12-03
Introduction In SQL Server 2016, Microsoft introduced a new feature called dynamic data masking, which allows you to mask the values of certain columns and keep that data hidden from certain users, without having to modify your applications. Let's take a look at how SQL Server does data masking, and compare it to the way Gallium Data […]
2021-12-03
1,829 reads
Markdown documents are becoming increasingly more popular and relevant with the emergence of notebooks. Markdown is a markup language for creating formatted text. It is widely used in tools for collaboration, tools for creating documentation and notebooks. Formatting is easy to understand, readable, simple to adopt, and agnostic. I can use a markdown document on […]
2021-11-29
10,282 reads
2021-11-29
660 reads
In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more.
2021-11-10
2021-10-27
536 reads
2021-10-25
683 reads
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
By Steve Jones
This is my last week of the year working (I guess I come back...
Mobile game development has become a cornerstone of the entertainment industry, transforming creative ideas...
Mobile app development has become a cornerstone of modern business strategies, enabling companies to...
I have listed the event names present in my system_health extended event report. Based...
Which of these indexes is superseded by another?
See possible answers