To Write or Not to Write
That's the decision to be made.
Apress contacted me about the update for my book. I wrote 1/2 of the Designing...
2006-01-05
1,508 reads
Guidance on .WMF patch from Mike Nash, Microsoft Corporate VP
There is a new posting from Mike Nash on the Microsoft Security Response Center blog:
http://blogs.technet.com/msrc/archive/2006/01/05/416980.aspx
Relevant quote:
So the thing that I...
2006-01-05
1,474 reads
Microsoft .WMF Security Patch Releasing Today (out-of-cycle)
Microsoft has announced they will release a security hotfix at 2 PM PST for the WMF design flaw. More details...
2006-01-05
1,425 reads
Remote DBA
I'm getting ready to look for a new cell phone and I got lots of suggestions from my editorial on...
2006-01-05
1,534 reads
Simple Script to Report Tables Sizes in a SQL2K Database
Last week we had an issue with a database growing unexpectedly. The
database in question supported an infrastructure type 3rd party
application...
2006-01-04
1,352 reads
Sample Chapter from Professional SQL Server 2005 Integration Services
Brian Knight posted a sample chapter for Professional SQL Server 2005 Integration Services
to his blog a few days ago. Last...
2006-01-04
1,485 reads
Philosophy on Soldiering
This is taken from the book About Face:The Odyssey of an American Warrior.
The author is Col. David "Hack" Hackworth, one...
2006-01-01
1,431 reads
The Perils of Java Schools
This is great, another rant from Joel, this time on the state of CS Degrees.
I didn't grow up in the...
2005-12-30
1,620 reads
Last Minute Testing
I've had a new web server for a couple months and I've been slowly testing things as I can in...
2005-12-28
1,384 reads
Unpatched Microsoft Windows WMF Vulnerability
If you haven't heard by now, there is an unpatched exploit in how
Windows handles WMF files. Since this handling is...
2005-12-28
1,442 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
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