SQLpassion Online Training in January 2018
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-01-09
370 reads
Blog Posts
Stored Procedure / Function / View / Trigger Definitions Can Be Wrong, Even If sp_rename Was Never Used
SQL Server stores the full definition of certain T-SQL objects — Stored Procedures, Functions, Views, and Triggers — in their original form,...
2018-01-09
952 reads
T-SQL Tuesday #098–Technical Challenges
It’s the first T-SQL Tuesday of 2018, being brought to you by Arun Sirpal. His invitation this month asks for...
2018-01-09
1,277 reads
T-SQL Tuesday #98 – Take Small Bites!
https://media.makeameme.org/created/mega-bytes-well.jpgIt's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different...
2018-01-09
553 reads
T-SQL Tuesday #98 – Your Technical Challenges Conquered – Corrupt Database in System Table
This T-SQL Tuesday is brought to us by Arun Sirpal (b | t) and wants to write about a technical challenge...
2018-01-09
148 reads
DataMinds.be Meetup – Biml
First blog post of the year and I’d like to take the opportunity to wish everyone the best, professionally and...
2018-01-08
360 reads
Patching your SQL Servers - Meltdown and Spectre
The latest security issue with the name "Meltdown and Spectre" affecting Intel processors was made public last week. This security...
2018-01-08
620 reads
Python and SQL Server Administration
Some of my previous articles on Python provided insight of the basics and the usage of Python in SQL Server...
2018-01-08
820 reads
Roll on 2018!
Hey everyone, hope you all had a great Christmas and New Year!
I took December off from blogging as had started...
2018-01-08
364 reads
SQL Server – TRIM() function in SQL Server 2017
Hello friends, Please check the below link of my new article on TRIM() function in SQL Server 2017 – https://social.technet.microsoft.com/wiki/contents/articles/51047.introduction-to-trim-function-in-sql-server-2017.aspx
2018-01-08
410 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
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