SQL # Expanding the capabilities of T-SQL pdf

Welcome to SQL# (SQLsharp).  SQL# is a small .Net / CLR library (Assembly to be specific) 
that resides in a SQL Server 2005 (or newer) database and provides a suite of User-Defined 
Functions, Stored Procedures, User-Defined Aggregates, and User-Defined Types.  This set of tools 
is designed to make the lives of countless SQL Server professionals easier by providing the broad 
range of commands available in most other languages outside of SQL (we will not speak of JCL or 
IBM‘s horrendous Net.Data).  The User-Defined Functions and Stored Procedures are all prefixed 

with a ―library‖ name much like you would find in C#, Java / J#, C++, VB.Net, etc.  The names of the 
commands are in mixed case but SQL Server is not case-sensitive so it does not matter if you use 
capitals or not.  Most of the functions will work in SAFE_ACCESS mode (this refers to security setting
of the SQL# Assemblies within Microsoft SQL Server).  If you want to use the functions that access 
the Internet or the file-system, then you will have to change the security setting of the SQL# Assembly
that has the function(s) that you wish to use to be  EXTERNAL_ACCESS or maybe even 
UNRESTRICTED (so far only functions inside of the SQL#.OS Assembly require this security level).  
See details on SQLsharp_SetSecurity for more information on security levels.