Azure Portal – Bad Request
I had a strange issue recently when trying to login to the Azure Portal. Quite simply I would enter my...
2018-01-16
273 reads
Blog Posts
Azure SQL Database – Optimizing For Ad-hoc Workloads
Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database...
2018-01-16 (first published: 2018-01-08)
1,612 reads
Checking the Health of your CLR
Having a tool to be able to monitor CLR health will be essential as you deploy more and more managed code within SQL Server. Extended Events offers a great...
2018-01-16
29 reads
Checking the Health of your CLR
The Common Language Runtime (CLR) is the fundamental nerve center of the Microsoft .NET Framework. It is this nerve center that...
2018-01-16
1,028 reads
Deploy Dacpacs with dbatools – The Script!
Hello!
Not so long ago, I wrote about how dbatools now has functions that can be used to deploy dacpacs. What...
2018-01-16
340 reads
Finding the Titles in R
PASS has released the videos to members from this past Summit. I say TJay Belt today ask about relating a...
2018-01-16
576 reads
How To Split Table Partitions Automatically
Table partitions can bring a lot of benefits to the manageability and performance of your SQL Server – that is if...
2018-01-16
986 reads
Importing GeoJSON Earthquake Data Into SQL Server
A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it's not likely to erupt any time soon, the park is constantly monitored for geological...
2018-01-16
23 reads
Importing GeoJSON Earthquake Data Into SQL Server
A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it’s not likely to erupt any...
2018-01-16
1,180 reads
SQL Server on TLS 1.2: Checklist to disabling TLS 1.1 and 1.0
A common finding in security audits these days is the failure to conduct all communications via TLS 1.2. (Correspondingly, a...
2018-01-16 (first published: 2018-01-09)
31,403 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
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