Power BI Custom Visuals Class (Module 85 – Image Grid)
In this module you will learn how to use the Image Grid Custom Visual. This visual is a unique way...
2018-01-23 (first published: 2018-01-12)
1,891 reads
Blog Posts
Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
322 reads
Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
192 reads
Using dbatools to verify your SQL Server instances version compliance
One of the main DBA's duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service...
2018-01-23
757 reads
When it’s cold outside, perhaps Power BI heat maps can warm you up
(2018-Jan-13) You never know how the weather will behave itself, especially when the temperature gets dramatically changed from +10 to -10...
2018-01-23 (first published: 2018-01-13)
1,847 reads
You Need a New Hobby
Not sure who this is that is attempting to hack into my blog so desperately, but seriously, time for a...
2018-01-23
305 reads
Alwayson Availability Groups vs Alwayson Failover Cluster Instances
SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It...
2018-01-22 (first published: 2018-01-13)
51,460 reads
Azure VPN – Point to Site IP Addresses
Recently, I got to work with a client on something interesting. We implemented transactional replication to send data to an...
2018-01-22 (first published: 2018-01-12)
1,335 reads
Count_Big() function
Learned new function for count while going through the channel 9 video for salva. where for a very big table...
2018-01-22
616 reads
Introducing: The SQLUndercover Inspector
Introducing: The SQLUndercover Inspector! Finally we have a V1 almost ready to hit our GitHub but what exactly is it?
Just another...
2018-01-22
495 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
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