http://www.sqlservercentral.com/Content tagged SS2K5 - CLR Integration posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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. http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/2798/2008/01/11http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/2798/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. http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/3208/2007/09/18http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/3208/SQL Server's CREATE ASSEMBLY statement lets you catalog code with one of three predefined security buckets. But under the covers, there are actually two distinct security models at play: Code Access Security and Host Protection, and you need to understand both. http://www.sqlservercentral.com/redirect/articles/3121/2007/08/02http://www.sqlservercentral.com/redirect/articles/3121/This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.http://www.sqlservercentral.com/redirect/articles/3099/2007/07/25http://www.sqlservercentral.com/redirect/articles/3099/With SQL 2005 you can harness the power of a higher-level language to not only do more with stored procedures, but also save time by already knowing a popular .NET language.http://www.sqlservercentral.com/redirect/articles/3081/2007/07/11http://www.sqlservercentral.com/redirect/articles/3081/One other use of the new CLR integration in SQL Server 2005 is the ability to create user defined data types using managed code. Author Dinesh Priyankara brings us a first look at this capability with some code you can use. http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/userdefineddatatypesinsqlserver2005/1979/2007/05/25http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/userdefineddatatypesinsqlserver2005/1979/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. http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/2798/2008/01/11http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/2798/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.http://www.sqlservercentral.com/redirect/articles/2719/2006/12/15http://www.sqlservercentral.com/redirect/articles/2719/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. http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/creatingagenericaudittriggerwithsql2005clr/2502/2006/08/02http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/creatingagenericaudittriggerwithsql2005clr/2502/s running .NET Framework code within SQL Server 2005 exciting or a threat? Which is it? This article explores the security issues of SQLCLR code so that both developers and DBAs can make informed decisions about its use. http://www.sqlservercentral.com/redirect/articles/2451/2006/06/15http://www.sqlservercentral.com/redirect/articles/2451/Mapping services have become quite popular on the Internet and with many applications, but in order to use these, you need to map an address to a latitude and longtitude. Corey Bunch brings us a CLR example of how you can do this. http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/geocodingwithsqlserver2005/2373/2006/05/01http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/geocodingwithsqlserver2005/2373/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: http://www.sqlservercentral.com/redirect/articles/2318/2006/03/14http://www.sqlservercentral.com/redirect/articles/2318/This paper describes the new CLR integration features of SQL Server 2005 and how database application developers and architects can take advantage of them to write user-defined procedures, functions, and triggers, as well as define new types and aggregateshttp://www.sqlservercentral.com/redirect/articles/2171/2005/11/30http://www.sqlservercentral.com/redirect/articles/2171/One other use of the new CLR integration in SQL Server 2005 is the ability to create user defined data types using managed code. Author Dinesh Priyankara brings us a first look at this capability with some code you can use. http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/userdefineddatatypesinsqlserver2005/1979/2007/05/25http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/userdefineddatatypesinsqlserver2005/1979/