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/

All authors

What’s in a Name?: Inside the Wacky World of T-SQL Identifiers

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2018-04-28)
Today we are going to take a look into an area that you probably are thinking has very...

2018-04-18 (first published: 2018-04-09)

2,901 reads

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2018-04-18)
This is Part 3 of 2. Yes, you read that correctly. You see, way back at the very...

2018-04-16

254 reads

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2018-04-28)

Recap
In Part 1 of this 2 part series, I started with the loose definition in Microsoft’s documentation for...

2018-04-11 (first published: 2018-04-06)

2,076 reads

Why Doesn’t CONTEXT_INFO() Return the Exact Value Set by SET CONTEXT_INFO?

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2019-01-05 @ 23:15 EST / 2019-01-06 @ 04:15 UTC )
Let’s say that you execute the following T-SQL:

SET CONTEXT_INFO 1234;
SELECT CONVERT(INT, CONTEXT_INFO());
The...

2018-04-09

1,124 reads

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2018-04-09)
In answering a recent question on DBA.StackExchange related to why some characters work for parameter names and others...

2018-04-03

561 reads

Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Database-level

by Solomon Rutzky

SQL Quantum Leap

Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...

2018-03-15 (first published: 2018-03-05)

2,383 reads

Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level

by Solomon Rutzky

SQL Quantum Leap

Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...

2018-02-28 (first published: 2018-02-15)

2,633 reads

SQLCLR vs. SQL Server 2012 & 2014 & 2016, Part 7: “CLR strict security” – The Problem Continues … in the Past (Wait, What?!?)

by Solomon Rutzky

SQL Quantum Leap

If the new “CLR strict security” Server-level configuration option in SQL Server 2017 hasn’t caused enough confusion and pain, then,...

2018-02-23

1,383 reads

Server Audit Mystery 2: Filtering action_id gets Error Msg 25713

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2018-06-05)
This post is, for the most part, a continuation of Server Audit Mystery 1: Filtering class_type gets Error...

2018-02-12 (first published: 2018-01-30)

3,155 reads

SQL# Version 4.1 is released!!

by Solomon Rutzky

SQL Quantum Leap

Version 4.1 of SQL# has just been released!

New functionality available only in Full version
Sys_LockResourceReturns the name of the specified Lock...

2018-02-12

1,328 reads

All authors

Solomon Rutzky

What’s in a Name?: Inside the Wacky World of T-SQL Identifiers

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2

Why Doesn’t CONTEXT_INFO() Return the Exact Value Set by SET CONTEXT_INFO?

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1

Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Database-level

Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level

SQLCLR vs. SQL Server 2012 & 2014 & 2016, Part 7: “CLR strict security” – The Problem Continues … in the Past (Wait, What?!?)

Server Audit Mystery 2: Filtering action_id gets Error Msg 25713

SQL# Version 4.1 is released!!

Blogs

SQL Saturday Boston Slides and Code

Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings

Advice I Like: Fear and Imagination

Forums

How to use data pre-computed in previous ETL SSIS Nodes?

Building AI Governance and Policies- First Steps

Simple delete causes table scan on other tables with foreign key

Question of the Day

Checking Identities