SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag SQLCLR Rss

Search for any content tagged sqlclr

<< Newer    Items 21 to 40 of 71    Older >>

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,686 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 2016/09/05 (first published: 2014/01/14) | Source: SQLServerCentral.com | Category: qr code
Rating: |  Discuss |   Briefcase | 8,431 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,938 reads

Relational database or graph database? Why not have both?

SQL Server may not be the best solution for every problem, but we have the means to extend its capabilities by linking it to external resources; in this case, using SQLCLR to query a graph database.  Read more...
By Tony Bater 2014/01/08 | Source: SQLServerCentral.com | Category: nosql
Rating: |  Discuss |   Briefcase | 7,371 reads

Exporting CLR Assemblies from SQL Server back to .dll files

You have imported an assembly into a SQL Server database to use the CLR functions and stored procedures it contains. However later, you lost the original .dll file and you would like to create the .dll file again from what's in the database. In this tip, we look at how you can recreate the .dll file.   Read more...
By Additional Articles 2014/01/06 | Source: MSSQLTips.com | Category: sqlclr
Rating:  Rate this |   Briefcase | 2,306 reads

Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Learn how to use SQLCLR to get file system information instead of using xp_cmdshell on your SQL Servers.  Read more...
By Jonathan Kehayias 2013/11/22 (first published: 2009/02/05) | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 30,446 reads

SQL CLR Multi-Threaded File Copy

A CLR Procedure that performs multi-threaded fie copies without external command line tools.  Read more...
By Steve Ledridge 2013/11/19 | Source: SQLServerCentral.com | Category: async
Rating: |  Discuss |   Briefcase | 2,506 reads

How to implement SHA-2 in SQL Server 2005 or 2008 with a CLR assembly

SQL Server 2012 supports SHA-256 and SHA-512 through the HASHBYTES() function, but earlier versions of SQL Server do not. SHA-256, SHA-384 and SHA-512 can, however, be implemented in SQL Server 2005 or SQL Server 2008 with the CLR assembly described in this article.  Read more...
By Stan Kulp 2013/10/07 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 3,907 reads

Soundex - Experiments with SQL CLR

Using test driven development to turbocharge Soundex 
By David Poole 2013/09/12 | Source: SQLServerCentral.com | Category: programming
Rating: |  Discuss |   Briefcase | 5,551 reads

How to Compile, Deploy and Consume a SQL Server CLR Assembly

Specialized tasks like cryptography require external libraries that are not available in SQL Server. Methods for such tasks can be compiled in a .NET language and deployed to SQL Server as a CLR assembly where the assembly's methods can be referenced by SQL Server stored procedures and functions.  Read more...
By Stan Kulp 2013/08/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,751 reads

Sending E-Mail from SQL 2008 Express

This article provides a comprehensive solution to sending email from SQL Express 2008 and Express 2008 R2.  Read more...
By Andrew Prisk 2013/07/12 (first published: 2010/11/04) | Source: SQLServerCentral.com | Category: sql server express
Rating: |  Discuss |   Briefcase | 15,655 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,399 reads

Deploying CLR Assemblies with T-SQL

Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.  Read more...
By David Rueter 2013/05/07 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 6,152 reads


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,586 reads

How to save results of a procedure with more than one result set

Sometimes a procedure returns more than 1 result set. The article describes how to save all result sets into new database tables  Read more...
By Pavel Sinkevich 2012/09/06 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 10,167 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 | 19,057 reads

CLR Integration in SQL

Learn how to build a CLR function that can be used to perform string manipulations that might be rather complex in T-SQL.  Read more...
By Bina Khan 2012/04/05 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 7,869 reads

An Implementation of the FNV1a Hash Algorithm for SQL Server

Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing  Read more...
By Bret Lowery 2012/02/20 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 4,344 reads

SQL# (SQLsharp): A Review

Only the brave, and foolhardy, write production CLR routines if you can get the functionality already-written and tested. Whether you’re a DBA or developer, there are plenty of times when a CLR routine will save a lot of time, and occasionally provide new functionality.  Read more...
By Additional Articles 2011/10/24 | Source: SimpleTalk | Category: sql#
Rating:  Rate this |   Briefcase | 4,406 reads

CLR Performance Testing

Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.  Read more...
By Additional Articles 2011/08/01 | Source: SimpleTalk | Category: sqlclr
Rating:  Rate this |   Briefcase | 2,624 reads
<< Newer    Items 21 to 40 of 71    Older >>