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

Content with tag SQL CLR Rss

   Items 1 to 15 of 15   
 

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

Using CLR integration to compress BLOBs/CLOBs in SQL Server 2005

Working with large objects, BLOBs in SQL Server, has always been a little tedious. The forums are filled with questions on this topic. New authro Yoel Martinez brings us a more advanced looked at BLOBs in SQL Server 2005 with code and a technique for compressing large amounts of data to save space.   Read more...
By Yoel Martinez 2007/01/30 | Source: SQLServerCentral.com | Category: sql clr
Rating: |  Discuss |   Briefcase | 7,495 reads

Getting The Most Out of SQL Server 2005 UDTs and UDAs

The CLR integration in SQL Server 2005 greatly expands on the capabilities of the SQL Server platform. One new area is the ability to build user-defined types and user-defined aggregates. Solomon Rutzky brings us a way to get around some of the limitations in this area with his SQL# toolkit.   Read more...
By Solomon Rutzky 2007/09/18 | Source: SQLServerCentral.com | Category: sql clr
Rating: |  Discuss |   Briefcase | 4,770 reads

SQLCLR Security and Designing for Reuse

SQL Server's CREATE ASSEMBLY statement lets you catalog code with one of three predefined security buckets. But under the covers, there are actually two distinct security models at play: Code Access Security and Host Protection, and you need to understand both.   Read more...
By Additional Articles 2007/08/02 | Source: DevX | Category: sql clr
Rating:  Rate this |   Briefcase | 1,185 reads

A T-SQL Regular Expression Library for SQL Server 2005

This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.  Read more...
By Additional Articles 2007/07/25 | Source: CodeProject.com | Category: .net
Rating:  Rate this |   Briefcase | 3,628 reads

Using CLR Integration in SQL 05 for Writing Stored Procedures

With SQL 2005 you can harness the power of a higher-level language to not only do more with stored procedures, but also save time by already knowing a popular .NET language.  Read more...
By Additional Articles 2007/07/11 | Source: InformIT | Category: sql clr
Rating:  Rate this |   Briefcase | 2,685 reads

User Defined Data Types in SQL Server 2005

One other use of the new CLR integration in SQL Server 2005 is the ability to create user defined data types using managed code. Author Dinesh Priyankara brings us a first look at this capability with some code you can use.   Read more...
By Dinesh Priyankara 2007/05/25 (first published: 2005/08/02) | Source: SQLServerCentral.com | Category: sql clr
Rating: |  Discuss |   Briefcase | 35,167 reads

Using CLR integration to compress BLOBs/CLOBs in SQL Server 2005

Working with large objects, BLOBs in SQL Server, has always been a little tedious. The forums are filled with questions on this topic. New authro Yoel Martinez brings us a more advanced looked at BLOBs in SQL Server 2005 with code and a technique for compressing large amounts of data to save space.   Read more...
By Yoel Martinez 2007/01/30 | Source: SQLServerCentral.com | Category: sql clr
Rating: |  Discuss |   Briefcase | 7,495 reads

CLR Inside Out

This article is meant to explore these architectural issues from the bottom up, and aims to guide you through this new world. In the long run, new programming models are likely to appear that will abstract away a lot of the challenges you will encounter.  Read more...
By Additional Articles 2006/12/15 | Source: MSDN Communities | Category: sql clr
Rating:  Rate this |   Briefcase | 2,562 reads

Creating a generic audit trigger with SQL 2005 CLR

Auditing is becoming more important all the time for DBAs as regulations and requirements increase. Building auditing into your systems can be done a number of ways, but with SQL Server 2005, you have a new option. New author David Ziffer brings us a generic auditing CLR trigger.   Read more...
By David Ziffer 2006/08/02 | Source: SQLServerCentral.com | Category: sql clr
Rating: |  Discuss |   Briefcase | 18,363 reads

Security in the CLR World Inside SQL Server

s running .NET Framework code within SQL Server 2005 exciting or a threat? Which is it? This article explores the security issues of SQLCLR code so that both developers and DBAs can make informed decisions about its use.   Read more...
By Additional Articles 2006/06/15 | Source: DevX | Category: sql clr
Rating:  Rate this |   Briefcase | 2,256 reads

Geocoding with SQL Server 2005

Mapping services have become quite popular on the Internet and with many applications, but in order to use these, you need to map an address to a latitude and longtitude. Corey Bunch brings us a CLR example of how you can do this.   Read more...
By Corey Bunch 2006/05/01 | Source: SQLServerCentral.com | Category: sql clr
Rating: |  Discuss |   Briefcase | 18,458 reads

Practical SQL Server 2005 CLR Assemblies

One advantage of CLR assemblies is the ability to consume web services from within the database. This wouldn’t be easy with T-SQL, and would also require a lot of work in an unmanaged extended stored procedure. With .NET, it’s almost as simple as accessing a local DLL. There are just a couple of extra command-line utilities we need to run to be able to access web services from within a SQL assembly:   Read more...
By Additional Articles 2006/03/14 | Source: Red-Gate | Category: sql clr
Rating:  Rate this |   Briefcase | 3,406 reads

Using CLR Integration in SQL Server 2005

This paper describes the new CLR integration features of SQL Server 2005 and how database application developers and architects can take advantage of them to write user-defined procedures, functions, and triggers, as well as define new types and aggregates  Read more...
By Additional Articles 2005/11/30 | Source: MSDN Communities | Category: sql clr
Rating:  Rate this |   Briefcase | 3,518 reads

User Defined Data Types in SQL Server 2005

One other use of the new CLR integration in SQL Server 2005 is the ability to create user defined data types using managed code. Author Dinesh Priyankara brings us a first look at this capability with some code you can use.   Read more...
By Dinesh Priyankara 2007/05/25 (first published: 2005/08/02) | Source: SQLServerCentral.com | Category: sql clr
Rating: |  Discuss |   Briefcase | 35,167 reads
   Items 1 to 15 of 15   
 
Tags
sql server 2005 (12)    
.net (1)    
common language runtime (clr) (1)    
cryptography (1)    
programming (1)    
sqlclr (1)    
triggers (1)    
t-sql (1)