---

Filter by type:

• All
• Articles
• Blog Posts
• Editorials

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,079 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

394 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,289 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

677 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

938 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,323 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

1,575 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

506 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

1,550 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

3,313 reads

Filter by type:

• All
• Articles
• Blog Posts
• Editorials