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,008 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,640 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

A simple Machine Learning process example (supervised) – just to start with

By

I have just written the fifth article of the Machine Learning topic. !!! This...

Always On: Troubleshooting Consolidated

By

Working on Always On and configuration/setup of AG we have observed many errors. especially...

Changing Git Credentials in Windows

By

tl;dr For Windows when you need a different account. I had to work with...

Read the latest Blogs

Forums

WhatsApp/Call:+1(859)740-9292"buy original ielts,pmp,gre,pte,pgmp,cisco Thailand

By Workbarron010

"WhatsApp/Call:+1(859)740-9292"buy original ielts,pmp,gre,pte,pgmp,cisco certificates in malaysia/Thailand

"Getcertified10@yahoo.com"buy ielts,pmp,gre,pte,pgmp,cisco certificates in Qatar

By Workbarron010

"Getcertified10@yahoo.com"buy ielts,pmp,gre,pte,pgmp,cisco certificates in hyderabad,Qatar

SSRS page number by a certain column grouping

By Siten0308

Hello, I have been givin a task and not sure how to handle this,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers