Exporting big data to TXT/CSV file using line command BCP to connect a MS SQL Server

 Hi my friends!

Exploring the BCP line-command from Microsoft SQL Server, using Windows Authentication, is very efficient exportation to .csv/.txt format, for extensive data volumes. I'm very impressive about performance returned, when extracted big volumes to a file.

Comand used on powershell:

bcp "SELECT * FROM [dbo].[YourTable]" queryout "C:\Temp\Exported_Data.csv" -S localhost -d DataBaseName -T -c

This is a very good tool to work with extensive data exportation.

Adaptive High Light for Voltz EVS to Open Automatic Gate (DIY)

 This article help you to create a little project to active your remote control. This control can open your home gate and any others.

Let's getting start!

Components list:

1 Resistor with 1/4W (0,25W) with 1K ohm (Brown-Black-Red)

1 Electrolytic Capacitor with 470uF and 16V. Greater voltage is accepted, but more bigger.

1 Mini Relay 12V

12V comes from switch that enables hight light (Pulse).

N/C is Not Connected.

Enable Control is a 12V pulse to switch control (when this control enable by Vcc Pulse)

How Stuff Works:

When 12V came from hight light switch, the 470uF electrolytic capacitor is a short-cut. So in the first time, the Relay will be enabled. About 1 secound, is enough time to pulse the control switch and open relay again. Constant current to remote control can burns it. So, this "timer" is really necessary. This technic is a automatic reset for relay. When hight light is released, no reverse current coming from relay inductor, because capacitor feed the inductor with your current, losing energy quickly, drained by inductor and resistor.

 Important: When the high light is enable at the full time, the resistor drains about 15mA. But only when high light is enabled.

The control used in my prototype was a Peccinin with a variable token generator.

Peccinin Control

Good luck and enjoy!

Installing Pyhton with Pandas on MacOS Intel/AppleSilicon

1. Installing Python on MacOS: https://www.python.org/downloads/
2. Run on terminal: sudo pip install pandas
3. After: pip install --user pandas
4. So, pip3 install pandas
5. pip3 install upgrade pip
6. Finally, pip install pandas
7. Make a test on IDLE console: import pandas
8. If the line command returns nothing, pandas is already in your MacOS.