C# — Dirceu Resende

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

December 2, 2019 35 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 - 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 recover the source code of an encrypted object (WITH ENCRYPTION)

August 22, 2017 8 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 - 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 2016 - How to query ZIP code information using the Bemean API and the JSON_VALUE function

March 5, 2017 4 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 Slack and send messages using CLR (C#)

February 4, 2017 9 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 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

Login failed for user error when connecting to SQL Server from a .NET (C#) application

November 23, 2016 6 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

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

August 12, 2016 17 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 list, read, write, copy, delete and move files with CLR (C#)

May 7, 2016 11 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

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

July 27, 2015 2 min read