Get SQL Server Info - Quick Tip & Script
There
are a number of ways to collect basic information about SQL Server, its
version, edition and other top-level properties. What is...
2014-07-22 (first published: 2014-07-17)
11,345 reads
Modeling the Agile Data Warehouse with Data Vault – Review
A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a...
2014-07-17
1,757 reads
How to Check SQL Server Installation Date Time ?
You need to run the following query and it will give you the date of your SQL Server Installation.
SELECT @@SERVERNAME...
2014-07-17
1,892 reads
Goodbye Microsoft, Hello New Adventure
About two months ago, after two and a half years, I left Microsoft.
Microsoft is an amazing place to work for. It’s...
2014-07-17
485 reads
5 Tips for Finding SQL Server System Data
Regardless of the type of development (application or reporting) that you are performing on SQL Server. There are 5 items...
2014-07-23 (first published: 2014-07-17)
9,753 reads
Goodbye Microsoft, Hello New Adventure
About two months ago, after 2.5 years, I left Microsoft.
Microsoft is an amazing place to work for. It’s conformable, balanced,...
2014-07-17
566 reads
T-SQL Window Functions – Part 4: Analytic Functions
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-07-24 (first published: 2014-07-17)
11,167 reads
Remembering Reed Jacobson
I just received some bad news and found out that a friend passed away today. Reed Jacobson was one of...
2014-07-16
509 reads
Track Incomplete Statements
What about when statements are sitting in your server, uncompleted and not moving, just hogging resources? Use this script for...
2014-07-16
610 reads
IT books that should be on your shelf
I have a lot of books on my shelves dealing with business intelligence, data warehousing, master data management, and consulting....
2014-07-16
1,225 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