Azure Data Lake enhancements
I first blogged about Microsoft’s new product, the Azure Data Lake, a few months back (here). There are already enhancements, as...
2015-09-29
1,176 reads
Congrats to Jen, Tim, Ryan, and Argenis
Last week we received the results of the PASS Board of Directors elections for 2015. Jen Stirrup and Tim Ford...
2015-09-29
818 reads
Congrats to Jen, Tim, Ryan, and Argenis
Last week we received the results of the PASS Board of Directors elections for 2015. Jen Stirrup and Tim Ford...
2015-09-29
983 reads
Load Testing Your Storage Subsystem with Diskspd – Part II
In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to craft tests to measure bandwidth and latency for specific...
2015-09-29
30 reads
Load Testing Your Storage Subsystem with Diskspd – Part II
In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to...
2015-10-07 (first published: 2015-09-29)
7,730 reads
Do you write ugly T-SQL?
Are your scripts littered with commented blocks of T-SQL code?
select fname,lname
from usertable
where id=1
--and lname like 'smith%'
/*
-- Who knows why...
2015-10-07 (first published: 2015-09-29)
6,374 reads
Calculate Percentage Share in Power BI (DAX)
What’s my share? Calculating percent share of the total is a common need. Let’s see how to calculate this in Power BI...
2015-10-06 (first published: 2015-09-29)
24,967 reads
Session Event Metadata
There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to know where and how to find it. In this...
2015-09-29
11 reads
Session Event Metadata
There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to...
2015-10-08 (first published: 2015-09-29)
1,691 reads
Fixing MSI errors during patching
Patching is an activity that is frequently performed by DBA’s. It is the responsibility of a DBA to keep the...
2015-09-29
22,870 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