Oracle Tips for MSBI Devs #1: Executing an Oracle Stored Proc with No Parameters in SSIS Execute SQL Task
Originally posted: 3-4-2012 Welcome to a new blog series of tips related to Oracle with a focus on helping those...
2012-03-04
577 reads
DataOnWheels
PASSMN Rocks 2012!
As many of you may know, I am the Chair for the Minnesota SQL Server User Group aka PASSMN. I...
2012-02-22
592 reads
PowerPivot and Market Research
This past Tuesday, February 14, I was invited to discuss how technology can be used to help analyze data for...
2012-02-16
597 reads
PowerPivot for Excel Install Issues
At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server...
2012-02-02
986 reads
Microsoft Data Appliances Help Simplify MSBI Projects
As some of you know, I am really excited about the data appliances Microsoft and HP have released this year. ...
2012-01-27
632 reads
X on XMLA: i. Using XMLA
In my previous blog, I introduced the “X on XMLA” series. In this blog, I will do more of an...
2012-01-26
663 reads
Introducing “X on XMLA”
XMLA or XML for Analysis is used in SQL Server Analysis Services and other multidimensional data systems to manage the...
2012-01-19
548 reads
Why It’s Called a User Group…
On Tuesday night was the first meeting for PASSMN, the SQL Server User Group in Minneapolis/St. Paul this year. As...
2012-01-18
569 reads
How I Got Started in Software Development-A Tribute to Ed
A tribute is an expression of gratitude or praise. As I head into this holiday season I wanted to express...
2011-12-20
510 reads
Why I Blog – #Meme15
A fellow blogger and SQL guy, Jason Strate (@stratesql) started a meme on Social Networking as a result of a...
2011-12-15
564 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