SQL Server 2016 Row-level Security and SSRS a perfect match
In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level...
2016-02-15 (first published: 2016-02-08)
9,047 reads
Patrick LeBlanc
Upcoming SQL Saturday Precon Sessions (Update!!!!)
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly and blog posts...
2016-02-08
938 reads
From the Power BI dashboard to a specific page in a Report
Recently, I was working with a customer designing Power BI reports and dashboards. Everything was going great until she asked...
2016-01-25
2,768 reads
Quick Tip: Why Can’t I Pin an Excel Range to a Power BI Dashboard?
So two new exciting capabilities were announced recently in Power BI. One involved Excel and the other SSRS, but they...
2015-12-17 (first published: 2015-12-14)
1,851 reads
Sentiment Analysis with Power BI
I was recently asked by a customer to help them do some Text analysis of course evaluation data. They wanted...
2015-12-09 (first published: 2015-12-02)
4,218 reads
Atlanta BI Edition SQL Saturday Precon
The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy. ...
2015-12-03
904 reads
Orlando SQL Saturday Precon – Transform and Visualize Data with Power BI
I found out a couple of weeks ago that I will speaking at the Orlando SQL Saturdayfor the first time...
2015-07-24 (first published: 2015-07-20)
2,108 reads
I’m Speaking at the Baton Rouge SQL Saturday
After a few years away, the Baton Rouge SQL Saturday group has finally allowed me back at their annual event...
2015-07-15
1,343 reads
A Full Day of Power BI with Me
Join me for a full day of Power BI in Baton Rouge, LA and Downers Grove, IL, where I will teach...
2015-04-13
1,402 reads
2015-04-10
1,115 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