Shuttle Endeavor last mission STS-134: I felt the shockwave
I witnessed a piece of history today at 8:56am; the last voyage of shuttle Endeavor on its STS-134 mission. It was...
2011-05-16
653 reads
T-SQL: Identifying, inserting and removing spaces in strings
Frequently, when working with strings you will need to identify, insert or remove spaces before, after or in between characters.
For example, you may...
2011-05-11
3,830 reads
T-SQL UPPER(): Change an all lowercase string to uppercase
The T-SQL UPPER() command allows you to change a lowercase string to an uppercase string.
For example, it will allow you to change the word...
2011-04-05
1,720 reads
T-SQL LOWER(): Change an all uppercase string to lower case
The T-SQL LOWER() command allows you to change an uppercase string to a lowercase string.
For example, it will allow you to change the word...
2011-04-02
913 reads
Word Macro to load a Data Warehouse
Recently I came across a very specific requirement for a Data Warehouse project for one of our customers. Due to...
2011-04-01
562 reads
SSAS errors: Errors in the metadata manager. The dimension with ID of ‘xxx’ referenced by the ‘yyy’ cube, does not exist.
When deploying or processing a cube or dimension you may encounter an error similar to this:
Errors in the metadata manager. The...
2011-03-22
1,268 reads
SSIS Foreach File Enumerator returns more files than expected by appending a wildcard (*) to the file mask
While working on a recent project for a customer that involved importing both Excel 97-2003 and Excel 2007/2010 files, I was...
2011-03-21
1,317 reads
Differences between Merge and Union All transformations in SSIS
What are the differences between Merge and Union All transformations in SSIS ?
The first and most obvious difference is that Merge...
2011-03-03
1,610 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