Category: SQL

pgAdmin3 Install on Ubuntu

Installing the latest version of pgAdminIII can be challenging; here is a cheat sheet….

PostgreSQL Functions (Stored Procedures)

Some great resources and notes for working with PostgeSQL functions (stored procedures)…

Fix for Column Names in pypyodbc 1.3.3

I recently ran into an issue in pypyodbc 1.3.3 where column names would be truncated to the first character in the name….

Python, MSSQL, and using a Native Driver

A huge thank you goes out to Andrew, his blog, and his Git here! His scripts were a huge help getting unixODBC and Python 3 talking via the Microsoft ODBC Driver 11 for SQL Server – RedHat Linux on Ubuntu 14.04….

Helpful PostgreSQL Info

Many thanks to Sergey Pashinin and Christophe Pettus for their excellent videos here and here….

Linked Servers without openquery

Setting RPC Out…

CTE’s: How to use them and a great article…

Simple CTE Article…

Optimize for Ad Hoc Queries

Great article on this here!…