2025-12-31
1,128 reads
humor
2025-12-29 (first published: 2025-12-24)
573 reads
SQL Art: I Made a Christmas Card In SSMS
A little Christmas fun for you using the spatial features in SQL Server and SSMS.
2025-12-24
4,101 reads
2025-11-28
62 reads
Custom Statistics Distributions in SQL Server 2022
You can create custom statistics distributions, sampling, and histograms in SQL Server 2022 with a new trace flag
2024-04-01
1,413 reads
2024-04-01
465 reads
CosmosDB APIs Inside SQL Server 2024
New enhancements in SQL Server 2024 will allow MongoDB and Cassandra clients to store their data in a SQL Server database, in native NoSQL format.
2024-04-01
205 reads
2023-12-29
442 reads
2023-12-25
421 reads
Why Haven’t You Disabled SA? Wrong Answers Only.
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong answers only.” The results were pretty funny:
2023-12-01
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers