T-SQL Tuesday #62 – Healthy SQL
The invitation for T-SQL Tuesday this month comes from Robert Pearl. It’s called HealthySQL and it’s a topic I like....
2015-01-13
803 reads
Blog Posts
Configure Search Topology in ScaleOut Mode in SharePoint 2013 || Configure Search Service in SharePoint 2013
Hello Friends,
With a New Year and my earlier commitments. Below is the way to configure Search Service 2013 in Scale...
2015-01-12
877 reads
David Postlethwaite - Exciting news.
By David Postlethwaite
I have been chosen to speak at SQL Saturday in Vienna, Austria on 28th February.
The organisers have just...
2015-01-12
475 reads
Discussing Security with Boris Hristov on SQLHangout #29
Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I...
2015-01-12
529 reads
I’m a SQL Server MVP!
I have been working with SQL Server for the past 17 years, and in the past few years I have...
2015-01-12
640 reads
Impact Players – SQL Style
Awhile back I did a post on my Fab Five – was one of my favorite ones I’ve done to date...
2015-01-12
423 reads
Parameterization Part 7: Summary
This is a summary of the parameterization blog post series. If you read the previous posts in the series, then...
2015-01-12 (first published: 2015-01-08)
7,381 reads
She Taught Me to Code–A Tribute to Sheila, My Wife
A tribute is an expression of gratitude or praise. A couple of years ago, I started a series about individuals...
2015-01-12
750 reads
SQL Cruise Caribbean Is Coming Soon
Want to get out of the winter blues and into some warmer weather for some deep SQL Server training? Join...
2015-01-12
1,237 reads
The big disconnect with Connect
A couple of years ago I blogged about a bug on the Data Collector that I couldn’t resolve but with an...
2015-01-12 (first published: 2015-01-07)
5,296 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