Author: robin
Building .net project from command line
Stuck with no Visual Studio or a .net programming IDE?
May be this can save you when you only want to compile a .net project.
Redshift performance investigation
Trying to make an attempt to build better performing redshift tables… Queries that has lot of wait, DDL recommendations, etc.
Total commander settings
Had to stash my totalcommander settings 😎 wincmd.ini [Layout] ButtonBar=1 ButtonBarVertical=1 DriveBar1=0 DriveBar2=0 DriveBarFlat=1 InterfaceFlat=1 DriveCombo=1 DirectoryTabs=1 XPthemeBg=0 CurDir=1 TabHeader=1 StatusBar=1 CmdLine=0 KeyButtons=0 HistoryHotlistButtons=1 BreadCrumbBar=1 [Shortcuts] A+PGDN=cm_GoToDir A+PGUP=cm_GoToParent C+PGUP=cm_OpenNewTabBg C+D=cm_DirectoryHotlist C+E=cm_SrcCustomViewMenu CS+H=cm_SwitchHidSys CS+Q=cm_SrcQuickInternalOnly CS+SPACE=cm_CountDirContent F2=cm_RenameOnly F7=cm_MkDir F9=cm_CreateShortcut F10=cm_GoToFirstFile F11=cm_GetFileSpace F12=cm_SetAttrib...
Case insensitive string comparison in C++
(Not an original article) The standard library component std::basic_string<> (better known as std::string, which is a convenient typedef for std::basic_string<char>), is an important and widely used element of the standard C++ library. The declaration of basic_string<> in the standard library...
Cannot connect to Amazon Redshift
I am not able to connect to Redshift and getting error [Amazon](500310) Invalid operation: no pg_hba.conf entry for host user SSL off;
🙁 🙁
Keypirinha settings
Need to stash my Keypirinha settings, [app] hotkey_run = Alt+Space launch_at_startup = yes [gui] theme = MediumLayout, SolarizedDarkColors geometry = persistent always_on_top = yes escape_always_closes = yes retain_last_search = yes No related posts.
Connecting to remote server using a jump server (SSH tunneling)
Problem statement There are 3 hosts, Host-user – one that you are on Host-jump – one that has connectivity to database server Host-database – database server Host-user wants to connect to Host-database using Host-jump. Solution Setup ssh tunnel with local...
Fetching Redshift table DDLs
So lately I got stumped by not having the ability to extract DDL/ table definition for a table in Redshift. Quick searches on the internet resulted in… below query, SELECT * FROM pg_table_def WHERE tablename = ‘table_name’ AND schemaname =...