The Virginia Tour 2016
Three days of presentations in Richmond Virginia. From Naked SQL to Wheel of Doom - there is a wide breadth of knowledge to be shared.
Related Posts:
An Experiment with Deadlocks...
2016-03-11
5 reads
The Virginia Tour 2016
Long Time Coming
With less than a week before the Richmond SQLSaturday event, I am finally getting this post done – maybe.
This...
2016-03-11
521 reads
Using SELECT INTO with UNION Statements
On occassion, I need to take a number of different result sets and combine them into a single output, which I then want to store in a temporary table....
2016-03-11
12 reads
Using SELECT INTO with UNION Statements
On occassion, I need to take a number of different result sets and combine them into a single output, which...
2016-03-11
442 reads
Finding Strings
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-03-11
691 reads
Download Attachments from Exchange Web Services using SSIS
I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...
2016-03-11
348 reads
Download Attachments from Exchange Web Services using SSIS
I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...
2016-03-11
5,131 reads
The Shield
How many of you are known as the “Grumpy DBA” or have a bad reputation with users because you are...
2016-03-11
278 reads
Are You Data Driven? SQL Server 2016 revealed!
By now, all you folks who logged on to watch the ultimate Microsoft Data Driven event, streamed live from New...
2016-03-11
1,281 reads
Reblog: MDS – A Database Error Has Occurred
I recently came across the following error message when I tried to look at the batches in the Integration Management...
2016-03-11
825 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