Core T-SQL
Steve Jones thinks there is a list of core skills that any database developer or DBA needs. This week he asks you for a list of those things you think should be included.
2017-11-03 (first published: 2013-11-22)
783 reads
Editorials
Good Practices for Software Development
We always want to follow the best, or at least good, practices for software development. However do you know what those are? Steve Jones notes there's at least one that isn't often followed.
2017-11-02 (first published: 2014-04-24)
384 reads
2017-11-01
91 reads
2017-10-31
71 reads
How Far are You Willing To Go To Get Something?
There are important things in life and in our career, how far are you willing to go to get them?
2017-10-30
114 reads
Perspective
I find it extremely easy to sometimes lose sight of the important stuff. The day-to-day grind can seriously get in the way. I think this is a big part of how we find ourselves having so many silly intra-organizational turf wars. The developers don’t like how the DBAs do things. The DBAs are frustrated with […]
2017-10-30
74 reads
Physical or Virtual Storage
This week Steve Jones talked about physical hardware, asking who might still pay attention.
2017-10-27
200 reads
Unstructured Data
Unstructured data can be misleading. Steve Jones has a few thoughts today on how he sees this term.
2017-10-26
86 reads
2017-10-25
376 reads
2017-10-23
64 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