Version Update, Code Signing and publishing to the PowerShell Gallery with VSTS
At the fabulous PowerShell Conference EU I presented about Continuous Delivery to the PowerShell Gallery with VSTS and explained how...
2018-05-01
479 reads
SQL DBA With A Beard
Professional and Proficient PowerShell: From Writing Scripts to Developing Solutions at PASS Summit
PASS Summit is the largest conference for technical professionals who leverage the Microsoft Data Platform. PASS Summit 2018 is happening November...
2018-04-11
314 reads
Checking Availability Groups with dbachecks
It’s been 45 days since we released dbachecks
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances https://t.co/2dmUdKtgTQpic.twitter.com/N8W01KaKo9
— Rob Sewell (@sqldbawithbeard) February...
2018-04-18 (first published: 2018-04-08)
2,246 reads
Easily Splatting PowerShell with VS Code
So I always like to show splatting PowerShell commands when I am presenting sessions or workshops and realised that I...
2018-03-11
1,307 reads
dbachecks – Configuration Deep Dive
Today is the day that we have announced dbachecks a PowerShell module enabling you to validate your SQL Instances. You...
2018-02-22
1,090 reads
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances
For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks....
2018-03-07 (first published: 2018-02-22)
2,606 reads
VS Code – Terminal crashes when formatting script
I love VS Code. I love being able to press ALT + SHIFT + F and format my code.
The Problem
Yesterday all I...
2018-02-10
491 reads
How I created PowerShell.cool using Flow, Azure SQL DB, Cognitive Services & PowerBi
Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in...
2018-02-03
772 reads
How to write a PowerShell function to use Confirm, Verbose and WhatIf
In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the...
2018-02-05 (first published: 2018-01-25)
1,609 reads
How to run a PowerShell script file with Verbose, Confirm or WhatIf
Before you run a PowerShell command that makes a change to something you should check that it is going to...
2018-01-23
1,041 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