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
SqlSaturday #71–Boston Recap: An Upscale Saturday
I had the pleasure of attending and presenting at SQLSaturday #71 – Boston on April 2nd. Adam Machanic (Blog|Twitter), Mike Walsh (Blog|Twitter), Tom LaRock (Blog|Twitter), Grant Fritchey (Blog|Twitter) and...
2011-04-04
13 reads
Meme Monday: 11 Words or Less
Thomas LaRock (Blog | Twitter) has started a community blog series call Meme Monday.
Here’s my entry:
Community is nice, but displaces work if...
2011-04-04
742 reads
Meme Monday
Replication: It's Not Really As Bad As SQLRockStar Says It Is
(Wondering what the heck this is supposed to be about?...
2011-04-04
401 reads
SqlSaturday #71–Boston Recap: An Upscale Saturday
I had the pleasure of attending and presenting at SQLSaturday #71 – Boston on April 2nd. Adam Machanic (Blog|Twitter), Mike Walsh...
2011-04-04
1,137 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
392 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
631 reads
Meme Monday: 11 Words or Less
Looks like time for another meme, this time from Tom LaRock (Blog | Twitter). He challenged us to write a blog...
2011-04-04
383 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,467 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
599 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