Microsoft SQL Server query tips
Get column details of a table Get column details of a table select name from sys.columns where object_name(object_id)=’table_name’ No related posts.
Author: robin
Cluster filesystem utilization alerts
This is a quick and raw method to setup alerts when the filesystem fill above threshold. Pre-requisites Monitored filesystems should be consistent, meaning available across all nodes passwordless ssh should be setup between the nodes. Node where the alert script...
Check version of installed python packages
Below bash command will let you find the version of packages for your python interpreter. Make sure you are running the correct version of python enterpreter. Update: 2020-05-14 for i in pandas numpy sqlalchemy logging logging.handlers datetime sys re os...
Download m3u8 URL video to local
Follow below steps to download video from a webpage Step 1: Finding m3u8 URL from webpage Open Chrome Developer tools and click the Network tab Navigate to the page with the video and get it to start playing Filter the...
Automate ports connectivity check using telnet and timeout
Check ports connectivity using automation with telnet and timeout commands. Timeout will help us not get blocked for a long time. Adjust the timeout value on case to case basis, # vi ~/check_my_server_hostname.sh timeout 2 bash -c “echo ‘exit’ |...
Connecting to msaccess database from Python
Connect to msaccess file from Python and tweak it to emit desired format. import pyodbc conn = pyodbc.connect(r’Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path where you stored the Access file\file name.accdb;’) cursor = conn.cursor() cursor.execute(‘select * from table name’) for row in...
Process JSON data in SQL Server 2012
Source: http://mtkcode.blogspot.com/2014/08/parse-json-string-by-sql-script.html SQL Server 2016 and above support JSON_VALUE function to parse JSONs. To process JSONs in older versions add this function to database – https://github.com/khanhmai/Parse-JSON-String-by-SQL-script/blob/master/ParseJSON-FUNCTION.sql Then we can write queries such as below, — Query sample 1 select *...
VirtualBox tips
Increase size of VDI file (Windows) Go to Virtualbox folder > cd “C:\Program Files\Oracle\VirtualBox” Run resize command (unit size is MB) Below command will make the disk size grow up to 16GB > VBoxManage modifyhd “C:\Users\robin\C:\Users\v737050\VirtualBox VMs\Centos 6\Centos 6.vdi” –resize...
Lightweight web application with Python Flask connecting to database using ODBC
Simple web app in Python using flask. This app connects to a database and compares the cost of calls, using new connection object each time, vs reusing same connection object HTH from flask import Flask import pyodbc...
