Stairway to SQLCLR Level 8: Using Visual Studio to Work around SSDT

In the final installment of this three-Level series, we use another automation-related feature to do what SSDT doesn't handle natively.

Stairway to SQLCLR Level 7: Development and Security

Learn about some Visual Studio features that help with automation, and use them to create an Asymmetric Key and Login.

Stairway to SQLCLR Level 6: Development Tools Intro

This time we look at the commonly used tools for doing SQLCLR development: Visual Studio (VS), SQL Server Data Tools (SSDT), and SQL Server Express LocalDB (LocalDB).

HashBytes Nvarchar(MAX)

SQL SERVER Includes a Hashbytes function, however it's limited to VARCHAR(8000). This can cause a problem when trying to build hashes over wide datasets.

Solution

Expose the C# Hashbytes function using CLR

Soundex - Experiments with SQLCLR Part 3

Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework

Soundex - Experiments with SQLCLR Part 2

Constructive feedback on SOUNDEX - Experiments with SQLCLR lead to further experimentation with phonetic algorithms

Retrieving a Binary File from Your Database

In this second article I provide the means to restore a binary file to its original state.

Storing a Binary File in a Database

In this article you will see how to convert a file to a binary stream and insert it into SQL Server with SQLCLR.

List CLR Objects in Database

Script lists all the clr objects in the database.

Stairway to SQLCLR Level 5: Development (Using .NET within SQL Server)

This time we take a look at various aspects and limitations of working with SQL Server's CLR that affect what can be done and how to do certain things.