Growing and Changing
It can be hard to let go of old knowledge and try something new, but we need to find a balance.
2019-08-26
179 reads
Editorials
SQL Tamagotchi! Mini-Servers as Database Pets
If you've ever stuffed SQL Server onto a Raspberry Pi 4 and given it a pet name, don't worry, you're not alone…
2019-08-24
297 reads
Waits and Queues
This week Steve is wondering if you know how to use waits and queues for troubleshooting.
2019-08-23
645 reads
Don't Get On This Page
There is a page where GDPR fines are tracked. None of us want to get on that page.
2019-08-22
429 reads
2019-08-20
432 reads
2019-08-19
206 reads
Lots of data in RAM
I remember buying my first computer after college. At the time I was working part time and in graduate studies part time. My aging high school era Apple II wasn't capable of handling the load, not to mention its 300baud modem wasn't a lot of fun. I could likely have gotten a faster modem with […]
2019-08-17
245 reads
Muting the Immutable
Phil Factor on dealing with "immutable" domain data during database development and deployment.
2019-08-16 (first published: 2016-01-18)
425 reads
Demo Data for Everyone
Steve thinks having a known set of data for your system is one way to improve your software development process and make salespeople happy.
2019-08-14
577 reads
Organized Learning
Learning to become a DBA is often a winding and twisty road. Steve has a little advice today.
2019-08-13
252 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers