Moving WordPress to Windows Azure
For the past year or so I’ve hosted this blog at Godaddy using their web hosting service. It took a...
2014-01-24 (first published: 2014-01-21)
1,591 reads
For the past year or so I’ve hosted this blog at Godaddy using their web hosting service. It took a...
2014-01-24 (first published: 2014-01-21)
1,591 reads
Last week I posted about reviewing passwords and mentioned using a password manager as part of that effort. DaniSQL noted...
2014-01-23
786 reads
2014-01-23
2,042 reads
Just announced on Friday, SQLSaturday #300 will be held in Kansas City, MO, on September 13, 2014 . Everything about that...
2014-01-21
479 reads
I looked at Outlook.com when it launched and recently revisited. I connected a couple of my personal email accounts to...
2014-01-21
535 reads
Ever say “one more minute” while working on something and then realize 30 minutes have gone by? My daughter has...
2014-01-17
633 reads
Today we have a guest editorial from Andy Warren that asks you how you choose the tools you use to solve a problem.
2014-01-17
118 reads
I use a password manager and it currently has more than 150 accounts in it, ranging from my checking account...
2014-01-17 (first published: 2014-01-10)
1,796 reads
2014-01-17
1,929 reads
Email them, call them, instant message them – pick your preferred method, and send a message that says “I think you’d...
2014-01-16
505 reads
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
Hello T-SQL experts I have a table containing team codes and descriptions. Unfortunately, many...
Hi, In my Always On Availability environment, I am seeing two encrypt_option values as...
I have this data in a SQL Server 2019 database:
Customer table CustomerID CustomerName 1 Steve 2 Andy 3 Brian 4 Allen 5 Devin 6 Sally OrderHeader table OrderID CustomerID OrderDate 1 1 2024-02-01 2 1 2024-03-01 3 3 2024-04-01 4 4 2024-05-01 6 4 2024-05-01 7 3 2024-06-07 8 2 2024-04-07I want a list of all customers and their order counts for a period of time, including zero orders. If I run this query, how many rows are returned?
SELECT c.CustomerName, COUNT(oh.OrderID) FROM dbo.Customer AS c LEFT JOIN dbo.OrderHeader AS oh ON oh.CustomerID = c.CustomerID WHERE oh.Orderdate > '2024/04/01' GROUP BY c.CustomerNameSee possible answers