The Gambler
If you are the type of person that doesn't run DBCC checks, Steve Jones thinks you're a gambler. And you might think about attending SQL Intersection next month in Vegas.
2013-03-14
221 reads
Editorials
Resetting DMVs
Steve Jones asks the question why so much data in SQL Server is cleared when we restart an instance.
2013-03-13
183 reads
Self Describing Databases
Today Steve Jones gives his vision of the database in the future. He hopes that databases contain more information about not only their objects, but their needs, like backups and maintenance.
2013-03-12
364 reads
Cloud Services. Waiting for the 'paint to dry'?
Despite recent 'outages', The canny CIO will make use of the obvious advantages of public cloud services where it risks neither security or availability. Adoption of the Cloud services and platforms is going to be most effective where the Cloud’s advantages of rapid scalability can be harnessed.
2013-03-11
82 reads
Who Built This Thing?
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest. This editorial was originally published on May 20, 2008. It is being re-run as Steve is on vacation.
2013-03-11 (first published: 2008-05-20)
408 reads
2013-03-08 (first published: 2008-05-09)
179 reads
Productivity and Accountability
The recent decision by Yahoo to end telecommuting elicits some comments from Steve Jones on the topic of remote work.
2013-03-07
162 reads
Two Plugs Away
The culture and practices at Valve are interesting to Steve Jones, but the desks really caught his eye.
2013-03-06
162 reads
Data We Don't Want
There's potentially an exploit that can download lots of data to a machine. This shouldn't be a concern for servers, but you never know.
2013-03-05
196 reads
Data Loss
A new study shows potential corruption issues with solid state drives when power is cut under a load. That can have implications for data professionals as more databases incorporate SSD storage.
2013-03-04
151 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