SQL CLR

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2007-09-18

5,607 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2008-01-11 (first published: )

8,733 reads

Technical Article

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

SQLServerCentral Article

Creating a generic audit trigger with SQL 2005 CLR

  • Article

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.

3.43 (7)

You rated this post out of 5. Change rating

2006-08-02

19,026 reads

Blogs

The Data API Builder Start and Add Extensions in VS Code

By

One of the things that I like about the Data API Builder (DAB) is...

Using OneLake for Excel Files in Microsoft Fabric

By

Hey data friends! This blog is to discuss an edge case I’ve run into...

Another AI Faux Pax

By

I was experimenting with a local model (article) and as a part of this,...

Read the latest Blogs

Forums

AD, powershell and ssis

By stan

Hi, i have a requirement that involves visiting multiple folders in AD for active,...

File date from Extended Event .xel files

By Michael L John

I know this, but I do not remember it. I have scoured by saved...

SSMS gets very messy

By oRBIT

At work we have quite a few databases that I'm frequently browsing. This is...

Visit the forum

Question of the Day

Sparse Column Defaults

What are the restrictions for defaults on columns declared as sparse?

See possible answers