2007-12-20
1,903 reads
Editorials
Obfuscation
Test data is critical to being sure your application works, but is production data ok to use in test environments?
2007-12-19
517 reads
Data Ownership
Who owns the data that we generate ourselves? It's not as easy to answer that as you think.
2007-12-18
54 reads
2007-12-17
147 reads
Better Licensing
Licensing SQL Server used to be easy and could be again, though it is still better than licensing Oracle.
2007-12-17
245 reads
What Would You Do?
If someone acts suspicious at work, do you report them? What if it's the CIO? What if data security is involved?
2007-12-14
101 reads
Another Reason to Hate Ads
Malicious code embedded inside advertisements served on the web. What's next?
2007-12-13
70 reads
The Downside of Real Time
Everyone wants real time reporting, or do they? Steve Jones talks about some of the downsides of implementing such a system.
2007-12-12
121 reads
Do We Need a PK?
A primary key is a must for every table. Or is it? Steve Jones examines the question.
2007-12-11
465 reads
Hipp, Hipp, Hooray
In an age where commercial interests seem to trump all, it's nice to see someone delivering content out there for free.
2007-12-10
125 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