Attending and Speaking at SQLBits XIV
The SQLBits conference has a special place in my heart – as I have written before, the previous edition of SQLBits...
2015-01-18
666 reads
SQL #57–A one-liner query with PARTITION BY
What can be done in SAS must be possible in SQL
A friend of mine is a data professional in marketing data...
2015-01-22 (first published: 2015-01-17)
10,468 reads
Hangout with Boris Hristov
A couple of days ago I had the great pleasure to join Boris Hristov in one of his awesome SQL...
2015-01-17
604 reads
Why does SqlPackage keep dropping and recreating constraints?
I sometimes see this when deploying via sqlpackager.exe:
Analyzing deployment plan (Complete) Updating database (Start) Dropping DF_XXX... Creating DF_XXX... Update complete. Updating database (Complete) Successfully published database.
This happens everytime...
2015-01-16
30 reads
Why does SqlPackage keep dropping and recreating constraints?
I sometimes see this when deploying via sqlpackager.exe:
Analyzing deployment plan (Complete) Updating database (Start) Dropping DF_XXX... Creating DF_XXX... Update complete....
2015-01-16
60 reads
Why does SqlPackage keep dropping and recreating constraints?
I sometimes see this when deploying via sqlpackager.exe:
Analyzing deployment plan (Complete) Updating database (Start) Dropping DF_XXX... Creating DF_XXX... Update complete....
2015-01-16
174 reads
Technology Advances – mSATA external case
I had an SSD die last year. It was one of my traveling SSDs, where I keep spare copies of...
2015-01-23 (first published: 2015-01-16)
6,621 reads
Two Weeks on the PASS Board
The one absolute promise I made about serving on the PASS Board is that I would let you know what...
2015-01-16
531 reads
Dev Tools: FARR2 Launching groups of files or apps at once
There are probably a common number of apps you pull up when you pull up your system. For example, I...
2015-01-16
649 reads
Dev Tools: FARR2 Launching groups of files or apps at once
There are probably a common number of apps you pull up when you pull up your system. For example, I...
2015-01-16
205 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