Notes from the Oct 23, 2013 oPASS Meeting
I drove up to Sanford after work on Thursday for the oPASS meeting to see Mark Kromer present Big Data...
2013-10-28
768 reads
I drove up to Sanford after work on Thursday for the oPASS meeting to see Mark Kromer present Big Data...
2013-10-28
768 reads
Today we have a guest editorial from Andy Warren as Steve is speaking at SQL Intersection today. Andy talks about how names can impact our world.
2013-10-28
133 reads
Yes, it is early, but I’ve set up the invitation for the fifth annual Monday Night Networking Dinner at the...
2013-10-23
744 reads
This year I went with numbers instead of “Monday” or “Day 1”. I think I like it better. Easier to...
2013-10-22
690 reads
I’m home in Orlando, reveling in not being jet lagged for once. A great traveler I am not. I was...
2013-10-21
648 reads
On Thursday the PASS bloggers were given the chance to meet with the PASS officers and I participated along with...
2013-10-19
679 reads
A couple years back Steve Jones and I started The Mentoring Experiment. Our first experiments to see how effective non-local...
2013-10-19
874 reads
More quick notes, it was a busy day:
I saw down with PASS Board Rick Bolesta after the keynote to discuss...
2013-10-18
544 reads
Slower day today, fewer notes!
Most of my morning spent on mentoring and some networkingLunch today was Birds of a Feather,...
2013-10-18
659 reads
PASS Board Q&A just starting. Session is being recorded – transcript will be published, no decision on whether recording will be...
2013-10-18
710 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