Retiring of the MCM Certifications
The MCM is dead. Long live the MCM.
The small, exclusive club of SQL Server Microsoft Certified Masters is going to...
2013-08-31
4,250 reads
A Discussion of SQL Server-Related Topics
It’s the small things that count
Sometimes it’s the small things that count.
I just noticed two small enhancements to SQL Server 2014's BOL, and I can...
2013-08-14
1,535 reads
T-SQL Tuesday #43 – Plan Operators
This month’s TSQL-Tuesday is hosted by Rob Farley (blog | twitter), who became a Microsoft Certified Master this past December (congrats!)....
2013-06-14 (first published: 2013-06-11)
2,169 reads
Getting the lowdown on 18456 errors
If you can establish a connection to a SQL Server, but are having problems logging in to it, you will...
2013-04-30 (first published: 2013-04-18)
2,555 reads
The Bucket List – Item #1 is (finally) finished
We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the...
2013-04-16
749 reads
T-SQL Tuesday #41 – Presenting and Loving it!
It’s time for our monthly blogging party, commonly known as T-SQL Tuesday. This month, Bob Pusateri is providing the motivation...
2013-04-09
599 reads
A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)
Welcome to Day 28 of my “A Month of PowerShell” series – the last day. This series will use the series...
2013-02-28
2,051 reads
A Month of PowerShell – Day 27 (Scripting SQL Objects)
Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-03-11 (first published: 2013-02-27)
3,481 reads
A Month of PowerShell – Day 26 (Changing Login Passwords)
Welcome to Day 26 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-26
1,305 reads
A Month of PowerShell – Day 25 (Integrity Checks)
Welcome to Day 25 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-03-07 (first published: 2013-02-25)
2,313 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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