Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform
This next articles gives you a few quick ways to access data in remote storage.
Using REGEXP_COUNT to Count Strings in SQL Server 2025
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?
GPX distance and time analysis in SQL Server
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.
The DBA is Dead; Long Live the DBA
There have many many times when a company or individual has thought that DBAs aren't needed. Steve doesn't think that has ever been true, nor will it be anytime soon.
Common Misconceptions About Microsoft Certification Exams
An experienced exam writer explains common misconceptions about Microsoft certification exams, question design, preparation, and real-world expectations.
Optimism Without Illusion or Why AI Needs Blunt Technologists
There is a temptation, especially in technology, to mistake momentum for maturity.
How Database Professionals Sent a Million Emails a Day from SQL Server
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 […]
How Filters and Sorting can Derail SQL Pagination Performance
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.
Tame Those Strings Part 6 - Bending Results
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
Blogs
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers