Integrations — Dirceu Resende

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

Is your SQL Server up to date? Returning the latest Service Pack (SP) or Cumulative Update (CU) version for your instance

December 1, 2018 9 min read

SQL Server - How to integrate the database with Slack and send messages using Python and sp_execute_external_script

July 15, 2018 8 min read

SQL Server - How to calculate the distance between two places using latitude and longitude (without API)

June 20, 2018 3 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 read and write events in Windows Event Viewer using CLR (C#)

September 2, 2017 5 min read

SQL Server - How to query Active Directory (AD) information using Linked Server (ADSI)

August 23, 2017 5 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 - How to track Correios packages and items after WEBSRO deactivation

July 21, 2017 6 min read

Analysis Services - Querying Catalog Views from SQL Server

April 2, 2017 3 min read

Analysis Services (SSAS) - How to Query Information and Process Commands via XMLA Command Line from SQL Server

April 2, 2017 4 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 - 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 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 integrate with FTP and list, upload, and download files using CLR (C#)

November 6, 2016 18 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 run PowerShell and Prompt-DOS (MS-DOS) scripts using CLR (C#)

September 11, 2016 6 min read

SQL Server - How to export the source code of all Stored Procedures, Functions, Views and Triggers from a database to .sql files

August 25, 2016 6 min read

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

March 29, 2016 20 min read

Querying Correios object tracking through SQL Server

January 3, 2016 3 min read

Consuming the Google Maps API to get address or ZIP code information in SQL Server

January 3, 2016 4 min read

How to Calculate Shipping Cost and Delivery Time Using Correios WebService in SQL Server

August 23, 2015 5 min read

How to Query Postal Code (CEP) Information in SQL Server

August 23, 2015 2 min read

Consuming the Google Maps API using OLE Automation in SQL Server

July 27, 2015 3 min read

How to use JSON in SQL Server 2008, 2012 and 2014 - Reading JSON strings, importing into the database and exporting to XML

July 25, 2015 14 min read

How to export data from a SQL Server table to HTML

July 12, 2015 7 min read