Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag SQLCLR Rss

Search for any content tagged sqlclr

   Items 1 to 20 of 69    Older >>
 

Consuming JSON Formatted API Data in 2016

Natively consume JSON data from API sources with SQL 2016 and CLR  Read more...
By Ryan Loftin 2016/06/02 | Source: SQLServerCentral.com | Category: json
Rating: |  Discuss |   Briefcase | 1,756 reads

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.  Read more...
By Solomon Rutzky 2016/03/03 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,895 reads

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.  Read more...
By Solomon Rutzky 2016/03/02 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 893 reads

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).  Read more...
By Solomon Rutzky 2016/03/01 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,683 reads

Stairway to SQLCLR Level 1: What is SQLCLR?

The first step to using the SQLCLR begins with this overview of what is possible and what is not. Start your journey to decide if this is a tool you can use inside your SQL Server instance.  Read more...
By Solomon Rutzky 2015/11/27 (first published: 2014/01/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 17,470 reads

Soundex - Experiments with SQLCLR Part 3

Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework  Read more...
By David Poole 2015/08/27 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 2,711 reads

Rendering PDFs Natively in SQL

How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.  Read more...
By David Rueter 2015/08/21 (first published: 2013/05/08) | Source: SQLServerCentral.com | Category: pdf
Rating: |  Discuss |   Briefcase | 27,359 reads

Soundex - Experiments with SQLCLR Part 2

Constructive feedback on SOUNDEX - Experiments with SQLCLR lead to further experimentation with phonetic algorithms  Read more...
By David Poole 2015/07/06 | Source: SQLServerCentral.com | Category: soundex
Rating: |  Discuss |   Briefcase | 3,227 reads

Retrieving a Binary File from Your Database

In this second article I provide the means to restore a binary file to its original state.   Read more...
By Eric Notheisen 2015/05/28 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 4,507 reads

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.  Read more...
By Eric Notheisen 2015/05/26 | Source: SQLServerCentral.com | Category: binary conversion
Rating: |  Discuss |   Briefcase | 7,370 reads

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.  Read more...
By Solomon Rutzky 2015/03/11 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,207 reads

Dynamic PIVOT CLR

Learn how yo can use a SQL-CLR procedure to handle all your PIVOT queries.  Read more...
By Eric Wahner 2014/11/28 (first published: 2012/12/06) | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 16,469 reads

Stairway to SQLCLR Level 4: Security (EXTERNAL and UNSAFE Assemblies)

In the fourth level of our Stairway to SQLCLR series we take a detailed look at the EXTERNAL_ACCESS and UNSAFE permission sets. We also explore some differences between using TRUSTWORTHY or an Asymmetric Key.  Read more...
By Solomon Rutzky 2014/09/10 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,901 reads

RegEx for DBAs

RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions  Read more...
By David Poole 2014/09/05 (first published: 2012/05/08) | Source: SQLServerCentral.com | Category: regex
Rating: |  Discuss |   Briefcase | 18,992 reads

Stairway to SQLCLR Level 3: Security (General and SAFE Assemblies)

In the third level of our Stairway to SQLCLR, we look at the various mechanisms in place to help us control Security. In this Level we will focus on SAFE mode and see how secure SQLCLR is by default.  Read more...
By Solomon Rutzky 2014/05/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,889 reads

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

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.  Read more...
By Stan Kulp 2014/05/13 | Source: SQLServerCentral.com | Category: aes-256
Rating: |  Discuss |   Briefcase | 3,330 reads

The SQLCLR Impact

Has the SQLCLR system impacted your SQL Server environment? Steve Jones wants to know if it has or has not today.  Read more...
By Steve Jones 2014/02/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 185 reads

Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

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.  Read more...
By Solomon Rutzky 2014/02/19 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,055 reads

A genuine use for a SQL CLR Aggregate

When should you use a SQL CLR Aggregate? Lots of people have struggled with this one, but David Poole found a use, and has some interesting performance data analysis as well.  Read more...
By David Poole 2014/02/05 (first published: 2010/12/29) | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 14,663 reads

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

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.  Read more...
By Stan Kulp 2014/01/14 | Source: SQLServerCentral.com | Category: qr code
Rating: |  Discuss |   Briefcase | 6,890 reads
   Items 1 to 20 of 69    Older >>