Humbled
I’ve received several notes of thanks over the last couple of weeks. I’m not sure exactly what’s prompted this sudden outpouring because it’s all been about stuff I’ve done...
2019-09-27
41 reads
Quick Blog: Run PowerShell Core from the PowerShell Integrated Console
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
The post Quick Blog: Run PowerShell Core from...
2019-09-27
28 reads
Quick Blog: Run PowerShell Core from the PowerShell Integrated Console
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
The post Quick Blog: Run PowerShell Core from...
2019-09-27
20 reads
Quick Blog: Run PowerShell Core from the PowerShell Integrated Console
Run whichever version of PowerShell Core from the PowerShell Integrated Console in Azure Data Studio and VS Code. Even on Windows.
2019-09-27
157 reads
2019-09-26T14:10:42+00:00
TEST You know you are a dad when you start looking at a minivan as a really cool vehicle and marvel at all the features that have zilch to...
2019-09-27
16 reads
ASF 025: Rob Farley interview
Introduction Rob Farley is a Microsoft Certified Master, Microsoft Certified Trainer and is a recipient of the Microsoft MVP Award for SQL Server since 2006. Rob provides consulting and...
2019-09-26
30 reads
2019-09-26T14:04:40+00:00
TEST I have a new term for the wait my daughter eats food. Instead of please stop wearing food all over your face and eat proper I'm going to...
2019-09-26
15 reads
2019-09-26T13:58:58+00:00
TEST You know you probably reserved the wrong hotel when you drive around from the back and think it's a condemned building, only to come around the front and...
2019-09-26
14 reads
Power BI for Communication and Marketing
We often focus on deep analysis and insights generated by machine learning when we talk about Power BI these days because it’s super cool and very fancy. But I...
2019-10-08 (first published: 2019-09-26)
601 reads
Instantaneous Transaction Rollback with SQL 2019
If you’ve read about the Accelerated Database Recovery feature in SQL Server 2019 you could be forgiven for thinking it’s just about speeding up database recovery time in case...
2019-10-09 (first published: 2019-09-25)
962 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