Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1.
When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...
2012-05-22
30 reads
The Tally Table and Expanding Rows
Suppose you had some data like this:
Class Limit
————— ———–
Calculus 5
History 4
Physics 2
But what you really want is this:
Class ...
2012-05-22
1,473 reads
Converting to the SSIS 2012 Project Deployment Model
The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed. ...
2012-05-22
9,609 reads
Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)
Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)
As stated earlier on blog on “LocalDB” discussion, developers are involved...
2012-05-22
911 reads
Basic SSIS Equivalents to T-SQL's LIKE
There are some things that we do in one SQL Server tool, but can't seem to figure out how to do in another. One of those for you might...
2012-05-22
36 reads
Slowing Changing Dimension (SCD) demystified – Part 3
I am wrapping up this series by finally considering the rarely used type 3 SCD.
( i.e. in most business scenarios)
Unlike...
2012-05-22
851 reads
LinkedIn Group Recommendations-Not Quite Useful
I received an email from LinkedIn suggesting that I might find these groups useful:
I’m sure those map back to someone...
2012-05-22
730 reads
Basic SSIS Equivalents to T-SQL's LIKE
There are some things that we do in one SQL Server tool, but can't seem to figure out how to...
2012-05-23 (first published: 2012-05-22)
21,098 reads
SQL Server 2008 SP3 Cumulative Update 5 Released
Microsoft has released two new Cumulative Updates for SQL Server 2008 today. The first one is SQL Server 2008 SP3...
2012-05-21
2,030 reads
From the Labs of SQL Prompt
I love SQL Prompt as an add-in for SSMS. The intellisense is very handy for me and I’ve gotten used...
2012-05-25 (first published: 2012-05-21)
2,717 reads
Blogs
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...
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