How to add your CMS server to a group
You cannot add a connection to your CMS server, on your CMS server. Well that is what I thought until...
2011-07-06
1,331 reads
SQL Server Analysis Services Operations Guide published
Another whitepaper to add to your “to read” list: SQL Server 2008 R2 Analysis Services Operations Guide
This white paper describes...
2011-07-06
1,046 reads
Recovering a Database
So you’re restored a database, restored a few logs, all with NORECOVERY as expected and realize there are no more...
2011-07-06
909 reads
Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 2
Adding In Others For Contrast
In our first part we introduced Pliant and the LS 300 drive. In part 2 we...
2011-07-06
2,964 reads
ODBC DSN on 32/64 Bit Systems
Funny how you can work with data a long time and still run into something new. I’ve been working on...
2011-07-06
759 reads
Lessons from Out of the Blue
This past Fourth of July weekend I had the opportunity to do a few different things and thought I would share some experiences. None of these experiences were job...
2011-07-06
12 reads
Lessons from Out of the Blue
This past Fourth of July weekend I had the opportunity to do a few different things and thought I would...
2011-07-06
733 reads
Denali’s Skeletons in the closet, Part I
I’ve started to play little bit with SQL Server 2011 CTP Denali to find out whether some open wounds were...
2011-07-06
471 reads
Replacing Cursors with Set-Based SQL Queries – Part 2
Part 2 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a recent post I discussed...
2011-07-06
12,515 reads
July Monthly SQL Server Checklist
It’s a new month, and time to check out your SQL Servers to make sure everything is configured and working...
2011-07-05
1,050 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