Reblog: June 14 to June 20
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-21
849 reads
StrateSQL
Last Weeks Top “Reading” Links #37
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-06-17
619 reads
Reblog: June 7 to June 13
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-14
873 reads
Security Questions: Migrate Logins Between Servers
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-06-13
580 reads
The Side Effect of NOLOCK (video)
A while back I put together a blog post on the side effect of NOLOCK. Today I thought I’d push...
2013-06-13
543 reads
Looking to SQL Server 2014 High Availability In Standard Edition
During the keynote for TechEd North America 2013, Microsoft announced the planned release of SQL Server 2014. As part of...
2013-06-12 (first published: 2013-06-10)
3,617 reads
Security Questions: SQL Agent Permissions
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-06-12
623 reads
T-SQL Tuesday – Evil Plan Operators – #TSQL2sDay
This month, Rob Farley (Blog | @Rob_Farley) is running T-SQL Tuesday on plan operators. T-SQL Tuesday is a monthly blogging event where a number...
2013-06-11
715 reads
June 2013 – Monthly SQL Server Checklist
Today is the second Monday of June and guess what I didn’t publish last week? That’s right, there wasn’t an...
2013-06-10
545 reads
Last Weeks Top “Reading” Links #36
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-06-10
521 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