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,042 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
622 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
490 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
753 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,459 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,763 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,959 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
748 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,048 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)
8,011 reads
Blogs
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers