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

981 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,376 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,239 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

681 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,162 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,315 reads

Forums

Visit the forum

SQL Quantum Leap

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

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

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

No, Binary Collations are not Case-Sensitive

Impact on Indexes When Mixing VARCHAR and NVARCHAR Types

Blogs

How I Built RAG for My Accounting App on Bedrock and pgvector

Why AI isn’t paying off yet, and what to invest in first

Flyway Tips: Analytics Platforms (Snowflake and Databricks)

Forums

Pay for Performance

Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444

Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444

Question of the Day

Too Many Choices