Android is better than iOS
Not in many ways, and certainly not in enough for me to stick with Android over iOS, but here are...
2013-12-20
1,125 reads
Blog Posts
Assign SQL Service Account with Group Policy
How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy?
The answer...
2013-12-20
6,827 reads
Case-Sensitive Updates in a Case-Insensitive World
Assuming you're in a case-insensitive ("CI" in the collation name) column, this UPDATE statement:
UPDATE tablefoo
set foo = 'Z'
where foo = 'z'
will just...
2013-12-20 (first published: 2013-12-16)
1,813 reads
Friday Followup For December 20, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-20
555 reads
Reblog: December 13 to December 19
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-12-20
868 reads
Setting up Security on sub sites in SharePoint 2010
A lot of companies have several departments and want to limit the sub sites users can view. For example, the...
2013-12-20 (first published: 2013-12-16)
1,544 reads
How to Set Up Managed Backups in SQL Server 2014
Earlier this week I introduced the concept of Managed Backups (and caused less of a turmoil than I thought I...
2013-12-19
2,855 reads
I’m presenting at the PASS Business Analytics Conference
I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in San Jose, CA...
2013-12-19
654 reads
MDX Implementing Logical OR On Members of Different Hierarchies
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli
In MDX, when two or more members...
2013-12-19 (first published: 2013-12-15)
1,581 reads
Nominated for the Tribal Awards
I’ve been notified I am a finalist for the category Best New Voice at the Tribal Awards. These awards are...
2013-12-19
1,052 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