MCITP 1 Down 3 To Go
Yesterday I posted a quick blurb about my certification plans this year. Well, ok not full blown plans , but you...
2011-05-20
718 reads
Managing Data Change
Often DBAs receive requests to manually manipulate production data. Ideally, all data changes should be performed through the appropriate application...
2011-05-20
1,892 reads
Busy is as Busy Does
I am, as they say, one busy little bee.
I just got back from SQLRally last week (here are my SQLRally...
2011-05-20
563 reads
Watch out, Visual Studio 2010 does not support BI
When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up...
2011-05-20
1,032 reads
SQL Lunch Returns: MVP Max Trinidad (Let’s Talk about SQL Powershell)
I know you have missed the crazy antics, but after taking a short hiatus from my community contributions, the SQL...
2011-05-20
1,132 reads
Re-blog – May 13-19
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-05-20
442 reads
Microsoft SQL Server 2008 R2 SP1
AdvertisementsMicrosoft SQL Server 2008 R2 SP1 CTP
SQL Server 2008 R2 SP1 10.50.2418.0 CTP is available now. You may download and test it.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=15dcfec2-abb8-409d-91ff-c7c8e18c8409
2011-05-20
1,063 reads
Quickly Find Your DDL Triggers with PowerShell
As a consultant I spend much of the first day or two at a client site discovering everything I can...
2011-05-20
1,327 reads
Replicating XML Columns
One caveat that’s worth mentioning is replicating the XML data type in
SQL Server using Merge Replication. Sometimes, when replicating...
2011-05-20
1,427 reads
Presentation Deck For Hardware 201 at Denver SQL Server User’s Group on May 19, 2011
I got the chance to give an updated version of Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance...
2011-05-20
790 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