“A good DBA is a lazy DBA”
I’m borrowing from Andy Leonard (blog | twitter) who says all the time, “Good engineers are lazy.”
If you’re thinking, “Why would I want (to...
2014-06-25
1,960 reads
The Great Escape-Question of The Day
The Great Escape is the question today, one I think you will like because…it’s about LIKE! It’s a head scratcher....
2014-06-25
562 reads
I am speaking at the PASS Summit 2014
I am super excited to announce that I have been selected to speak at the 2014 PASS Summit. This is...
2014-06-25
1,231 reads
Clustered Columnstore Indexes – part 32 (“Size Does Matter, but how ?”)
Continuation from the previous 31 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
The Columnstore Row Group Size Question:
What is better for SQL Server performance:...
2014-06-25
263 reads
Speaking at the SQL PASS 2014 Summit
I’m happy to announce that I will be speaking at the SQL PASS Summit this fall. The summit will be...
2014-06-25
838 reads
The Utility of Execution Plans in Natively Compiled Procedures
I’m actually having problems identifying the utility of execution plans when working with natively compiled procedures. Or, put another way,...
2014-06-30 (first published: 2014-06-25)
1,912 reads
Speaking at the 2014 PASS Summit
Finally the email we’d all been waiting for arrived yesterday, the results of session selection for the 2014 PASS Summit....
2014-06-25
738 reads
Dealing with a long string
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
2,642 reads
Wanted: Senior DBA or Dev-DBA (And So Darn Hard to Find!)
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex data environment. SQL Server is capable of bringing tremendous...
2014-06-25
13 reads
Wanted: Senior DBA or Dev-DBA (And So Darn Hard to Find!)
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex data environment. SQL Server is capable of bringing tremendous...
2014-06-25
12 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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