Find SQL Database Owner with T-SQL
One thing that on occasion bugs me about PDW or APS or whatever it happens to be called this week...
2014-05-08 (first published: 2014-04-29)
4,102 reads
Bradley Schacht
Webinar Q&A: Getting Started With Analysis Services
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about Getting Started With Analysis Services....
2014-03-21
1,440 reads
SharePoint 2013 – Failed to install the product: D:\global\oserver.msi ErrorCode: 1603(0x643)
I often do my SharePoint setups on virtual machines since I need to build them up and tear them down...
2014-03-04
2,852 reads
Webinar Q&A: New BI Features in SharePoint 2013
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in...
2014-02-28
1,780 reads
A New Year is Right Around the Corner
If you read my 2013 Year In Review you may be here today wondering why I haven’t posted anything despite...
2013-12-30
1,555 reads
Presentation Update: New BI Features in SharePoint 2013
It’s time for another free webinar!!
Whether you like it or not SharePoint is here to stay! With every release of...
2013-12-06
1,233 reads
Presentation Update: Change Data Capture (CDC) Made Easy With SSIS 2012
Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data...
2013-12-05
1,240 reads
Year In Review: 2013
Ok, so it’s not quite the end of the year yet. I figured I would get a head start on...
2013-12-04
1,235 reads
Webinar Q&A: Practical SSAS: Getting Started with Analysis Services
A couple of weeks ago I did two webinars for the Pragmatic Works Free Training on The T’s. The first...
2013-12-03
1,258 reads
Webinar Q&A: SSIS Design Patterns for Loading a Data Warehouse
I’m not going to sugar coat it. I’ve been a bit of a slacker lately. Unfortunately I didn’t get the...
2013-12-03
1,575 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