Power BI On Premises Integration with Reporting Services Preview
Since the Reporting Services product team announced last year that it was their intention to provide an on premises deployment...
2016-11-24 (first published: 2016-11-19)
2,140 reads
pturley
SQL Server 2016 SP1 is Now Available
In the Business Intelligence and reporting space, SQL Server 2016 was a big step forward. Aside from significant relational engine...
2016-11-16
448 reads
Business Analytics Day Jan 11, 2017 Chicago
I hope you can join me at the Chicago Microsoft Technology Center for the PASS Business Analytics Day, on Wednesday,...
2016-11-14
430 reads
Happy Birthday Power BI
Today marks the first anniversary of Power BI Desktop and the Power BI Service. The effort to achieve this milestone...
2016-07-24
454 reads
SSRS 2016 Book Nearly Done… My Brain is now Jell-O
(first excerpt from the upcoming book) “Professional SQL Server 2016 Reporting Services and Mobile Reports” from Wrox Press is content...
2016-07-20
517 reads
What do you want to learn about SSRS 2016 at PASS Global Summit?
I’m thrilled to have been selected to deliver a session at the 2016 PASS Global Summit titled “Reporting Services 2016:...
2016-06-29 (first published: 2016-06-24)
1,127 reads
Using Power BI with Enterprise, On-premises Data
I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data. The running time for...
2016-06-19
692 reads
Row-level Security Just Got Better: Passing Report Credentials to Analysis Services in SQL Server 2016
A new ground-breaking feature in SQL Server 2016 allows report user context to be passed through shared data sources, enabling...
2016-06-16 (first published: 2016-06-13)
1,487 reads
Where are SQL Server 2016 Client Tools?
So, you just installed SQL Server 2016 and you’re pretty sure you chose the options to install the client tools...
2016-05-27
4,854 reads
Power BI Application Embedding Releases Today
A few weeks ago, the Power BI team gave us the ability to freely embed Power BI reports, dashboards and...
2016-04-01
523 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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