It’s a Problem When a SysAdmin Can’t Log In
I showcased a demo recently that looked at a potential issue with an application where a user used a simple...
2015-01-20 (first published: 2015-01-12)
6,542 reads
SQL Cruise Caribbean Is Coming Soon
Want to get out of the winter blues and into some warmer weather for some deep SQL Server training? Join...
2015-01-12
1,250 reads
Impact Players – SQL Style
Awhile back I did a post on my Fab Five – was one of my favorite ones I’ve done to date...
2015-01-12
443 reads
Configure Search Topology in ScaleOut Mode in SharePoint 2013 || Configure Search Service in SharePoint 2013
Hello Friends,
With a New Year and my earlier commitments. Below is the way to configure Search Service 2013 in Scale...
2015-01-12
914 reads
I’m a SQL Server MVP!
I have been working with SQL Server for the past 17 years, and in the past few years I have...
2015-01-12
644 reads
Discussing Security with Boris Hristov on SQLHangout #29
Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I...
2015-01-12
536 reads
David Postlethwaite - Exciting news.
By David Postlethwaite
I have been chosen to speak at SQL Saturday in Vienna, Austria on 28th February.
The organisers have just...
2015-01-12
479 reads
T-SQL Random Numbers using RAND() for Test Data
T-SQL Random Numbers using RAND()
SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1...
2015-01-12
1,392 reads
2014 Year In Review
As is our want, we must look back over the past year to see what happened. While I normally focus...
2015-01-11
632 reads
A Whole New Mind by Daniel Pink
I have dedicated much more time to reading in the past 6 weeks (Since the beginning of December 2014), and...
2015-01-11
492 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