There is awesomeness to be had at #SQLRally
Two days of precons.
60 regular sessions over two days.
The now-famous Women in Technology luncheon.
Open access to Microsoft Customer Service and...
2012-04-30
1,510 reads
Blog Posts
Updated Thoughts on Antivirus on SQL Servers
I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't...
2012-04-30 (first published: 2012-04-24)
5,843 reads
You need to run DBCC CheckDB regularly
You never know when you’ll encounter corruption. It can happen at any time, usually due to some sort of hardware...
2012-04-30
3,344 reads
Always use Configuration Manager for changing service account
When your service account is expired/disabled or is not having access than sql service could not able to start and you may...
2012-04-28
1,790 reads
Exposing OData Endpoints using the ASP.Net MVC Web API
The new Web API that comes with ASP.Net MVC 4 has been getting a lot of posts on creating RESTful...
2012-04-28
108 reads
SQL Saturday 130 Deck & Scripts Live
Hello Dear Reader, greetings from SQL Saturday 130 in Jacksonville. This is just a quick post to say that the...
2012-04-28
1,181 reads
Appending New Rows Only
I saw a question in the forums related to inserting new rows into a SQL Server table only if they...
2012-04-27
5,569 reads
Big Apple SQL - SQLSaturday #158 NYC Announced!
Come this August 4th, 2012, the Big Apple will be baking, but not just because of the hot summer day...
2012-04-27
1,877 reads
Comments on Acceptable Behavior
Here’s the situation. We’re absolutely falling down as men and professionals. Ladies, feel free to read on and comment, but...
2012-04-27 (first published: 2012-04-23)
2,624 reads
Cool Data Visualization
I attended a course from Edward Tufte a few years ago on Data Visualization, and while I learned some neat...
2012-04-27
2,026 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