Modulo!
I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even...
2016-04-14
507 reads
How Long Did That Job Run?
When you use the msdb tables to try to gather information on your SQL Server Agent jobs, inevitably you will...
2016-04-21 (first published: 2016-04-14)
4,223 reads
MongoDB – List All the databases
The function getDBs() function returns all the database list
db.getMongo().getDBs()
The runCommand is a special type of query called a database command and...
2016-04-13
581 reads
SSRS 2016 then SQL Jeopardy! tonight at BRSSUG!
See you tonight for our special SQL Jeopardy! competition where I will be your Trebek and three lucky user group...
2016-04-13
411 reads
SQL 2016 – Dynamic Data Masking
One of the new features that’s coming with SQL Server 2016 is Dynamic Data Masking. DDM is designed to allow...
2016-04-22 (first published: 2016-04-13)
2,155 reads
SQL Server 2016 – It just runs faster SQL Server Engineer Blog Post Overview
In March the CSS SQL Server Engineers started to blog about various new enhancements made to the SQL Server Engine...
2016-04-22 (first published: 2016-04-13)
3,053 reads
Awesome SQL Server Feature
There are a lot of cool features in SQL Server that ROCK! It is really hard to pick just one with so many cool features that can make life...
2016-04-13
9 reads
Awesome SQL Server Feature
The second Tuesday of April 2016 is now upon us and you know what that means. Well, I hope you know...
2016-04-13
792 reads
Cardinality Estimator - Part 2- Out of Date Statistics
Continuing from our series on Cardinality Estimator 2014, Let us look at the first difference between 2 CE models. The...
2016-04-21 (first published: 2016-04-12)
2,018 reads
Build database schema snapshot functionality into your .NET application
If you wish to build your own .NET application that allows the user to take database schema snapshots on demand or schedule them to be taken at certain times,...
2016-04-12
14 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