GitHub

sql-clr-type-mismatches.md

SQL-CLR Type Mismatches [!INCLUDE vbtecdlinq] automates much of the translation between the object model and SQL Server. Nevertheless, some situations prevent exact translation. These key mismatches ...
GitHub

sql-clr-type-mapping.md

In LINQ to SQL, the data model of a relational database maps to an object model that is expressed in the programming language of your choice. When the application runs, LINQ to SQL translates the ...
Visual Studio Magazine

A CLR Alternative to the SQL Server ISNUMERIC function

Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...
adtmag.com

Equal Footing is Key Feature of Microsoft SQL Server 2005

The Common Language Runtime is at the heart of Microsoft’s .NET vision. It promises to co-opt the benefits of Java–it’s a run-time environment that features a just-in-time compiler and built-in ...
eWeek

SQL Server 2005s Incredibly Cool CLR Integration

T-SQL is great for database code, but writing procedural code in T-SQL has always been difficult. Invariably, your project includes a stored procedure or two, requiring some text parsing or complex ...
Ars Technica

Resource files for CLR procedure in SQL 2005?

I've googled for this on several occasions, but not really found any good information. I have a SQL 2005 CLR procedure that builds dynamic (parameterized) SQL. I basically have a main statement, and a ...
IEEE

Exploitation of SQL Common Language Runtime Assemblies: A Novel Attack Vector for Compromising Microsoft SQL Server Environments

Abstract: This research investigates a novel attack technique employed by cybercriminals to compromise Microsoft SQL (MS SQL) servers. The attackers leverage the functionality of MS SQL Common ...