How much database normalization is enough?
Normalization is important for relational databases, but sometimes too much of a good thing can be bad.
2018-07-23
2,460 reads
Editorials
The Challenge of Failure and of Being Unwired
About to embark on a vacation, Steve talks about the difficulty in letting go.
2018-07-20
76 reads
2018-07-19
71 reads
2018-07-18
58 reads
2018-07-17
80 reads
The Age of Multiple Databases
There are lots of databases to choose from. Steve discusses using more of them in your work.
2018-07-16
105 reads
2018-07-13
73 reads
2018-07-12
107 reads
Stairway to AlwaysOn Crossword
This crossword puzzle is based on the contents of the Stairway to AlwaysOn.
2018-07-11
170 reads
2018-07-10
69 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
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...
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