Power BI World Tour–Dallas Nov 27-29
Please join the Power BI User Community in Dallas on Nov 27th through the 29th for the Power BI World Tour. There will be a one-day workshop on Tuesday...
2018-11-20
28 reads
How Long is That Event Taking
Knowing just how long an event takes is a common requirement when troubleshooting. Sometimes, figuring out the unit of time is a bit troublesome. Is it milliseconds, seconds or...
2018-11-20
16 reads
How Long is That Event Taking
Knowing just how long an event takes is a common requirement when troubleshooting. Sometimes, figuring out the unit of time...
2018-11-20
254 reads
A Problem with POWER()
I ran into an interesting problem while working with the POWER() function. I was trying to do some binary conversions...
2018-11-20
814 reads
Testing if a Port is Open With PowerShell
Ever want to confirm that a port is accessible from one computer to another? There’s a PowerShell cmdlet for that, Test-NetConnection. With the -Port option, this cmdlet will do...
2018-11-20
88 reads
Testing if a Port is Open With PowerShell
Ever want to confirm that a port is accessible from one computer to another? There’s a PowerShell cmdlet for that,...
2018-11-20
7,027 reads
What were you thinking (hidden relationship)???
What were you thinking?
Have you ever been working on some code from another person, and you end up scratching your...
2018-12-05 (first published: 2018-11-20)
2,257 reads
High CPU and Query Store, A Story of Spinlock Heartache
This is going to be a quick look at an issue that we recently encountered, I’m not going to go...
2018-12-04 (first published: 2018-11-20)
2,371 reads
Power BI World Tour–Dallas Nov 27-29
Please join the Power BI User Community in Dallas on Nov 27th through the 29th for the Power BI World...
2018-11-20
224 reads
4 SQL Injection Techniques For Stealing Data
Watch this week’s episode on YouTubeI’m not advocating that you start using SQL injection to start stealing other people’s data.
However,...
2018-12-05 (first published: 2018-11-20)
3,385 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