SQLCLR

SQLServerCentral Article

Encrypt a file from SSIS using the Advanced Encryption Standard (AES)

  • Article

This article demonstrates how to create a CLR assembly that can encrypt or decrypt a file with AES-256 cryptography, how to reference the CLR assembly from an SSIS script task, and how to generate an MD5 checksum file so that its recipient can confirm the integrity of the encrypted file.

4.92 (12)

2014-05-13

5,850 reads

SQLServerCentral Article

Generate two-dimensional QR Code® bar codes in an SSRS report

  • Article

QR (Quick Response) Code® is the Denso Wave, Inc. trademark for a type of two-dimensional bar code designed for the automotive industry in Japan. The QR Code system has become popular outside the automotive industry due to its speed and greater storage capacity compared to standard UPC bar codes.

4.76 (38)

2018-10-22 (first published: )

14,138 reads

Stairway to SQLCLR

Stairway to SQLCLR

  • Stairway

The possibilities for programming SQL Server platform were greatly enhanced with the addition of the SQLCLR subsystem. This allows code written in any .NET language to be incorporated into your SQL Server instance and called from a stored procedure or function. You can also create your own data types or aggregates for specialized purposes. This Stairway series will teach you how to get started writing your own CLR code and integrating it into SQL Server.

4.33 (6)

2013-12-27

10,339 reads

Blogs

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Why Managed Identities are Awesome

By

For the first workdays of this new year, I had the pleasurable task of...

Read the latest Blogs

Forums

Dimensional table and Stored Procedure

By yrstruly

To meet these requirements below, I came up with this SQL. Please evaluate my...

Anderson-Darling Calculation

By jackdanny816

Hi   I am following an article posted on sql server central on the...

Use of an NCI - that does not contain the Column required.

By SteveOC

Hello. I am a bit confused and not sure what terms to use to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers