Legacy Limits
Sometimes the hardware or software we use prevents upgrades, which isn't necessarily good for any of us.
2017-01-20
83 reads
Editorials
2017-01-18
204 reads
Delaying Patches is Problematic
Many of our security issues come down to not patching software when there are updates available.
2017-01-17
117 reads
The Development Lab
This week Steve Jones looks at hardware and the ways in which you might assemble a set of computers for building software.
2017-01-16
59 reads
Writing the Correct Query is Important
Making simple mistakes in queries can have far reaching consequences.
2017-01-16
170 reads
Backup Data Security
We need better security for our data, especially for our choices in managing data.
2017-01-12
86 reads
2017-01-11
172 reads
SQL Server is Getting More Popular
Today, Steve Jones looks at the popularity of SQL Server, which was named DBMS of 2017.
2017-01-10
142 reads
Changes are Coming to the SQLServerCentral Forums
SQLServerCentral is getting an upgrade, and Steve Jones has a few words.
2017-01-09
142 reads
Keeping up to, and down with, Date
It is foolish to insist on reading only up-to-date books on technology. Nothing beats getting the broad perspective.
2017-01-09
83 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
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...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
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?
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