We database developers would, of course, like easy access to all the .NET delights, such as the excellent Regex library, but we don't want a Do-It-Yourself kit to achieve this. So argues Phil Factor.
2018-12-12 (first published: 2015-01-19)
436 reads
Specialized tasks like cryptography require external libraries that are not available in SQL Server. Methods for such tasks can be compiled in a .NET language and deployed to SQL Server as a CLR assembly where the assembly's methods can be referenced by SQL Server stored procedures and functions.
2013-08-13
8,067 reads
2012-08-08
2012-03-17
2012-02-23
1 reads
2012-01-24
3 reads
2011-03-02
20 reads
2010-06-15
4 reads
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.
2007-09-18
5,392 reads
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.
2007-08-02
1,670 reads
By Steve Jones
Today’s coping tip is to discover your artistic side. Design a friendly greeting card....
So, we made it through our first 90 days, things start getting tougher now...
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...
Microsoft SQL Server is a relational database management system developed by Microsoft. As a...
Are you searching for Reflective Writing Help? Get best Reflective Writing Help with top experts. The...
In Transactional Replication, create index and Alter index commands do not get replicated to...
Ask SSC