Reflections on Leaving Microsoft
Reflections on Leaving Microsoft
Reflections of Microsoft By Jeff Sandquist (http://www.flickr.com/photos/jeffsand/)
Several members of my SQLFamily have made adjustments to their career...
2012-03-31
2,310 reads
Blog Posts
Remote DAC connections
TweetG’day,
I wrote a post recently about setting the DAC port for an SQL instance.
I now do this as a matter...
2012-03-31
1,905 reads
Thank God I Chose SQL Server part I: The Tribulations of a DB2 Trial
My last column, Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong, described a comedy of...
2012-03-31
3,677 reads
BIDS Helper 1.6 for SQL Server 2012 released
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...
2012-03-30
2,543 reads
Execution Plan for a User Defined Function
When you execute a multi-statement user-defined function you may see an execution plan that looks something like this:
It appears as...
2012-03-30 (first published: 2012-03-26)
8,343 reads
Liveblog for #SQLBits X Day 1 Keynote
Welcome to the show! I’ll be liveblogging today’s keynote here at SQLBits X in London.
There’s no need to refresh your...
2012-03-30
1,631 reads
Re-blog – March 23 – March 29
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-30
1,876 reads
Select : Lock or No Lock?
Here is a post I happen to find today: why select command is not blocked by update command?
http://blog.csdn.net/zjcxc/article/details/4383113
First, I...
2012-03-30
3,016 reads
Spring SQL Server Connections / DevConnections
I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I...
2012-03-30
2,692 reads
SQL Saturday #130 Jacksonville Schedule Posted
SQL Saturday Jacksonville is just under a month away (April 28) and I’m happy to announce the we recently released...
2012-03-30
1,662 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