Last Weeks Top “Reading” Links #74
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-03-10
936 reads
Blog Posts
Look At The SQLSaturday Orlando Home Page
One of the weaknesses of the current SQLSaturday tool set is that the front page isn’t strong by default. It...
2014-03-10
313 reads
Two Digit Dates in SQL – MM/DD/YYYY
When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of...
2014-03-10
383 reads
Two Digit Dates in SQL – MM/DD/YYYY
When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of this:...
2014-03-10
1,193 reads
Doing it with the EzAPI
In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that...
2014-03-09
4,603 reads
VMware Certification Changes
The last twelve months in my certification world have been rather odd. First, Microsoft has terminated their Microsoft Certified SQL...
2014-03-09
729 reads
Auditing VMware vCenter Actions (on SQL Server)
When you’ve got a SIEM appliance or application, you want actions and events going into it as a central repository....
2014-03-07
1,351 reads
DISABLE and DENY LOGIN, DENY USER & Effect on Impersonation and Permissions
DISABLE und DENY LOGIN, DENY USER & Effekt auf Impersonierung und Berechtigungen
(de)
Ein kurzer Artikel zu den Effekten – oder fehlenden Effekten...
2014-03-07
1,000 reads
Friday Followup For March 7, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-03-07
457 reads
Impersonating a server level permission
Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...
2014-03-07 (first published: 2014-02-26)
2,615 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