T-SQL Tuesday #051: Bets and Results
The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been...
2014-02-19
1,797 reads
The Challenge of Customer Service
Friday night I took my wife out for Valentine’s Dinner. We had a reservation for 9 pm and I hoped...
2014-02-18
645 reads
PASS SQLSaturday Events: March 2014
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2014-02-18
611 reads
Data Scientist versus Data Engineer #datascience #bigdata #analytics
One of the main differences between a data scientist and a data engineer has to do with ETL versus DAD:
ETL...
2014-02-18
1,168 reads
SSPI Handshake Failed
A fellow community member sent me an email saying he was having trouble authenticating with Kerberos. Here is the error...
2014-02-26 (first published: 2014-02-18)
4,154 reads
Walmart Store Openings through Power Map
A couple weeks back, I was taking a look at a map that had been put together on Flowing Data...
2014-02-21 (first published: 2014-02-18)
2,392 reads
PolyBase explained
PolyBase is a new technology that integrates Microsoft’s MPP product, SQL Server Parallel Data Warehouse (PDW), with Hadoop. It is designed to...
2014-02-25 (first published: 2014-02-18)
18,200 reads
Hilux – @BBC #TopGear
May drives a modified Hilux to the rim of that unspellable Icelandic volcano that subsequently shut down Europe’s airspace
via Search...
2014-02-18
355 reads
The CASE Statement and Performance
In case you don’t know, this query:
UPDATE dbo.Test1
SET C2 = 2
WHERE C1 LIKE '%33%';Will run quite a bit slower than this...
2014-02-25 (first published: 2014-02-18)
6,550 reads
Dealing with the mysterious “True” column in BIML
Recently I ran into the following error when compiling BIML into SSIS packages:
The message itself is not very revealing:
The data...
2014-02-18
1,025 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