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,642 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,764 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,051 reads

Blogs

Truncate Table Pitfalls

By

 Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....

dataMinds Connect 2025 – Slides & Scripts

By

You can find all the session materials for the presentation “Indexing for Dummies” that...

“SQL Server Is Slow” Part 4 of 4

By

Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...

Read the latest Blogs

Forums

visual studio seems to lose "provider" on pkg imports

By stan

hi, just to get this part out of the way, if my intended target...

ERD Tools recommendation

By Coffee_&_SQL

Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...

Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Visit the forum

Question of the Day

Vector Datatype Dimensions

The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?

See possible answers