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,604 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,730 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,024 reads

Blogs

Data Masking with Azure Databricks

By

“Alice: Would you tell me, please, which way I ought to go from here?The...

Grinding Away: Mary Spender

By

A few years ago I stumbled on this video and loved it. That led...

PASS Summit 2024 – A new experience

By

I attended the PASS Data Community Summit held in Seattle in person this year...

Read the latest Blogs

Forums

How do I fix the, "Unable to process the existing user settings" error message?

By Rod at work

I'm sure I've asked this question in either this forum, or another one, in...

Cannot restore new DB

By Edvard Korsbæk

I have made an empty DB called "HJEM_BB" I try to fill it from...

How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server

By Noman072

Comments posted to this topic are about the item How to Avoid Incorrect Results...

Visit the forum

Question of the Day

The AG Secondary Logs

What happens when an AG secondary receives a log record from the primary?

See possible answers