Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag SQLCLR Rss

Search for any content tagged sqlclr

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

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 | 17,401 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,762 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,146 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,208 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,343 reads

How to create a CLR assembly on a remote server with limited permissions

How to create external_access CLR assembly on remote MS SQL server, when trustworthy option is forbidden, and only SQL login is available  Read more...
By Pavel Sinkevich 2011/07/25 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 2,752 reads

URI Parser: A set of 20 CLR functions for URI parsing

A set of 20 functions for URI and URL parsing, using .NET's native System.Uri parser  Read more...
By Bret Lowery 2011/07/21 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,241 reads

JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.  Read more...
By Bret Lowery 2011/07/18 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 7,854 reads

Remove HTML tags from strings using the SQL Server CLR

It is recommended that you remove all special characters and HTML formatting. This task can be handled in TSQL code, however in this case I have the opportunity to use .NET and the power of the regular expressions to manage the string. In this tip, I'll build a CLR function which cleans up a string of HTML tags and special characters. I'll use Visual Studio 2010 with C# as the programming language. Check out this tip for my solution.  Read more...
By Additional Articles 2011/07/04 | Source: MSSQLTips.com | Category: sqlclr
Rating: (not yet rated)  Rate this |   Briefcase | 3,525 reads

Taking It to the Extreme: SQLCLR and Parallelism

Learn to use SQLCLR, parallelism and how to write better performing SQL code from MVP Adam Machanic in New York City on July 14-15. Early bird discounts available with the code "EARLYBIRD".  Read more...
By Press Release 2011/06/27 (first published: 2011/05/20) | Source: SQLServerCentral.com | Category: training
Rating:  Rate this |   Briefcase | 5,722 reads

XLSExport: A CLR procedure to export proc results to Excel

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet.  Read more...
By Bret Lowery 2011/06/23 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 8,708 reads

Taking It to the Extreme: SQLCLR and Parallelism

Learn to use SQLCLR, parallelism and how to write better performing SQL code from MVP Adam Machanic in New York City on July 14-15. Early bird discounts available with the code "EARLYBIRD".  Read more...
By Press Release 2011/06/27 (first published: 2011/05/20) | Source: SQLServerCentral.com | Category: training
Rating:  Rate this |   Briefcase | 5,722 reads

Taking It to the Extreme: SQLCLR and Parallelism

Learn to use SQLCLR, parallelism and how to write better performing SQL code from MVP Adam Machanic in New York City on July 14-15. Early bird discounts available with the code "EARLYBIRD".  Read more...
By Press Release 2011/06/27 (first published: 2011/05/20) | Source: SQLServerCentral.com | Category: training
Rating:  Rate this |   Briefcase | 5,722 reads

Trading in xp_cmdshell for SQLCLR (Part 2) - Export Data to Flat Files

Learn how SQLCLR can be used to replace BCP and xp_cmdshell to export data to comma separated and tab delimited flat files.  Read more...
By Jonathan Kehayias 2011/05/06 (first published: 2009/03/03) | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 16,846 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 | 29,414 reads

Read and Write Binary Files in SQL Server with CLR

You are a database developer looking for a common approach for handling read and write access to binary files. You may be a DBA wanting to read various information from binary files and collect it into tables. The code sample presented in this tip will get you started with binary file content handling in SQL Server.  Read more...
By Additional Articles 2011/04/14 | Source: MSSQLTips.com | Category: sqlclr
Rating: (not yet rated)  Rate this |   Briefcase | 4,140 reads

SQL Server random numerics data generation using CLR

You need to generate random data directly into SQL Server table columns or close to the database engine as variables or expressions. Looking at the SQL Server available functions, you notice that only RAND function offers support for random data generation. Although RAND([seed]) is a built-in function, it can only return a float value between 0 and 1, and has other limitations in regards to seed values. Because your table columns may be of various data types, and each data type may have a lower value and an upper value, you would prefer to create your custom random data generators. This is when SQL Server CLR functions come into play and provide a viable solution.   Read more...
By Additional Articles 2011/03/24 | Source: MSSQLTips.com | Category: sqlclr
Rating:  Rate this |   Briefcase | 2,966 reads

How To Use Regular Expressions for Data Validation and Cleanup

You need to provide data validation at the server level for complex strings like phone numbers, email addresses, etc. You may also need to do data cleanup / standardization before moving it from source to target. Although SQL Server provides a fair number of string functions, the code developed with these built-in functions can become complex and hard to maintain or reuse.  Read more...
By Additional Articles 2011/03/03 | Source: MSSQLTips.com | Category: regular expressions
Rating:  Rate this |   Briefcase | 14,601 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,322 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,477 reads
<< Newer    Items 21 to 40 of 56    Older >>