Using Python to access SQL Server

Install the required packages UnixODBC and FreeTDS packages yum install -y unixODBC unixODBC-devel freetds Configure unixODBC Add the content below to the file /etc/odbcinst.ini [FreeTDS] Description=ODBC for SQL Server Driver=/usr/lib/libtdsodbc.so Setup=/usr/lib/libtdsS.so FileUsage=1 Configure FreeTDS Add the content below to the file /etc/freetds.conf tds version = 8 client charset = UTF-8 Install pypyodbc to Python handle ODBC connections pypyodc is a pure python ODBC interface. For more information access https://code.google.com/p/pypyodbc/ I’m using pip to install it....

August 7, 2014 · 2 min · Danilo Fernando Chilene

Monitoring Oracle with Zabbix

In the past I used Zabora to monitor Oracle, but for large environments was a pain to admin and let’s not talk about monitor tons of tablespaces. I tried to use other things like Orabbix but since is Java I preferred stay away. Today Zabbix have some nice improvements like macros and Discovery, so we can set the database settings(user,password,database and such) on the host using macros and not hard code it on a script that you have to access a server to change it....

December 9, 2013 · 3 min · Danilo Fernando Chilene