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

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

550 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,370 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,624 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,380 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)

2,961 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,323 reads

Will GDPR cause a “Database Run”?

by Solomon Rutzky

SQL Quantum Leap

What is GDPR, everyone’s (current) favorite acronym? It stands for “General Data Protection Regulation” and is an act / law / set...

2018-02-05 (first published: 2018-01-23)

2,404 reads

Server Audit Mystery 1: Filtering class_type gets Error Msg 25713

by Solomon Rutzky

SQL Quantum Leap

The other day I ran into an odd problem trying to answer the following question on DBA.StackExchange:
How to filter out...

2018-02-01 (first published: 2018-01-22)

1,539 reads

Stored Procedure / Function / View / Trigger Definitions Can Be Wrong, Even If sp_rename Was Never Used

by Solomon Rutzky

SQL Quantum Leap

SQL Server stores the full definition of certain T-SQL objects — Stored Procedures, Functions, Views, and Triggers — in their original form,...

2018-01-09

882 reads

Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part A of 2: “Duck”)

by Solomon Rutzky

SQL Quantum Leap

(If you’re reading this on SQL Server Central, please click here to see the “Featured Image” which will help explain...

2018-01-04 (first published: 2017-12-08)

2,688 reads

All authors

Solomon Rutzky

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!!

Will GDPR cause a “Database Run”?

Server Audit Mystery 1: Filtering class_type gets Error Msg 25713

Stored Procedure / Function / View / Trigger Definitions Can Be Wrong, Even If sp_rename Was Never Used

Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part A of 2: “Duck”)

Blogs

SQL Saturday Boston 2024 Slides

Small Data SF 2024

A New Word: Moledro

Forums

ETL data load DML SP slowness suggestion

Impact of adding the opening of the Master Key in a SQL job for SSIS packages

Being an extroverted introvert at a conference

Question of the Day

How are statistics stored?