Pushing SQL Change Automation Code to Azure DevOps
Making changes on your own system for a SQL Change Automation project is great, but if you’re the only one...
2019-03-06
829 reads
Disabling and enabling triggers
I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now...
2019-03-20 (first published: 2019-03-06)
3,269 reads
How Your Hypervisor Can Impact Your CPU
Recently I had a client complain of chronic high CPU utilization. The performance of their SQL Server had degraded, and...
2019-03-06
593 reads
Tokenization of database project in SSDT
SSDT project has something we call Variables. On the Internet (posts, forums) they also are known as placeholders or tokens,...
2019-03-06
400 reads
#DataInDevon – Getting up to speed with PowerShell or spend a day with one of four other MVPs :-)
Saturday 27th April is Global Azure Bootcamp day
What’s Global Azure Bootcamp?
The website says it best
…. communities will come together once...
2019-03-06
303 reads
SQL server reports GUI Schema change history and CPU RAM IO
SQL server reports GUI Schema change history and...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-03-06
19 reads
SQL server reports GUI Schema change history and CPU RAM IO
SQL server reports GUI Schema change history and...
[[ This is a content summary only. Visit my website for full links,...
2019-03-06
435 reads
Writing a new session/Preparing for SQL Saturday Chicago
So, I’m presenting a session at SQL Saturday Chicago on March 23, 2019. This is a new session, called Performance...
2019-03-06
265 reads
Docker – Install Other Open source DB
We can quickly install anything on Docker with hub.docker.com PostgreSQL: $ docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres MariaDB: docker...
2019-03-05
399 reads
Backup of an Azure SQL DB downloaded outside of Azure
From a dev colleague: “Asking for a client... do you know how to get a backup of an Azure SQL DB downloaded outside of Azure?”
Short answer - You can’t…
Medium...
2019-03-05
33 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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