How Do Blind People Use SQL Server?
#SQLNewBlogger
I can just see people skimming that and doing a knee-jerk reaction, “What a cruel and mean title! You should...
2015-04-22
1,032 reads
Padding Fields for Fixed-Position Data Formats
Fixed-position data formats will seemingly be with us forever. Despite the relative ease of parsing CSV (or other delimited formats), or even XML, many data exchanges require a fixed-position...
2015-04-22
24 reads
Outlier Detection with SQL Server, part 6.1: Visual Outlier Detection with Reporting Services
By Steve Bolton
…………Most of the previous articles in this self-tutorials on using SQL Server to find outliers required us to...
2015-04-21
1,751 reads
What Permissions do I need to generate a deploy script with SSDT?
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or...
2015-04-21
476 reads
What Permissions do I need to generate a deploy script with SSDT?
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or...
2015-04-21
80 reads
What Permissions do I need to generate a deploy script with SSDT?
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or...
2015-04-21
44 reads
What Permissions do I need to generate a deploy script with SSDT?
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or still automatically but at a later date plus you...
2015-04-21
14 reads
Creating a Self-Contained Multi-Subnet Test Environment, Part I – Networking
For a recent presentation on using availability groups for disaster recovery, I needed a test environment that contained multiple separate...
2015-04-21
741 reads
Excel Tip #25: Overlaying Charts
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-05-01 (first published: 2015-04-21)
6,962 reads
Speaking at IT/Dev Connections
I am very happy to announce that I will be presenting two sessions at this year’s IT/Dev Connections conference in Las Vegas!...
2015-04-21
409 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