Make Sure You’re Eligible to Vote in the 2015 PASS Election.
Per the post from Bill Graziano, if you want to vote in the 2015 election you have to make sure...
2015-05-11
309 reads
Per the post from Bill Graziano, if you want to vote in the 2015 election you have to make sure...
2015-05-11
309 reads
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2015-05-11
574 reads
It’s five months until SQLSaturday Orlando, have you thought about your speaking plans for October? We’d love to have you come...
2015-05-11
358 reads
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-05-11
731 reads
Beautiful weather for a SQLSaturday! Everything went well, as expected but always appreciated. Just a few notes on this one:
They...
2015-05-11
282 reads
Great explanation of some interesting engineering topics at http://www.engineerguy.com/.
2015-05-11
316 reads
I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...
2015-05-20 (first published: 2015-05-11)
7,096 reads
This is a basic introductory post about Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server.
What is...
2015-05-11
1,294 reads
Question : Database snapshot captures only data changes or it will also save real database from DDL changes (like table structure,...
2015-05-19 (first published: 2015-05-11)
5,626 reads
Here's a new thing to be scared about in the night, as if you weren't already terrified of floats after...
2015-05-18 (first published: 2015-05-11)
681 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item 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