SQL Server 2016 Announced, and it stretches to the Cloud!
Last week during Ignite, Microsoft CEO Satya Nadella announced the next version(Till then it was called as SQL vNext) of...
2015-05-10
1,018 reads
Editing Table Rows in SQL
When you create a database driven website, you actually write SQL scripts to insert data into the database. You also...
2015-05-10
751 reads
SQL Server in Azure
There are two flavors of SQL Server in Azure: one is the traditional SQL Server platform hosted in Azure virtual machines,...
2015-05-09
988 reads
A Week to SQL Saturday #393 – Redmond
Only my second SQL Saturday of the year (wow), but SQL Saturday #393 is next week in Redmond, WA. This...
2015-05-08
756 reads
SQL SERVER Interview Questions
All you who wants to pursue professional life as SQL SERVER DBA, its always hard to crack the interview . But...
2015-05-08
1,515 reads
Bringing Together Databases, Virtualization and Storage
A few weeks ago Bala Narasimhan from PernixData and I recorded a short conversation where we discussed the tips and tricks...
2015-05-08
384 reads
002 – SQL Server 2016 - WaterOx Consulting
Reading Time: 1 minutesIt is official! The next version of SQL Server will be SQL...
The post 002 – SQL Server 2016...
2015-05-08
673 reads
PSA: Update Your PASS Profile
I got my annual two emails from the PASS organization with the notification to update my profile to vote. I’m...
2015-05-07
907 reads
Video: Bringing Together Databases, Virtualization and Storage
Bala Narasimhan, Vice President of Products from PernixData, and I recently sat down and discussed the convergence of infrastructure, SQL Server,...
2015-05-07
373 reads
Reframing to Overcome Filtered Index Limitations
I’m continuing on with the Blogger’s challenge in this post.
Turning the Problem Around
In the last post, I wrote about limitations...
2015-05-22 (first published: 2015-05-07)
4,290 reads
Blogs
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