New Resumable Online Index Create SQL Server 2019
SQL Server 2019 brings a very exciting new feature that, is long overdue. Resumable online index create is one of...
2018-12-13 (first published: 2018-11-28)
2,237 reads
Blog Posts
Power BI Monthly Digest – December 2018
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-12-13
587 reads
Setting up CentOS to run docker for SQL Server
This blog post is about running SQL Server in a docker container on CentOS Linux distribution.
This was both an experiment...
2018-12-13
284 reads
Setting up SQL Server replication in containers
Last week I saw a thread on twitter about how to get replication setup for SQL Server running in a...
2018-12-13
837 reads
SSMS – Docker SQL Server
once we install SQL Server on Docker which we discussed in our last blog, we can connect Docker SQL Server...
2018-12-13
247 reads
TDE and DDM
Someone asked a question about TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking), which are two different technologies that...
2018-12-13 (first published: 2018-11-26)
2,134 reads
The Default Frame for Window Functions
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-13
901 reads
The Eleven Days of Festivus 2018
It’s that time again! My Eleven Days of Festivus blogging extravaganza is now in its third year, and I’m happy...
2018-12-13
171 reads
Things I Learned at Summit v20 - Visual Studio Code
Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this post we'll...
2018-12-13
251 reads
A curious case of case when and Null values
For some reason I have always written my Case statements using the following logic:
SELECT
CASE
WHEN @Priority = 1 THEN 'Very High'
WHEN @Priority...
2018-12-12 (first published: 2018-11-28)
2,808 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