CLR — Dirceu Resende

[PowerLive] - Power CLR: APIs, Files and MUCH more directly in SQL Server

May 8, 2025 1 min read

Meet Power CLR: SQL Server integration with APIs, files, webservices, FTP, and much more!

May 9, 2023 3 min read

SQL Server - How to Validate Email and Email Domain Using SQLClr (C#)

May 26, 2022 14 min read

SQL Server - How to query the dollar (USD), euro (EUR), real (BRL), or any other currency rate in real time with API and SQLCLR

June 11, 2021 16 min read

SQL Server - How to send messages to WhatsApp contacts, groups and broadcast lists via API

December 2, 2019 35 min read

[Video] - Introduction to SQLCLR

August 4, 2018 1 min read

SQL Server - How to compress and decompress files and directories using 7-zip and xp_cmdshell or SQLCLR (C#)

June 10, 2018 9 min read

SQL Server - How to capture data from a Web page (Webscraping with HttpRequest) and insert the data into the database with SQLCLR (C#)

May 23, 2018 18 min read

SQL Server - How to Use Regular Expressions (REGEXP) in Your Database

May 22, 2018 22 min read

SQL Server - Using the FORMAT() Function to Apply Masks and Formatting to Numbers and Dates

October 10, 2017 15 min read

SQL Server - How to read and write events in Windows Event Viewer using CLR (C#)

September 2, 2017 5 min read

SQL Server - How to convert an RTF string to text (Remove RTF tags) using CLR (C#) or PowerShell

August 8, 2017 8 min read

SQL Server - How to convert an HTML string to text (Remove HTML tags) using CLR (C#)

August 8, 2017 3 min read

SQL Server - How to track Correios packages and items after WEBSRO deactivation

July 21, 2017 6 min read

SQL Server - Table-Valued Function to Split a String into Rows with Size Up to N Characters

July 21, 2017 2 min read

SQL Server - How to calculate the difference in years (age) between two dates using T-SQL or CLR

April 9, 2017 4 min read

SQL Server - Performance Comparison Between Scalar Function (UDF) and CLR Scalar Function

March 24, 2017 14 min read

SQL Server - How to export and import tabular data files (for example, CSV) using CLR (C#)

March 20, 2017 8 min read

SQL Server - How to query and consume WordPress RSS feeds using CLR or xp_cmdshell (cURL)

March 19, 2017 8 min read

SQL Server - How to calculate the distance between two points using the Google API (ZIP code, address, or latitude and longitude)

March 7, 2017 4 min read

SQL Server 2016 - How to query ZIP code information using the Bemean API and the JSON_VALUE function

March 5, 2017 4 min read

SQL Server - Implementing Access Control and Audit Logs in CLR (C#) Usage

February 28, 2017 5 min read

SQL Server - How to identify and monitor disks, total, free, and used disk space

February 26, 2017 10 min read

SQL Server - How to export a CLR assembly as a DLL and reverse engineer it to C# source code

February 25, 2017 4 min read

SQL Server - How to back up all SQL Agent jobs via command line (CLR C# or PowerShell)

February 22, 2017 9 min read

SQL Server - How to integrate the database with Telegram and send messages using CLR (C#)

February 5, 2017 8 min read

SQL Server - How to integrate the database with Slack and send messages using CLR (C#)

February 4, 2017 9 min read

SQL Server - How to integrate the database with Ryver and send messages using CLR (C#)

February 4, 2017 5 min read

SQL Server - How to send SMS Torpedoes using the CLR (C#) and the Mais Resultado API (PG Soluções)

February 4, 2017 7 min read

SQL Server - How to send emails from the database using CLR C#

January 31, 2017 8 min read

SQL Server - How to send the result of a query by email in HTML format using the CLR (C#)

January 28, 2017 9 min read

SQL Server - How to monitor your favorite TV shows by consuming a JSON webservice with JSON_VALUE and CLR (C#)

January 25, 2017 4 min read

SQL Server - How to encrypt and decrypt passwords (with Salt) using CLR (C#)

December 2, 2016 4 min read

SQL Server - How to query national, state, municipal, and optional holidays from an API using OLE Automation and CLR (C#)

December 1, 2016 4 min read

SQL Server - How to integrate with FTP and list, upload, and download files using CLR (C#)

November 6, 2016 18 min read

How to create a random password generator written in PHP, C# (CSharp) or Transact-SQL (T-SQL)

September 18, 2016 3 min read

How to use the Pushbullet API to send SMS messages in C#, PHP, Java or through SQL Server (with CLR)

September 11, 2016 9 min read

SQL Server - How to list and kill Windows processes using CLR (C#)

September 11, 2016 5 min read

SQL Server - How to run PowerShell and Prompt-DOS (MS-DOS) scripts using CLR (C#)

September 11, 2016 6 min read

SQL Server - How to read, list, create, update, and delete Windows Registry keys with CLR (C#)

September 10, 2016 7 min read

How to validate state registration for all states using C# and SQL Server CLR

August 12, 2016 17 min read

SQL Server - How to stop, start, and list Windows services remotely

August 7, 2016 8 min read

SQL Server - How to send warnings and error messages to the database using CLR C#

August 7, 2016 4 min read

SQL Server - How to Check if a Server is Responding Using Ping and CLR (C#)

August 6, 2016 1 min read

CSharp (C#) - How to sort files returned by DirectoryInfo.GetFiles using Natural Sort

July 2, 2016 5 min read

SQL Server - How to concatenate rows grouping data by a column (Grouped concatenation)

June 19, 2016 9 min read

SQL Server - The Server May Be Running Out of Resources or the Assembly May Not Be Trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE

June 16, 2016 2 min read

SQL Server - How to export database data to a text file (CLR, OLE, BCP)

June 3, 2016 16 min read

SQL Server - How to import text files into the database (OLE Automation, CLR, BCP, BULK INSERT, OPENROWSET)

May 29, 2016 7 min read

SQL Server - How to list, read, write, copy, delete and move files with CLR (C#)

May 7, 2016 11 min read

SQL Server - The Database Owner SID Recorded in the Master Database Differs from the Database Owner SID Recorded in Database

April 21, 2016 3 min read

CLR - Solving the System.Security.Permissions.FileIOPermission problem in SQL Server

March 30, 2016 2 min read

Visual Studio - Solving the sgen.exe / .NET Framework SDK Build Error

March 29, 2016 3 min read

Performing POST and GET requests using CLR (C#) in SQL Server

March 29, 2016 20 min read

Introduction to SQL CLR (Common Language Runtime) in SQL Server

March 24, 2016 18 min read

Solving .NET Framework DLL Assembly signature problems in SQL Server

September 10, 2015 1 min read

How to remove accents and special characters from a string in SQL Server

July 27, 2015 2 min read