Programming — Dirceu Resende

Azure Data Factory (ADF) - How to Create Offline Documentation (in CSV) for Your Project

October 3, 2021 10 min read

Powershell - Script to list and export to CSV all files in a directory with name, directory, size, and duration attributes

June 14, 2021 2 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

How to Connect to SQL Server Using PHP (Xampp) and the PDO Driver on Windows

November 12, 2017 5 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

Analysis Services - How to Use XMLA or PowerShell to Process Cubes and Dimensions via T-SQL or SQL Agent Job

August 6, 2017 10 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

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

September 11, 2016 6 min read

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

August 12, 2016 17 min read

How to Compress Directories into ZIP Files Using 7-Zip and CMD

August 6, 2016 2 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 batch run all .sql scripts from a folder or directory with SQLCMD

June 14, 2016 3 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

Links to download Microsoft Visual Studio 2015 and SQL Server 2014

November 29, 2015 3 min read

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

July 27, 2015 2 min read

Implementing Friendly URL in Apache with .htaccess and PHP

April 2, 2015 7 min read

Avoiding Duplicate Content on Apache Web Server Using .htaccess

March 27, 2015 1 min read

Running PHP Scripts Automatically Through Crontab on Linux

March 16, 2015 4 min read

Introduction to the jQuery Javascript framework

March 16, 2015 4 min read

Protheus - Names and descriptions of TOTVS ERP tables

January 26, 2015 10 min read

Configuring PHP for connection to a Firebird (Interbase) database

December 21, 2014 2 min read

Exporting query data to CSV using Firebird (Interbase) and PHP

December 21, 2014 2 min read

How to increase PHP session and execution time using .htaccess

November 25, 2014 1 min read

Upload and download files via the FTP protocol with PHP

November 23, 2014 3 min read

Exporting query data to CSV using MySQL and PHP

November 23, 2014 2 min read

Writing numbers in words in PHP

June 8, 2014 2 min read

Removing number formatting in PHP

June 8, 2014 1 min read

Converting date formats in PHP

June 7, 2014 1 min read

Creating Gradient Effects with CSS

June 7, 2014 1 min read

Removing all files from a directory with PHP

June 7, 2014 2 min read

Adding and subtracting dates and times in PHP

June 7, 2014 3 min read

Listing files with PHP

June 7, 2014 2 min read

Reading and writing text files in PHP

June 7, 2014 1 min read