Epsilon Data Breach and Staying Safe
By now, you may have received an email from one of the larger businesses you've given your email address to...
2011-04-05
767 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,716 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
11 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
738 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
399 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,133 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
387 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
380 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,449 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers