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

Differences Between the Various Binary Collations (Cultures, Versions, and BIN vs BIN2)

by Solomon Rutzky

SQL Quantum Leap

(last updated: 2019-03-15 @ 02:45 EST / 2019-03-15 @ 06:45 UTC )
Binary collations are, in many ways, simpler to understand than non-binary collations...

2019-03-13

8,154 reads

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

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

3,130 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,247 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)

3,904 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...

2019-01-03 (first published: 2018-06-12)

8,066 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,277 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

5,964 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)

3,637 reads

Enable Group Policy Editor (gpedit.msc) on Windows 10 Home Edition

by Solomon Rutzky

SQL Quantum Leap

Occassionally I want / need to change a Windows setting that is not configurable via Control Panel or Settings. For example:
Enabling...

2018-06-06

1,129 reads

All authors

Solomon Rutzky

Differences Between the Various Binary Collations (Cultures, Versions, and BIN vs BIN2)

What Does the Undocumented UNCOMPRESS Function Do?

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

Beware! Beware of Unintended Changes When Altering Columns!

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

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

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

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

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

Enable Group Policy Editor (gpedit.msc) on Windows 10 Home Edition

Blogs

Truncating very large transaction log in full recovery mode

Autonomous Driving Around London

Best way to monitor high worker thread on SQL Server

Forums

Remove the Dynamic code from my SQL sproc

predictive query plan

Significance of Historical waits report in SQL server Performance dashboard

Question of the Day

Minimal DOP Feedback

Solomon Rutzky

Blogs

Forums

Ask SSC

Question of the Day