Integrations

SQL Server – How to consult the dollar (USD), euro (EUR) or any other currency in real time with API and SQLCLR

June 10st, 2021
1
Database CLR Query Development Integrations SQL Server

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

December 1, 2018
2
Database Integrations Maintenance OLE Automation SQL Server

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

15 July 2018
4
Database Integrations Monitoring Python SQL Server

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

June 20st, 2018
4
Database Integrations SQL Server

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

June 10st, 2018
1
Database C # (CSharp) CLR Integrations File Handling SQL Server SQLCLR

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

22 May 2018
3
Database CLR Integrations SQL Server SQLCLR

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

September 2th, 2017
0
Database C # (CSharp) CLR Integrations Monitoring Programme SQL Server

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

August 23st, 2017
4
Database Little Known Features Hacks Integrations SQL Server

Analysis Services - How to use XLMA or Powershell to process cubes and dimensions via command line (T-SQL) or SQL Agent Job

August 6st, 2017
0
Analysis Services (SSAS) Database Business Intelligence (BI) Integrations Powershell / CMD SQL Server

SQL Server - How to Track Orders and Mail Objects (After WEBSRO Deactivated)

21 July 2017
6
Database CLR Integrations OLE Automation SQL Server