A Pretty PowerBi Pester Results Template File
I have left the heat and humidity of Singapore where I have been presenting at the PowerShell Conference Asia and...
2017-10-29
612 reads
SQL DBA With A Beard
TSQL2sDay – Get-PostRoundup
First an apology, this round up is late!
The reason for that is an error in the PowerShell testing module Pester...
2017-09-27 (first published: 2017-09-20)
1,072 reads
#TSQL2sDay – Starting Out with PowerShell
This months TSQL2sday is hosted by me!
Surprise! – I chose PowerShell
I am really looking forward to seeing what other people post....
2017-09-12
600 reads
Automatically updating the version number in a PowerShell Module – How I do regex
I am presenting Continuous Delivery for your PowerShell Module to the PowerShell Gallery at PSDayUK in London. Go and register...
2017-09-09
498 reads
TSQL2sday #94 Lets get all Posh!
Write-Output "What are you going to automate today?"
Welcome to T-SQL Tuesday for September 2017!
T-SQL Tuesday is a chance for you...
2017-09-05
353 reads
PSDay.UK Tickets are on sale
Following a lot of hard work by the organising folks Gael Colas, Ebru Cucen, Daniel Krebs and Johnathan Medd, we...
2017-08-13
354 reads
Using PowerShell to check if your password has been in a breach
We know that we need to keep our credentials secure. We know that we should not re-use our passwords across...
2017-08-09
1,601 reads
I Hate Interviews – TSQL2sDay
This month’s T-SQL Tuesday is hosted by Kendra Little and is on the topic of interviews
I hate interviews as an interviewee....
2017-08-08
526 reads
Presentation Nerves
My previous post on interviews and a number of conversations this year inspired me to write this post. I am...
2017-08-08
451 reads
Announcing PSDay.UK – Whats a PSDay?
On Thursday evening I attended the joint London WinOps and PowerShell User Group. It was an excellent evening with two...
2017-07-24
428 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