Go Look at NELL
NELL (Never Ending Language Learning) is a computer system that is trying to learn to read the web. Couple things...
2012-05-17
709 reads
Blog Posts
No Caps for SQL Saturday : Speaker Edition
A few weeks back, I got into a conversation about whether PASS should put the boot down on events and...
2012-05-17
999 reads
SQL Saturday #150 and Tech Day
Baton Rouge’s annual tech event for the IT community is coming up August 4th on the beautiful campus of LSU....
2012-05-17
657 reads
SQL Saturday 112 Recap
I had the pleasure of attending SQL Saturday 112 this past weekend. This was my second time speaking at a...
2012-05-17
593 reads
Tips to improve your blog, really!
As I learnt a few things about blogging, I made a list of tips to get better at blogging. Thought...
2012-05-17
902 reads
Use Powershell script to verify backup files
Before restoring backup, we always verify the backup file first, and run the 3 command below:
1. RESTORE HEADERONLY
Returns a result...
2012-05-17 (first published: 2012-05-12)
8,934 reads
All about Kerberos authentication
http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx
2012-05-16
218 reads
Dell 12th Generation Server Cheat Sheet
Over the past several months, Dell has been rolling out a number of new 12th generation servers that all use...
2012-05-16
2,220 reads
Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool
Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool
As blogged on “Denali – Day 11: SSMS enhancement” about Features added on...
2012-05-16
812 reads
Don’t You Know Who I Am?
I’m happy to say that for most of you out there, the answer to this question is “no.” That’s as...
2012-05-16
818 reads
Blogs
Taming Database Challenges: Insights from Redgate Keynote
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
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...
Forums
What does B6 Notebook mean?
B6 Notebook Size can be found in a few novels and stories. The dimensions...
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...
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