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,146 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
455 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
435 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
466 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
520 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,148 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
702 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,498 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,877 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
527 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers