Word-wrap in SQL Server Management Studio
I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic...
2016-05-12 (first published: 2016-05-04)
4,458 reads
How do you audit automatically generated sql deployment scripts?
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because...
2016-05-03
804 reads
How do you audit automatically generated sql deployment scripts?
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because...
2016-05-03
54 reads
How do you audit automatically generated sql deployment scripts?
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because...
2016-05-03
59 reads
How do you audit automatically generated sql deployment scripts?
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because of the restirctions put on them by the requirements...
2016-05-03
11 reads
Implicit Conversion and Performance
Letting SQL Server change data types automatically can seriously impact performance in a negative way. Because a calculation has to be run...
2016-05-03
620 reads
Weekly Round-up 30 April 2016
It’s been an interesting week for me. I spent last week in Toronto delivering a SQL Server upgrade course and...
2016-05-03
369 reads
SQL Server – Row Level security in SQL Server 2016 – Part 1
Hi friends, in SQL 2016 several new security features gets introduced which will help users to protect their data in...
2016-05-03
483 reads
Goodness-of-Fit Testing with SQL Server Part 7.3: The Anderson-Darling Test
By Steve Bolton
…………As mentioned in previous installments of this series of amateur self-tutorials, goodness-of-fit tests can be differentiated in many...
2016-05-02
1,388 reads
Monday Morning SQL Break – May 2, 2016
Gotta love Mondays. At least the weather here in Minnesota is clearing up, the last two weeks have been cold...
2016-05-02
468 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