Solomon Rutzky

Solomon Rutzky has been working with computers since the mid 1980s. He has experience with a variety of hardware platforms, OSs, programming languages, and RDBMSs. He has focused on SQL Server since 2002, and has written articles for SQL Server Central, including the Stairway to SQLCLR series, and Simple Talk.

Solomon is the founder / owner of Sql Quantum Lift, and is the creator of the popular SQL# SQLCLR library. He answers questions on a few StackExchange sites and Ask.SqlServerCentral.com.

Interests: Computers (duh ;-), religion, sarcasm, chocolate covered raisins

Website: https://SqlQuantumLeap.com/
LinkedIn: https://www.linkedin.com/in/srutzky/

SQLCLR vs. SQL Server 2017, Part 2: “CLR strict security” – Solution 1

by Solomon Rutzky

SQL Quantum Leap

As mentioned in Part 1 of this “SQLCLR vs. SQL Server 2017” series, the new clr strict security server-level configuration...

2017-08-09

970 reads

SQLCLR vs. SQL Server 2017, Part 1: “CLR strict security” – The Problem

by Solomon Rutzky

SQL Quantum Leap

The Good, the Bad, and the Ugle¯e¯ (need to avoid copyright infringement ?? )
SQL Server 2017 is soon to be officially...

2017-08-07

2,363 reads

SSMS Tip #2: Shortcut Keys for SQLCMD Mode, Open Containing Folder, Copy Full Path, etc

by Solomon Rutzky

SQL Quantum Leap

In SQL Server Management Studio (SSMS), there are a lot of options and functions. In fact, there are so many...

2017-07-20

2,201 reads

SSMS Tip #1: Annotations and Map Mode for Vertical Scroll Bar

by Solomon Rutzky

SQL Quantum Leap

SQL Server Management Studio (SSMS) for SQL Server 2016 added some interesting enhancements for the vertical scroll bar: Map Mode...

2017-07-17

664 reads

No, Binary Collations are not Case-Sensitive

by Solomon Rutzky

SQL Quantum Leap

Quite often people will use, or will recommend using, a binary Collation (one ending in “_BIN” or “_BIN2“) when wanting...

2017-07-13

2,143 reads

Impact on Indexes When Mixing VARCHAR and NVARCHAR Types

by Solomon Rutzky

SQL Quantum Leap

You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them...

2017-07-10

5,240 reads

Blogs

Demo for Parameter Sniffing and Memory Grant Feedback

By MarlonRibunal

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

Someone asked why I would use TRY_PARSE after I posted a question at SQL...

Read the latest Blogs

Forums

Partitioning a table with TEXTIMAGE_ON option

By Brandie Tarvin

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

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Great Software

Visit the forum

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          1

If I run this query, how many rows are returned?

SELECT *
 from dbo.OrderHeader
 where customerid between 3 and '6'

See possible answers