SQL CLR

Getting The Most Out of SQL Server 2005 UDTs and UDAs

  • Article

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.

5 (2)

2007-09-18

5,024 reads

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

  • Article

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.

4.67 (3)

2008-01-11 (first published: )

7,673 reads

CLR Inside Out

  • Article

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.

2006-12-15

2,929 reads

Practical SQL Server 2005 CLR Assemblies

  • Article

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:

2006-03-14

3,849 reads

Blogs

SQLCover 0.5 - Fixes, smaller features and an exciting surprise

By

It has been a little while but I have updated SQLCover to include a...

Switch activity in Azure Data Factory: Container with many IFs

By

(2019-October-16) Developing conditional logic of your Azure Data Factory control flow has been simplified with...

Setting Permissions for a SQL Server backup folder–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

More Network Restrictions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Network Restrictions, which is...

Extended Events- how to log to an SQL table?

By Maxer

I want to enable an Extended events session. However, I don't want it to...

Failed Executions

By heb1014

Curious what everyone else is doing... I've always had a daily report showing me...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers