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
Blog Posts
Updated Overlapping Statistics Scripts
Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script...
2011-04-05
1,697 reads
#Meme Monday
Use extended events; they work – and make you appear magical.
– “Write a SQL blog post in 11 words or less”...
2011-04-04
622 reads
A SQL Server Hardware Nugget A Day – Day 4
Day 4 of this series is about the upcoming AMD “Bulldozer” family of processors that is due to be released...
2011-04-04
379 reads
A SQL Story in Eleven Words or Less
Tom LaRock (blog | twitter) proposed a Meme Monday and his first choice of topics was to write a SQL Server...
2011-04-04
699 reads
Developing with SQL Server: Three ways to get at data
Getting at data within a .NET application can be straightforward using built in controls or much more complex through connections,...
2011-04-04
2,437 reads
Find tables which are most commonly used in Stored Procedures
When you start working on a new project, one of the important tasks as a database developer is to get...
2011-04-04
107 reads
Isolating SQL Server from other systems
In a recent explanation about the RSA breach, Rick Wanner wrote on the Internet Storm Center (ISC) Diary:
The traditional paradigm...
2011-04-04
2,148 reads
Meme Monday
Meme Monday story:
They’d never heard of indexes. Man, I was SUCH a rockstar!
-Jen McCown, MidnightDBA.com/Jen
2011-04-04
596 reads
2011-04-04
619 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