Open Source Software and Cacoëthes Scribendi
Phil Factor on the irresistible urge to write code in the public domain, and the occasional desire to be free from the snails-trail of software that needs maintainence.
2012-04-16
99 reads
Editorials
Key Storage
Today Steve Jones asks about how you secure the keys that secure your other data. Is there a good way that you've found to handle this?
2012-04-13
154 reads
Transfer Times in the Cloud
Today Steve Jones talks about a problem in the cloud computing world: getting your data back.
2012-04-12
157 reads
Wasting Time
Focusing in one area for long periods of time is hard. Steve Jones thinks that people taking a little time at work to recharge is a good idea, and something companies might want to encourage.
2012-04-11
258 reads
Certificates Everywhere
Today Steve Jones talks about security and his desire to have certificates be the primary means of securing communications and verifying authenticity.
2012-04-10
188 reads
Get Some Cross Training Today
There's an IT skills gap in many companies, which is forcing managers to get creative. Steve Jones says now is the time to look for some cross training at work.
2012-04-09
184 reads
2012-04-09
54 reads
The On-call Demands
This Friday Steve Jones asks about your on-call responsibilities and the load you face from after hours calls. If you're a DBA that doesn't work strictly 9-5 every week, let us know.
2012-04-06
170 reads
Treat the Database like Code
Steve Jones reminds us that our databases contain code, and as such, they ought to be under some type of version control.
2012-04-05
219 reads
My Little Friend
Today Steve Jones talks about his favorite feature in SSMS 2012 and why everyone should use it.
2012-04-04
627 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