Presenting at “Data Architecture Day” this Saturday (May 16th) at 4:10 PM EDT

• by Solomon Rutzky

• SQL Quantum Leap

Presenting about Module Signing at "Data Architecture Day" this Saturday (May 16th) at 4:10 PM EDT… Continue reading Presenting at “Data Architecture Day” this Saturday (May 16th) at 4:10...

2020-05-14

19 reads

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

• by Solomon Rutzky

• SQL Quantum Leap

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than SQL Server?… Continue reading Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT...

2020-02-03 (first published: 2020-01-24)

2,669 reads

sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019

• by Solomon Rutzky

• SQL Quantum Leap

sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue reading sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019 ?

2020-01-27

311 reads

How Many Bytes Per Character in SQL Server: a Completely Complete Guide

• by Solomon Rutzky

• SQL Quantum Leap

A Completely Complete Guide to how many bytes are used to represent characters in the T-SQL string datatypes… Continue reading How Many Bytes Per Character in SQL Server: a...

2019-12-04 (first published: 2019-11-22)

2,614 reads

Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

• by Solomon Rutzky

• SQLServerCentral.com

• SQLCLR
• Stairway Series

In the second level of our Stairway to SQLCLR, we look at how to enable the SQLCLR in SQL Server. We then build an assembly, store procedure, and a function that can be called from your T-SQL code.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (6)

Log in or register to rate

2019-09-24

16,347 reads

• Discuss

Feature Restrictions in SQL Server 2019 are Worse Than Useless: a False Sense of Security And Wasted Opportunity

• by Solomon Rutzky

• SQL Quantum Leap

A misguided attempt to improve security that not only increases the chances of SQL Injection, but also prevented useful changes from being made.… Continue reading Feature Restrictions in...

2019-08-19 (first published: 2019-08-05)

1,065 reads

Specific String Pattern Magically Hidden From Step Output in SQL Agent History

• by Solomon Rutzky

• SQL Quantum Leap

Specific String Pattern Magically Hidden From Step Output in SQL Agent History. Who Knew?… Continue reading Specific String Pattern Magically Hidden From Step Output in SQL Agent History ?

2019-06-21

121 reads

Maximum Number of Rows for the Table Value Constructor

• by Solomon Rutzky

• SQL Quantum Leap

What is the maximum number of rows for the Table Value Constructor? And, do different uses of it behave differently?… Continue reading Maximum Number of Rows for the Table...

2019-05-27 (first published: 2019-05-09)

712 reads

Error -2068643839 / 1602 Installing msoledbsql.msi and msodbcsql.msi for SQL Server 2019 CTP 2.5

• by Solomon Rutzky

• SQL Quantum Leap

(last updated: 2019-05-05 @ 11:55 EST / 2019-05-05 @ 15:55 UTC ) I had gone through the process of uninstalling the now obsolete SQL Server 2019 CTP, and then...

2019-05-20 (first published: 2019-05-05)

1,995 reads

Can a Certificate’s Private Key be Imported / Restored From a Binary Literal / Hex Bytes ?

• by Solomon Rutzky

• SQL Quantum Leap

(last updated: 2019-04-22 @ 13:00 EST / 2019-04-22 @ 17:00 UTC ) SQL Server 2012 introduced a significant improvement to CREATE CERTIFICATE: the ability to import a certificate —...

2019-05-03 (first published: 2019-04-22)

434 reads