Book Review: SQL Server 2017 Machine Learning Services With R
Disclaimer: I’m one of the Technical Reviewers for this book.
With the rising demand for cloud computing and wide adaptation of...
2018-03-19 (first published: 2018-03-06)
2,699 reads
Marlon Ribunal - SQL, Code, Coffee, etc.
Productivity For The Data Pro
Productivity is hard to measure when your work has no definite structure like a typical office job. You may operate...
2018-02-27
464 reads
Killing A Service Broker SPID
Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations...
2018-03-06 (first published: 2018-02-20)
6,228 reads
Database Maintenance Without Breaking The Bank
Database maintenance does not have to be expensive. There are free tools out there that will make your life easier. Of...
2018-02-22 (first published: 2018-02-13)
3,170 reads
Waiting Tasks Reveal Pain Points
Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I...
2018-02-14 (first published: 2018-02-06)
2,792 reads
Layman’s Guide to Performance Tuning
Performance tuning is one of those things that is hard to get right when you do not have an established...
2018-02-08 (first published: 2018-01-30)
3,524 reads
My Favorite SQL Prompt Features
SQL Prompt from Redgate Software is one of the tools that I cannot live without. Well, that’s probably an exaggeration...
2018-02-02 (first published: 2018-01-23)
3,186 reads
How To Split Table Partitions Automatically
Table partitions can bring a lot of benefits to the manageability and performance of your SQL Server – that is if...
2018-01-16
959 reads
SQL Operations Studio As Monitoring Dashboard
Microsoft as a company has entered a new phase of innovation under the leadership of their CEO Satya Nadella. In...
2018-01-09
564 reads
My Tech Reading List to Start the Year
My bold learning goals call for adequate preparation and proportionate action. Before plunging into the challenge, I need to get...
2018-01-12 (first published: 2018-01-02)
1,791 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