Issues and opinions on the PASS anti-harassment policy (#sqlpass)
PASS just published an anti-harassment policy reminder, quickly followed by a blog by Wendy Pastrick (about a bad experience at last...
2015-11-25
950 reads
Test if a File Exists with Powershell
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
Awhile...
2015-11-25
1,405 reads
Resolved: A Duty to Act
If you are a member of PASS, you probably got an email from our President, Thomas LaRock. I interpreted his...
2015-11-25
620 reads
SSC Editorial: Early Adopters
I wrote Early Adopters for SQLServerCentral after seeing a comment elsewhere that basically lumped all MVP’s into one category as...
2015-11-25
538 reads
Women in technology
Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s...
2015-11-25
633 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some...
2015-12-01 (first published: 2015-11-24)
2,733 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person...
2015-11-24
12 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
50 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
59 reads
SQL Server 2005 End of Support and Business Intelligence
How does the official end of support for SQL Server 2005 affect companies using Reporting Services, Analysis Services and other...
2015-12-02 (first published: 2015-11-24)
1,900 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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