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,037 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,694 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

Distributing Jupyter Notebooks

By

If you’re working with the Microsoft Data Platform, you should be, at the least,...

SQLSaturday Orlando Notes – Large Printed Schedules

By

One of the things we’ve done most years in Orlando is to print poster...

Upgrading Windows 10 Home to Pro

By

I use Hyper-V and a few other things that require Windows 10 Pro. When...

Read the latest Blogs

Forums

RPC:Completed,sp:Stmtcompleted, SQL:BatchCompleted and SQL:stmtCompleted

By 892717952

what are their differences among EventClass of RPC:Completed,sp:Stmtcompleted, SQL:BatchCompleted and SQL:stmtCompleted under SQL Profiler...

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

By Additional Articles

Comments posted to this topic are about the item Deploying Data and Schema Together...

SQL Server Name Convention and T-SQL Programming Style

By kast218

Comments posted to this topic are about the item SQL Server Name Convention and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers