Two Digit Dates in SQL – MM/DD/YYYY
When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of this:...
2014-03-10
1,204 reads
PowerShell, help me to publish my SSRS reports to SharePoint!
Every time when I heard the word 'PowerShell' it was just like a call to Terra Incognito, you know nothing...
2014-03-18 (first published: 2014-03-09)
8,478 reads
Doing it with the EzAPI
In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that...
2014-03-09
4,617 reads
5 Things a developer should know about databases
Database Normalization
Theoretical versus real-world
There is not a strong need for developers to know the theoretical definition of 1st thru 5th...
2014-03-17 (first published: 2014-03-09)
6,588 reads
VMware Certification Changes
The last twelve months in my certification world have been rather odd. First, Microsoft has terminated their Microsoft Certified SQL...
2014-03-09
734 reads
Auditing VMware vCenter Actions (on SQL Server)
When you’ve got a SIEM appliance or application, you want actions and events going into it as a central repository....
2014-03-07
1,357 reads
Reblog: February 28 to March 6
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-03-07
855 reads
Speaker of the Month, March 2014
This never gets easier. I was able to attend a bunch of sessions in the last month from a number...
2014-03-07
874 reads
DISABLE and DENY LOGIN, DENY USER & Effect on Impersonation and Permissions
DISABLE und DENY LOGIN, DENY USER & Effekt auf Impersonierung und Berechtigungen
(de)
Ein kurzer Artikel zu den Effekten – oder fehlenden Effekten...
2014-03-07
1,006 reads
Friday Followup For March 7, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-03-07
466 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