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

As mentioned in Part 1 of this "SQLCLR vs. SQL Server 2017" series, the new clr strict security server-level configuration option requires that in order to create any Assembly, even a SAFE one, it must be signed (by a Certificate or Strong Name Key), and there must already exist a corresponding Login, based on the… Continue reading SQLCLR vs. SQL Server 2017, Part 2: “CLR strict security” – Solution 1

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

The Good, the Bad, and the Ugle̅e̅ (need to avoid copyright infringement 😉 ) SQL Server 2017 is soon to be officially released (i.e. RTM) and there are some impressive changes, with some being impressively good, and some being impressively bad. The Good Some amazingly good changes are: Linux as a platform (see my editorial… Continue reading SQLCLR vs. SQL Server 2017, Part 1: “CLR strict security” – The Problem

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

In SQL Server Management Studio (SSMS), there are a lot of options and functions. In fact, there are so many that you might never see / encounter quite a few of them. Part of the issue is that there are four locations to find these options and functions. The four locations are: Menu bar (i.e.… Continue reading SSMS Tip #2: Shortcut Keys for SQLCMD Mode, Open Containing Folder, Copy Full Path, etc

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

SQL Server Management Studio (SSMS) for SQL Server 2016 added some interesting enhancements for the vertical scroll bar: Map Mode and Annotations. Map mode (with Source Overview enabled) changes the vertical scroll bar into a simplistic graphical representation of the entire script (as opposed to the solid grey bar that is merely sized proportionally to… Continue reading SSMS Tip #1: Annotations and Map Mode for Vertical Scroll Bar

No, Binary Collations are not Case-Sensitive

Quite often people will use, or will recommend using, a binary Collation (one ending in "_BIN" or "_BIN2") when wanting to do a case-sensitive operation. While in many cases it appears to behave as expected, it is best to not use a binary Collation for this purpose. The problem with using binary Collations to achieve… Continue reading No, Binary Collations are not Case-Sensitive

Impact on Indexes When Mixing VARCHAR and NVARCHAR Types

You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them is a JOIN or WHERE predicate / condition, as doing so will invalidate indexes. While it is always best to have all datatypes be the same for a particular operation (comparison, concatenation, etc), the actual… Continue reading Impact on Indexes When Mixing VARCHAR and NVARCHAR Types

Hello 🌎

This is a test of the Sql Quantum Leap broadcast system. Had this been a real post, there would (hopefully) be some useful information here :-).