Getting Started with the SQL Server CLR

Learn more about LogicalRead: bit.ly/LogicalRead13
See how to get started using the SQL Server CLR by working through the creation of a SQL Server CLR stored procedure.
Connect with SolarWinds:
thwack Community: thwack.solarwinds.com/
Facebook: / solarwinds
Twitter: / solarwinds
LinkedIn: / solarwinds
Instagram: / solarwindsinc

[@marcelobeani]

Nice video, cheers from Brazil.

[@jwebbzor]

Knowing which Visual Studio Template to use was the most important part...

[@datatechtips653]

I think in this Video, the Visual Studio Template that presenter used was: "SQL Server Database" project and the class-type / new item added was: SQL CLR C# Stored Procedure (by default named as "SqlStoredProcedure1.cs"). HTH

[@roland9720]

Thanks for the video. Nice pressentation.

[@PatricioAlvarezRojas]

thank u , you make my day

[@Jay_1509]

Thanks for this :)

[@maadhufinance]

Thank u ,Sir

[@afzaalawan]

Excellent.. I am DBA but never know this..

[@ashaseeb]

thank you!!!
what do you suggest for RESTful API calls from SSIS?
You suggest to use third party tool? or write dot net code to use it in SQL CLR? pls suggest

[@michaelotey8440]

I notice a couple of questions about the versions of SQL Server and Visual Studio that I used here. The SQL Server version was SQL Server 2014 Express. The CLR is supported in all of the different editions of SQL Server. The code itself was created using an early version of the Visual Studio 2015 Community edition. You can create a SQLCLR object with just about any version of Visual Studio -- even Visual Studio Express and use the manual deployment steps that I describe here to deploy your SQLCLR DLLs. If your version of Visual Studio doesn't have the Database Templates you can just use the class library project to create the DLL, manually add the SQL Server namespaces and then manually deploy the DLL to the SQL Server system.

[@dominicro]

What type of visual studio template did you use ?

[@mario17-t34]

What type of project and template in VS ??? Tx much. Trying to replicate on 2017 VS and can't

[@solarwinds]

As 2017 wasn’t released at the time this video was produced, no testing was done for 2017 VS. There may have been changes to VS or CLR that prevent this example from working successfully in later versions.

[@Linkario86]

It keeps on failing cause CREATE or ALTER ASSEMBLY for assembly 'CLR_Lab' with the SAFE or EXTERNAL_ACCESS option failed because the 'clr strict security' option of sp_configure is set to 1. Microsoft recommends that you sign the assembly with a certificate or asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. Alternatively, you can trust the assembly using sp_add_trusted_assembly.

[@menphalla]

which version of visual studio and sql server?

[@solarwinds]

Please see Michael Otey's response above.