Archive | GreenPlum MPP

Parse pg_dump Functions and Views Into Their Own Files (GreenPlum / Postgres)

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesHere's what we wanted: […]

SQL Server T-SQL To GreenPlum PostgreSQL Syntax Cheat Sheet

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesHere's a quick translation […]

GreenPlum MPP Tool Review: Navicat For Postgres

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesI've spent a few […]

SQL Server To GreenPlum MPP/Postgres Transition

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesI'm working with a […]

Which code page for UTF-8?

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesIf you're trying to […]

SSIS Export To UTF-8 or UNIX (or how to set your code page to output a flat file for unix)

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesAs more and more […]