2016-04-15
457 reads
SQL 2016 Temporal Tables By Example
Brief Description
Temporal tables allow automated change tracking of a table directly in to a history table which can be queried...
2016-04-15
85 reads
Goodness-of-Fit Testing with SQL Server Part 7.2: The Lilliefors Test
By Steve Bolton
…………Since I’m teaching myself as I go in this series of self-tutorials, I often have only a vague...
2016-04-25 (first published: 2016-04-15)
1,681 reads
MongoDB – How to Copy Database
Using copydb
Run the copydb under admin database with from,to, host parameters
>use admin
switched to db admin
> db.runCommand({ copydb: 1, fromdb: “test”,...
2016-04-14
669 reads
Basic SQLCMD–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-04-14
965 reads
Changing Of the Guard
As many of you know, I stay very active within the PASS community. In late 2007 I got my start,...
2016-04-14
498 reads
The Next Chapter ~ A SQL Journey
The past five years have been nothing short of an amazing ride on this thing we call “The SQL Journey”....
2016-04-14
422 reads
Upcoming Speaking Engagements
The next few months will be crazy for me. I will be travelling a lot around Europe, speaking about SQL Server topics.
Here is where...
2016-04-14
467 reads
Cool Tools: Powershell ISE-Steroids
Disclaimer: I have been provided with a free license because I am reviewing. This doesn't impact my assessment of the...
2016-04-14
1,258 reads
Analytics Platform System (APS) AU5 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU5),...
2016-04-14
874 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