When was my last backup / CheckDB / index maintenance?
Keep a good eye on your backup and maintenance; they’re kind of important to the health and well-being of your job wait I mean...
2018-04-06
376 reads
Blog Posts
Changing the port for SQL Server in Azure Container Services
I got asked this question last week and it’s a very good one. After all, running Sql Server in Azure...
2018-04-05 (first published: 2018-04-04)
1,759 reads
Creating Bar Graph In SQL Server 2017 Using R
Creating a bar graph with R in SQL Server 2017 is relatively easy. It’s just a matter of finding the correct...
2018-04-05 (first published: 2018-04-03)
2,560 reads
Extending built-in data types
add generic user defined table data types as extension to built-in ones
2018-04-05
164 reads
Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments": "Managed Disk.", "type": "Microsoft.Compute/disks", "name": "[variables('diskName')]", "apiVersion": "2016-04-30-preview", "location":...
2018-04-05
12 reads
Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{
"comments":...
2018-04-05
333 reads
Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments":...
2018-04-05
194 reads
Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments":...
2018-04-05
132 reads
RIP, Robert Davis
A sad day for me.
A Memorial and Grief fund has been set up, if you’d like to contribute.
2018-04-05
451 reads
Webinar: Auditing with Extended Events
I’m giving a webinar today, April 5th, at 3 PM Eastern, on using Extended Events to audit your SQL Servers....
2018-04-05
336 reads
Blogs
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