Too many Foreign Keys
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some...
2016-03-10
108 reads
New developer build of SQL Code Guard released
Issues fixed since last developer build
[*] fixed incorrect binding of MI008 to MI007
[*] fixed xtra EI028 in case with named...
2016-03-09
1,023 reads
Update Your Scripts!
I had an incident today where a colleague was running a Wait Stats Report and the output looked like this:
As...
2016-03-15 (first published: 2016-03-09)
3,022 reads
Quick PS script to get SQL Server Configuration Aliases - Syndication – WaterOx Consulting
Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or...
2016-03-09
804 reads
Notes from SQLSaturday Tampa 2016
Quick notes:
Speaker dinner at Spaghetti Warehouse. Good location, but just a little confined and a little noisy. Perfect location is...
2016-03-09
619 reads
Tuga IT 2016 – Registrations are open
The registrations for Tuga IT 2016 are finally open: http://tugait2016.eventbrite.com, hurry up cause we are starting to promote it very...
2016-03-09
602 reads
Notes From the February 2016 OPASS Meeting
I gave my presentation on automating restores. Part philosophy (why you need it) and part tech (one way to do...
2016-03-09
644 reads
SSC Editorial: Lessons From Little Green Army Men
This one is about spending time with my daughter – she bought some army men as a toy after a visit...
2016-03-09
529 reads
SSC Editorial: Spousal Surcharges
I had to laugh as I write this, the “Spousal Surcharges” title is awfully close to clickbait. The topic is...
2016-03-09
484 reads
SQL server on Linux
Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full...
2016-03-09
2,266 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