This article reveals a critical SQL Server flaw: attackers can weaponize Date Correlation Optimization (DCO) views in restored backups
2026-02-13
This next articles gives you a few quick ways to access data in remote storage.
2026-02-11
2,077 reads
We need to find out how many times certain strings appear in a column. We’ve used the LEN and REPLACE functions for years, but recently heard about REGEXP_COUNT and want to evaluate it, since we plan to upgrade to SQL Server 2025. How can we test this new feature?
2026-02-11
In this article we do a comparative analysis of the distance covered by two athletes during a race using the data of their GPX files.
2026-02-09
1,833 reads
An experienced exam writer explains common misconceptions about Microsoft certification exams, question design, preparation, and real-world expectations.
2026-02-09
This is part of a look back at the history of SQL Server Central as a part of our 25-year celebration in Feb 2026. "They want how much?" That was a question I got from Andy one afternoon as we discussed how we were going to manage the growth of SQL Server Central. I had […]
2026-02-06
2,470 reads
In my previous tip, Pagination Performance in SQL Server, I showed how to make SQL pagination more predictable – turning O(n) into O(1). I materialized and cached row numbers to page through instead of calculating them on every request. It wasn’t the whole story, though; real pagination queries rarely get to sort without filtering. Users always want more control, and filtering can threaten that predictability.
2026-02-06
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
2026-02-05 (first published: 2001-07-04)
9,118 reads
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
2026-02-05 (first published: 2004-03-25)
9,171 reads
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
2026-02-05 (first published: 2002-04-04)
7,781 reads
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Comments posted to this topic are about the item Making an Impression
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers