SQL Rally 2012 Recap and Session Files
SQL Rally 2012 Recap and Session Files
Dallas Convention Center
SQL Rally 2012 was hosted by the North Texas SQL Server User...
2012-05-15
1,031 reads
Blog Posts
SQL Rally Slide Deck and Photos
I’m working on a more comprehensive review of last week’s SQL Rally event, but I’d like to go ahead and...
2012-05-15
609 reads
SQL Rally Slide Deck and Photos
I’m working on a more comprehensive review of last week’s SQL Rally event, but I’d like to go ahead and...
2012-05-15
474 reads
SQLRally Dallas Slides
I was fortunate enough to get to present not 1 but 2 sessions at SQLRally 2012 in Dallas last week. ...
2012-05-15
745 reads
The Cloud is Nothing New
Cloud computing doesn’t seem to have any great definition. Like the physical structures is is named for, it is amorphous,...
2012-05-15
1,453 reads
Create a Filestream Filegroup for Filetables – SQL Server 2012
Once you’ve enabled filestream, the next step is to add a filegroup to your database to hold the filestream data....
2012-05-14
6,747 reads
Data Warehouse vs Data Mart
I see a lot of confusion on what exactly is the difference between a data warehouse and a data mart....
2012-05-14
30,895 reads
Denali – Day 14: New DMV & DMF
Denali – Day 14: New DMV & DMF
As there has been so many DMV/DMF already introduced in earlier version of Sql server,...
2012-05-14
739 reads
Enter the 2012 Exceptional DBA of the Year Awards
I was just at SQLRally in Dallas, and I was speaking to a DBA friend of mine over lunch. He...
2012-05-14
1,020 reads
How To Use T-SQL TIMESTAMP (ROWVERSION) in SSIS
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these,...
2012-05-14 (first published: 2012-05-08)
7,969 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