Gail Shaw is often left bewildered by the weird and wonderful data types people choose for their tables, when storing something as simple as a telephone number or a date.
2024-07-12 (first published: 2015-02-02)
707 reads
2024-07-10 (first published: 2024-07-08)
174 reads
Steve has a few thoughts on the removal of Stretch Database from the SQL Server world.
2024-07-10
306 reads
Schools often lack resources and struggle to protect themselves. An interview shows one district doing well, with some lessons for those of us in other organizations.
2024-07-06
70 reads
2024-07-05
147 reads
Today Steve asks for the ways in which you use xp_cmdshell in your environment.
2024-07-03
253 reads
Steve notes that we're always better doing things better the first time. That takes some effort.
2024-07-01
162 reads
I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They […]
2024-06-29
109 reads
Monitoring and observability are becoming more important in today's 24x7x365 environment for applications. Steve asks what data helps you solve problems today. Tell us what's important to you.
2024-06-28
199 reads
When and where should you test code? Steve has a few thoughts when we consider the database as a crucial part of our software.
2024-06-26
178 reads
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers