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

Content with tag SQLCLR Rss

   Items 1 to 20 of 71    Older >>
 

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: sqlclr
Rating: |  Discuss |   Briefcase | 1,843 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 | 162 reads

In Database We Trust

By Andy Warren 2014/02/20 | Category: sqlclr
Rating: (not yet rated) |  Discuss |   Briefcase | 1,803 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: sqlclr
Rating: |  Discuss |   Briefcase | 4,729 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,310 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,358 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 2014/01/09 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 9,195 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 | 6,885 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 | 1,922 reads

Stairway to SQLCLR

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.  Read more...

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,380 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,360 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,530 reads

Visibility

By Steve Jones 2013/09/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,412 reads

Soundex - Experiments with SQL CLR

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

Restore SQL Server databases remotely using my SQL CLR

Has anyone ever though of pushing a SQL Server database backup out remotely? (SQL Native andor RedGate Backups) My idea...  Read more...
By andrew.fenna 2013/08/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,036 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,097 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,449 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 2013/05/08 | Source: SQLServerCentral.com | Category: pdf
Rating: |  Discuss |   Briefcase | 15,528 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 | 5,721 reads
   Items 1 to 20 of 71    Older >>
 
Tags
t-sql (7)    
c# (6)    
stairway series (5)    
administration (3)    
assembly (3)    
export (3)    
performance tuning (3)    
sql server 2005 (3)    
string manipulation (3)    
.net (2)    
aggregates (2)    
backup / restore (2)    
bcp (2)    
common language runtime (clr) (2)    
excel (2)    
regular expressions (2)    
udf (2)    
.net framework 3.5 (1)    
ado.net (1)    
async (1)    
barcodes (1)    
bit masking (1)    
bit masking using c# (1)    
blogs (1)    
bulkcopy (1)    
cryptography (1)    
data validation (1)    
data warehouse (1)    
delimited (1)    
disaster recovery (dr) (1)    
editorial (1)    
file copy (1)    
fnv (1)    
fnv1 (1)    
fnv1a (1)    
friday poll (1)    
function (1)    
functions (1)    
graph databases (1)    
hash (1)    
hashbytes (1)    
hashes (1)    
hashing (1)    
hierarchical data (1)    
hostname (1)    
hsa_256 (1)    
hsa_512 (1)    
import (1)    
indexed views (1)    
json (1)    
maintenance and management (1)    
mssql (1)    
multi threaded (1)    
multiple result sets (1)    
neo4j (1)    
nosql (1)    
open source (1)    
parse (1)    
parser (1)    
parsing (1)    
pdf (1)    
pivot (1)    
programming (1)    
qr code (1)    
regex (1)    
render (1)    
search (1)    
sha-2 (1)    
sha-256 (1)    
sha-384 (1)    
sha-512 (1)    
showplan (1)    
sql (1)    
sql clr (1)    
sql server (1)    
sql server 2008 (1)    
sql server express (1)    
sql# (1)    
stored procedure (1)    
stored procedures (1)    
stream (1)    
streaming table-valued function (1)    
string (1)    
stvf (1)    
tables (1)    
table-valued function (1)    
test driven development (1)    
training (1)    
trustworthy (1)    
uri (1)    
url (1)    
utility (1)    
visual studio 2010 (1)    
xml (1)    
xp_cmdshell (1)    
xp_fixeddrives (1)