Rendering code nicely in blogs and forums.
I wrote the prettifier specifically to help with posting SQL into blogs and forums. You can find it here http://extras.sqlservercentral.com/prettifier/prettifier.aspx...
2008-10-07
6,681 reads
The Call for Nominations to the SQL PASS Board of Directors is Now Open Until October 24, 2008
If you have ever considered taking a leadership role in PASS, you should seriously consider becoming a SQL PASS board...
2008-10-07
423 reads
The Best Database Engine - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-07
371 reads
Notes on Went Well & What We Could Have Done Better - From SQLSaturday #8
As I mentioned yesterday things went pretty well, but always room for improvement. Here are some notes, if nothing else...
2008-10-06
299 reads
Final Reminder - SQLSaturday #5 & #9 Coming Up on October 11, 2008
You can find details about these great free events at www.sqlsaturday.com. It's definitely been interesting watching them grow from afar...
2008-10-06
315 reads
SQL Server 2008 Books Online Have Been Updated
The version of SQL Server 2008 Books Online that was included with the RTM version has now been updated to...
2008-10-06
519 reads
IndyTechFest A Great Success
Just got back from attending IndyTechFest in Indianapolis, IN, which was held on Saturday, October 4, 2008, and had nearly...
2008-10-06
716 reads
IndyTechFest 2008
I spend the weekend in Indianapolis at the IndyTechFest 2008 and had a great time. It's a smaller, regional conference...
2008-10-06
321 reads
Un-concatenating row values
/* Anith Sen's achievement, in his article 'Concatenating Row Values in Transact-SQL' has been to list and illustrate the many ways...
2008-10-06
1,768 reads
Social Hacks - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-06
515 reads
Blogs
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