Anonymous Research
Anonymizing data is hard, and Steve Jones talks about some of the problems with trying. Is this something we should be more concerned about this with our corporate data?
2012-02-13
121 reads
Editorials
Upgrading Your Career
Certification is on Steve Jones' mind this week after quite a few training opportunities have popped up lately.
2012-02-13
283 reads
Encryption in Production
This Friday Steve Jones wants to know if you are using encryption in your production system and if so, how is it working? Can you handle DR situations?
2012-02-10
270 reads
API Changes
Steve Jones comments on predictions that we will see new types of APIs coming in the future, especially data APIs.
2012-02-09
135 reads
Going Solo
This editorial was originally published on Mar 20, 2007. It is being republished as Steve Jones is on vacation. Today Steve Jones talks about going into business for yourself, and reminding you it's not as simple as it might seem.
2012-02-08
153 reads
Feedback and Big Data
Continuous improvement comes from measurement, analysis, and changes. Steve Jones talks about how we should be doing that with our data collection, analysis, and storage.
2012-02-07
120 reads
Insider Security Threats
The biggest security threat always seems to come from insiders and today Steve Jones talks about the need to monitor your environment.
2012-02-06
106 reads
SQL Server 2012: Creative Thinking for a Creative New Licensing Model
It seems inevitable that many customers will end up paying more to get the same features they have today, under the new SQL Server licencing model, unless they respond to Microsoft's creativity with some of their own.
2012-02-06
252 reads
2012-02-03
237 reads
Old Dog, New Tricks
Steve Jones learns a new trick working with T-SQL, and is surprised how easy it is. He recommends you work on updating your skills over time as well.
2012-02-02
569 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers