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

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,407 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,702 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

926 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,690 reads

PLEASE, Please, please Stop Using Impersonation, TRUSTWORTHY, and Cross-DB Ownership Chaining

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2018-03-27)
Despite features added in SQL Server 2005 (yes, 2005!) that allow for very flexible, granular, and robust security,...

2017-12-30

4,238 reads

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

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

2017-12-28 (first published: 2017-12-11)

1,824 reads

Sessions, Temporary Objects, and the Afterlife

by Solomon Rutzky

SQL Quantum Leap

For thousands of years theologians have offered various thoughts on the question of what happens when we die. Does some...

2017-11-30 (first published: 2017-11-20)

2,008 reads

Line-Continuation in T-SQL

by Solomon Rutzky

SQL Quantum Leap

Some (or maybe most?) languages and operating system command shells allow for breaking up long lines into multiple lines (i.e....

2017-11-08 (first published: 2017-10-27)

11,409 reads

All New Collations in SQL Server 2017 Implicitly Support Supplementary Characters

by Solomon Rutzky

SQL Quantum Leap

As I was testing whether or not the new “Variation Selector Sensitive” ( _VSS ) Collations in SQL Server 2017 would assist...

2017-10-31 (first published: 2017-10-16)

2,609 reads

SQLCLR vs. SQL Server 2017, Part 6: “Trusted Assemblies” – Whitelisted Assemblies can’t do Module Signing

by Solomon Rutzky

SQL Quantum Leap

“Trusted Assemblies”, a new feature starting in SQL Server 2017, is a means of whitelisting Assemblies that one feels pose...

2017-10-09 (first published: 2017-09-29)

2,325 reads

All authors

Solomon Rutzky

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”)

PLEASE, Please, please Stop Using Impersonation, TRUSTWORTHY, and Cross-DB Ownership Chaining

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

Sessions, Temporary Objects, and the Afterlife

Line-Continuation in T-SQL

All New Collations in SQL Server 2017 Implicitly Support Supplementary Characters

SQLCLR vs. SQL Server 2017, Part 6: “Trusted Assemblies” – Whitelisted Assemblies can’t do Module Signing

Blogs

Programmatically Retrieving MLV Lineage and Refresh Times

SWAG Saves the Day

Upgrading SQL Server Containers on the Laptop

Forums

Having Issue deploying a report to an on prem server from PowerBI desktop

SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade

How Long is a Long I/O?

Question of the Day

How Long is a Long I/O?