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
640 reads
Business Intelligence & SQL Server Decaffeinated
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,766 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,708 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
887 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
550 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,256 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,301 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,535 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers