SQL Homework – February 2020 – Write a blog post.
Following along with last month’s documentation homework this month I want you to write a blog post. But Ken, what ... Continue reading
2020-02-07 (first published: 2020-02-03)
310 reads
Modernizing Your T-SQL: Splitting Strings
This is the first of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your...
2020-02-03
20 reads
Profiler: Time To Go
I’ve decided that, in fact, it is time to start moving people off the ancient technology, Profiler. Before, I always said, stay where you’re comfortable. However, keeping people comfortable...
2020-02-06 (first published: 2020-02-03)
880 reads
Undercover TV – Table Variable Deferred Compilation
David takes a look at a new feature of SQL 2019, table variable deferred compilation
2020-02-03
30 reads
Undercover Tools: January Updates and Change Log
Below is the January list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.0Major upgrade, see https://sqlundercover.com/2020/01/06/undercover-catalogue-0-4-0-released/ for full details Update 0.4.1ServerConfig module added, detailing settings...
2020-02-03
29 reads
Inspector 2.1 now available
As always all updates can be found on our Github repo Breaking changes (Powershell collection): We only test the powershell collection against 2-3 servers so please test carefully before...
2020-02-03
48 reads
Azure Advisor – for Azure Data Platform
Wouldn’t it be nice if we could access one main dashboard / report that pulls in information from many tools such as security centre, SQL advisor and cost management...
2020-02-03
26 reads
Modernizing Your T-SQL: Splitting Strings
This is the first of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
Last year, you finally retired the last of your SQL...
2020-02-03
20 reads
Last Week Reading (2020-02-02)
Hello. We have a beautiful date today, haven’t we? And LWR posts are coming back after a long one-month break. Press Columnstore Indexes – part 130 (“Columnstore Indexes on...
2020-02-02
8 reads
Last Week Reading (2020-02-02)
Hello. We have a beautiful date today, haven’t we? And LWR posts are coming back after a long one-month break. Press Columnstore Indexes – part 130 (“Columnstore Indexes on...
2020-02-02
16 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