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?
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.
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.
An experienced exam writer explains common misconceptions about Microsoft certification exams, question design, preparation, and real-world expectations.
There is a temptation, especially in technology, to mistake momentum for maturity.
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 […]
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.
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Comments posted to this topic are about the item When the Token Meter is...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers