Spinach and Database Development- SQLSatExeter Keynote
Last weekend, we held our SQL Saturday event in Exeter. It was a brilliant event for many reasons but we...
2015-04-30
1,106 reads
SQL DBA With A Beard
Instances and Ports with PowerShell
Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I...
2015-04-22
1,451 reads
Checking SQL Server User Role Membership with PowerShell
SQLDBAwithTheBeard:
Please go and check the New SQL Bloggers posting here https://twitter.com/search?q=%23sqlnewblogger There are some brilliant new and older bloggers adding great value...
2015-04-24 (first published: 2015-04-14)
5,522 reads
PowerShelling SQL Saturday Sessions to the Guidebook app
Following on from my previous post about parsing XML where I used the information from Steve Jones blog post to...
2015-04-07
790 reads
Parsing XML Child Nodes and Converting to DateTime with PowerShell
As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to...
2015-03-31 (first published: 2015-03-21)
6,922 reads
Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month
Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm...
2015-03-17
556 reads
Triggering a System Center Configuration Manager deployment task
A slightly different topic today.
Once you have built up knowledge, you become the person that people ask to solve things....
2015-03-02 (first published: 2015-02-18)
6,613 reads
Show AutoGrowth Events with Powershell to CSV
This week I was reading Pinal Daves post about Autogrowth Events
http://blog.sqlauthority.com/2015/02/03/sql-server-script-whenwho-did-auto-grow-for-the-database/
as it happened I had a requirement to make use...
2015-02-25 (first published: 2015-02-15)
6,280 reads
Uploading a Source Folder to Azure File Storage
Azure File Storage enables you to present an Azure Storage Account to your IaaS VMs as a share using SMB....
2015-02-09 (first published: 2015-02-01)
7,679 reads
Twas 2 Days Before Xmas or Thank you SQLFamily
Twas 2 days before Xmas & all through the office,
not a creature was stirring not even old Maurice.
With merriment going on...
2014-12-23
538 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