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 Does the Undocumented UNCOMPRESS Function Do?

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2019-02-26 @ 18:35 EST / 2019-02-26 @ 23:35 UTC )
IntelliSense in SQL Server Management Studio (SSMS) can be quite helpful. It...

2019-02-26

1,015 reads

How Does DBCC CHECKIDENT Really Work When Resetting the Identity Seed (RESEED)?

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2019-01-31 @ 22:45 EST / 2019-02-01 @ 03:45 UTC )
Today’s “Question of the Day” on SQL Server Central, Cleaning up the...

2019-02-20 (first published: 2019-01-31)

6,241 reads

Beware! Beware of Unintended Changes When Altering Columns!

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2019-01-15 @ 19:50 EST / 2019-01-16 @ 00:50 UTC )
I haven’t seen a lot written about these particular behaviors so I...

2019-01-28 (first published: 2019-01-15)

2,408 reads

Prevent Full Script Execution (Understanding and Using PARSEONLY and NOEXEC)

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2019-01-08 @ 13:53 EST / 2019-01-08 @ 18:53 UTC )
There are times when I am working on a SQL script that...

2019-01-08 (first published: 2018-12-28)

5,053 reads

SQLCLR vs SQL Server 2017, Part 9: Does PERMISSION_SET Still Matter, or is Everything Now UNSAFE?

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2018-11-01 @ 00:50 EDT / 2018-11-01 @ 04:50 UTC )
SQL Server 2017 introduced a new security restriction for SQLCLR in the...

2018-11-12 (first published: 2018-10-31)

3,397 reads

Native UTF-8 Support in SQL Server 2019: Savior or False Prophet?

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2018-12-26 @ 16:20 EST / 2018-12-26 @ 21:20 UTC )
(NOTE: For recent update, please see “Update for CTP 2.2” section)
For some...

2018-09-28

10,645 reads

SQLCLR vs SQL Server 2017, Part 8: Is SQLCLR Deprecated in Favor of Python or R (sp_execute_external_script)?

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2019-01-10 @ 18:00 EST / 2019-01-10 @ 23:00 UTC )
With the additional (and annoying) configuration step required to get SQLCLR Assemblies...

2018-08-27 (first published: 2018-08-09)

4,068 reads

Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?

by Solomon Rutzky

SQL Quantum Leap

Demystifying What “sqlservr -q” Actually Does
(last updated: 2019-01-07 @ 02:25 EST / 2019-01-07 @ 07:45 UTC )
For various reasons, people sometimes find themselves...

2018-06-19 (first published: 2018-06-12)

8,755 reads