Data Science

Relevant Process Monitoring - Database Loading and Business Rules

It's a monitoring to check if it has any relevant jobs, tasks, database loading or business rules  "stopped".   Currently, we are monitoring if it has any issues, but not if it's stopped.   Considering the company has a monitor to show up the monitoring from...

Flash the Window Application if the Monitoring Data is achieving the Threshold in C#

It shows only the method to flash the Windows:     ===================================================== Calling the Class: ===================================================== // One this to note with this example usage code, is the "this" keyword is referring to // the...

Developing a Windows Service for Data Extraction

This solution was built to supply a third party application developed in a legacy solution called PFX.   That simple Windows application, runs every day, calling a command line that exports the PFX application to Text...

SQL Server Disk Monitoring in Power BI

I'd decided to build that monitoring to prevent any disk space issues, it's the complement from my Power BY Dashboard monitoring I have been enhancing, also, that has been very useful for my daily chores. This is the mobile interface:     My SQL Dashboard...

Developing an ETL in SSIS with C# and Python to Load a Call Centre Data in a complex Excel File

I've decided to build the ETL using Python because of the complexity to read an Excel Spreadsheet with different levels, also, due to the simple way to develop the code.     This is the complex Excel file I need to load every month:   I sorted it out building that Python...

Loading Excel Spreadsheet loading via Python

I've developed that solution in Python through the VS 2017: This is the Excel spreadsheet I'm loading: These are the codes:   #ExcelConnection.py =============================================================================================================   from xlrd...

Python Library Configuration in Windows Command Line

Library: Pandas - SQL Access  Installation: c:\Python\pipi install pandas   Library: Pyodbc- ODBC Drivers  Installation: c:\Python\pipi install pyodbc Library: xlrd- Excel Drivers (Excel Installation is not required with that driver) Installation: c:\Python\pipi...

Python Server Installation in Windows

https://www.python.org/downloads/   Library: Pandas - SQL Access  Installation: c:\Python\pip install pandas   Library: Pyodbc- ODBC Drivers  Installation: c:\Python\pip install pyodbc Library: xlrd- Excel Drivers (Excel Installation is not required with that...

MSFull-Text searching exactly text by CONTAINS

    declare @SearchContent varchar(100) = '4 wheel drive' declare @ModifiedSearchContent varchar(100) = '"'+ @SearchContent+'"'     select SearchContent, * from marsweb_CarIndex where CONTAINS (SearchContent, @ModifiedSearchContent)  AND SearchContent LIKE...

ElasticSearch Post and Get (Samples)

--// Create =======================================================   POST https://localhost:9200/carconfigindex/cartitle/1 {     "title":"Toyota 4x4" }   POST https://localhost:9200/carconfigindex/cartitle/2 {     "title":"Toyota...

1 | 2 | 3 | 4 | 5 >>

Crie um site com

  • Totalmente GRÁTIS
  • Centenas de templates
  • Todo em português

Este site foi criado com Webnode. Crie um grátis para você também!