Team Reputation
The way that various departments might view a team of technology employees can affect how we interact. Andy Warren remembers a few situations and notes it's always more fun to join a team with a good reputation.
2014-04-04
154 reads
Andy Warren
The Untold Story of SQLHotties.com
Back when SQLSaturday was in the #20’s or so I bought SQLHotties.com, thinking it would be good for an April...
2014-04-03
561 reads
A Questionable Trigger–Question Of the Day
A Questionable Trigger is the SQLServerCentral Question of the Day today. It’s my latest and perhaps the hardest. Here is...
2014-04-02
457 reads
PASS Election Season Begins
Saw the announcement in the Connector today that the process of selecting the Nominating Committee (which vets applications for the...
2014-04-02
523 reads
2014-04-02
2,207 reads
Solid State Tapes–Prelaunch News!
Note: Sorry for the vague details on the tech part, you’ll get all of that tomorrow – this is what I...
2014-04-01
450 reads
Follow Up on The Unusable User–Question Of The Day
I posted about one of my questions of the day called The Unusable User last week and wanted to return...
2014-03-31
1,195 reads
Solid State Tapes–Prelaunch News!
In the world of data it’s always been about speed. SSD’s have become very common on consumer machines and not unusual in corporate datacenters.
2014-03-31
3,135 reads
Building the SQLSaturday Orlando Marketing Plan–Part 1
I’ve volunteered to lead the marketing effort for SQLSaturday Orlando this year. Broadly speaking that means drive attendance to the...
2014-03-28
493 reads
Can’t See The Forest For the Logins–Question of the Day
My latest question is live today – Can’t See The Forest For the Logins is worth 2 points if you’re playing...
2014-03-28
436 reads
Blogs
AI Innovation in Microsoft Keynote
By Chris Yates
I’m thrilled to be covering the Microsoft Keynote: Fuel AI Innovation with Azure Databases on Day...
Benefits of Migrating from Azure Synapse Analytics to Microsoft Fabric
By James Serra
Many customers ask me about the advantages of moving from Azure Synapse Analytics to...
PASS Summit 2024 – A Very Different World
By Brian Kelley
The last data centric conference I attended was the PASS Summit in 2019. A...
Forums
Unencrypted connections in Always on Availability Group
Hi, In my Always On Availability environment, I am seeing two encrypt_option values as...
Error loading multiple CSV files in SSIS
Hi everyone I have a bunch of CSV files that I need to bulk...
What's New for the Microsoft Data Platform
Comments posted to this topic are about the item What's New for the Microsoft...
Question of the Day
Using Outer Joins
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