Top 10 Recommended Books…
So the title says it all, right? Well, only really partially. Recently an article was published listing the top 10 most recommended books for SQL Server. That’s the part...
2014-07-29
11 reads
Top 10 Recommended Books…
So the title says it all, right? Well, only really partially.
Recently an article was published listing the top 10 most...
2014-07-29
1,158 reads
Rename or Change SQL Server Standalone Named Instance
Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance. Renaming or Changing SQL Server Standalone Named Instance is almost same as...
2014-07-29
20 reads
How to Edit Read-Only Non-clustered Columnstore Data
As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...
2014-08-06 (first published: 2014-07-29)
8,132 reads
Rename or Change SQL Server Standalone Named Instance
Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance.
Renaming or Changing SQL...
2014-08-05 (first published: 2014-07-29)
9,145 reads
Clustered Columnstore Indexes – part 36 (“Maintenance Solutions for Columnstore”)
Continuation from the previous 35 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
At the 12th Edition of SQLBits around 1 week ago I have...
2014-07-29
616 reads
The Growth Of SQLSaturday
A recent Connector showed the following stats for SQLSaturday for the fiscal year ending June 30, 2014 and mentioned 86...
2014-08-04 (first published: 2014-07-28)
7,631 reads
Building The SQLSaturday Orlando Marketing Plan-Part 26
More notes:
In hindsight it’s easy to see we should have worked on the email template first, then the flyers. Email...
2014-07-28
1,255 reads
Last Weeks Top “Reading” Links #94
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-07-28
1,024 reads
What is ANSI_NULLS and why will I be glad when it finally goes away?
Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and...
2014-08-04 (first published: 2014-07-28)
22,379 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