Midlands PASS July Meeting – July 10
The Midlands PASS Chapter will hold its next meeting on July 10. We meet at MicroStaff IT in Cayce, SC....
2014-07-03
465 reads
How Critical is a Demo?
Do you always need a demo?
Is a demo always needed?
One of my more popular presentations I have been doing as...
2014-07-03
685 reads
Executing scripts on multiple servers the easy way
Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at...
2014-07-03
2,392 reads
Using Synonyms to Extend SSIS
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality is, not all of those uses are good for...
2014-07-03
8 reads
Using Synonyms to Extend SSIS
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality...
2014-07-03
1,743 reads
Reflections on the 2014 PASS Summit Selection Process
Oh we are a bunch of high school kids at heart. Maybe high school never ends (and there’s a nightmare,...
2014-07-03
1,123 reads
SQL Server 2014 New Features
SQL Server 2014
Below is a listing of the SQL Server 2014 new features and where you can find more information...
2014-07-02
1,950 reads
The Selection Process
According to this post from Amy Lewis (PASS Board of Directors) there were 943 abstracts submitted for the 2014 PASS...
2014-07-02
578 reads
The Case Of the Downward Pointing Arrow-Question of the Day
The Case Of the Downward Pointing Arrow is written as an abbreviated mystery, Sherlock Holmes style. Had to laugh at...
2014-07-02
444 reads
Above Reproach
It’s been a busy few weeks in the world of PASS, lots of good conversations that I’ve followed with interest,...
2014-07-02
874 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