Part 1: Predictive Modeling using R and SQL Server Machine Learning Services
To R or not to R? A few months ago, I asked myself an important question – which language to learn first – R or Python? From my research,...
2018-11-12
14 reads
SQL Roadie
Azure Cosmos DB Free Trial – walk through of Gremlin API for Graph
After the 2018 Microsoft Ignite event, Microsoft announced a free trial of Azure Cosmos DB. For those who are eager...
2018-10-12 (first published: 2018-10-01)
2,449 reads
Azure Cosmos DB Free Trial – walk through of Gremlin API for Graph
After the 2018 Microsoft Ignite event, Microsoft announced a free trial of Azure Cosmos DB. For those who are eager to check out Cosmos DB, this is a great...
2018-10-01
13 reads
Azure Cosmos DB – Partition and Throughput
In my previous article Introduction to Azure Cosmos DB, I mentioned Partition and Throughput only briefly. Adopting a good partition scheme...
2018-08-17 (first published: 2018-08-05)
2,178 reads
Introduction to Azure Cosmos DB
What is Azure Cosmos DB?
Cosmos DB started as an internal project – “Project Florence” – at Microsoft in 2010. It is a...
2018-04-29
401 reads
Export data from Cosmos DB to SQL Server
Cosmos DB is Microsoft’s latest NoSQL database offering low latency, high scalability and geo-distribution to any Azure region. Read Microsoft...
2018-04-29
2,605 reads
Live Query Statistics – SQL Server 2016
SQL Server Management Studio (SSMS) 2016 has a handy new feature to View Live Query Statistics. This feature also works...
2018-03-07
173 reads
Because loyalty is a two-way street
Moving a dog to Australia with no money at hand
I always had plans to move to Brisbane, Australia, where my...
2016-02-27
229 reads
Database Mail shutting down. Mail queue has been stopped.
DB mail in our production servers started acting up last week. We have SQL Server 2012 SP1. There were a couple...
2015-07-27
1,556 reads
XQuery
In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE,...
2013-03-27
226 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers