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/

Clustered Index Uniquifier Existence and Size

by Solomon Rutzky

SQL Quantum Leap

In SQL Server, each and every row in a table needs to be accessible by itself, whether or not you...

2017-09-19

1,913 reads

SQLCLR vs. SQL Server 2017, Part 5: “Trusted Assemblies” – Valid Use Cases?

by Solomon Rutzky

SQL Quantum Leap

In the previous post in this series on SQLCLR in SQL Server 2017 — Part 4: “Trusted Assemblies” — The Disappointment — we...

2017-09-04

410 reads

SQLCLR vs. SQL Server 2017, Part 4: “Trusted Assemblies” – The Disappointment

by Solomon Rutzky

SQL Quantum Leap

Recap
Before we look at “Trusted Assemblies”, let’s take a moment to review the context of the situation. First, the “Good”:...

2017-08-28

1,306 reads

SQLCLR vs. SQL Server 2017, Part 3: “CLR strict security” – Solution 2

by Solomon Rutzky

SQL Quantum Leap

Welcome back, everyone. In the previous post in this series, I explained how to work within the new SQLCLR security...

2017-08-16

702 reads

SQLCLR vs. SQL Server 2017, Part 2: “CLR strict security” – Solution 1

by Solomon Rutzky

SQL Quantum Leap

As mentioned in Part 1 of this “SQLCLR vs. SQL Server 2017” series, the new clr strict security server-level configuration...

2017-08-09

955 reads

SQLCLR vs. SQL Server 2017, Part 1: “CLR strict security” – The Problem

by Solomon Rutzky

SQL Quantum Leap

The Good, the Bad, and the Ugle¯e¯ (need to avoid copyright infringement ?? )
SQL Server 2017 is soon to be officially...

2017-08-07

2,341 reads

SSMS Tip #2: Shortcut Keys for SQLCMD Mode, Open Containing Folder, Copy Full Path, etc

by Solomon Rutzky

SQL Quantum Leap

In SQL Server Management Studio (SSMS), there are a lot of options and functions. In fact, there are so many...

2017-07-20

2,073 reads

SSMS Tip #1: Annotations and Map Mode for Vertical Scroll Bar

by Solomon Rutzky

SQL Quantum Leap

SQL Server Management Studio (SSMS) for SQL Server 2016 added some interesting enhancements for the vertical scroll bar: Map Mode...

2017-07-17

638 reads

No, Binary Collations are not Case-Sensitive

by Solomon Rutzky

SQL Quantum Leap

Quite often people will use, or will recommend using, a binary Collation (one ending in “_BIN” or “_BIN2“) when wanting...

2017-07-13

2,118 reads

Impact on Indexes When Mixing VARCHAR and NVARCHAR Types

by Solomon Rutzky

SQL Quantum Leap

You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them...

2017-07-10

5,082 reads

Blogs

Creating a Striped Backup Set with AI

I needed to test a striped backup, so I decided to ask the AI’s...

SQL Server Migration Overview

It’s Not Just Backup / Restore At some point every company faces it: the...

Trace Flag 1448 – Lessons from a Technical Interview

In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Can/Can't Do/Don't

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can/Can't Do/Don't

Strange String Splits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Strange String Splits

Visit the forum

Question of the Day

Strange String Splits

When I run this code, how many rows are returned?

DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食'
DECLARE @s NVARCHAR(1) = N'食'
SELECT value
FROM STRING_SPLIT(@meals, @s)
GO

See possible answers