sqlclr

Database Project with generic procedures to consume API through GET/POST methods.

SQL Server CLR function for running REST methods over HTTP

The detailed explanation could be found on Red Gate SimpleTalk's link 'An Easier Way of Transposing Query Result in SQL Server' https://www.red-gate.com/simple-talk/sql/t-sql-programming/easier-way-transposing-query-result-sql-server/

The detailed explanation could be found on Red Gate SimpleTalk's link 'SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server' https://www.red-gate.com/simple-talk/sql/sql-development/sqlclr-practice-creating-better-way-sending-email-sql-server/

A SQL CLR wrapper for parsing Json in SQL Server versions pre-2016

Transitive Closure Clustering with T-SQL, SQLCLR and JSON

Free SQLCLR functions tested on SQL Server 2019. That are used.

SQL Server SQLCLR Port of Uber H3's hexagon geospatial indexing system

Easily generate random human readable data using SQL Server’s SQL CLR.

A single stored procedure transformed into a multi-functional tool like a Swiss Army knife after exploitation — an attack-focused SQL CLR toolset: file system control, payload preparation, privilege escalation, and shellcode/assembly loaders.

PowerLib contains classes and extension methods for working with data structures and MSSQL server data.

SQL Server CLR function that uses System.Management to run WMI queries and return results as XML

.NET CLR code to call DOMO APIs directly from Microsoft SQL Server. Allows downloading data from DOMO directly into MS SQL server, reading users/groups/group membership from DOMO, and syncing a model of users/groups/group membership from SQL into DOMO.

SQL-CLR project for running file operations from within a SQL Server instance without needing xp_cmdshell

Blocked Process Report. Detailed explanation could be found on Red Gates SimpleTalk's link link 'Building a Custom Blocked Process Report' https://www.red-gate.com/simple-talk/sql/database-administration/building-custom-blocked-process-report/

Moca.NET SQLCLR Library

SQL Libary to export SQL query output to file

rabbitmq