DBeaver / ProgreSQL – Array Datatype

Background In our last post spoke of a little issue we experienced issuing a query against a PostgreSQL Instance. Issue The Issue is that our result set included an array column. array_agg Documentation Link SQL Output Troubleshooting Dbeaver Support Visited dbeaver support website @ Github. Here is the URL ( https://github.com/dbeaver/dbeaver/issues ) [ Link ] … Continue reading DBeaver / ProgreSQL – Array Datatype

PostgreSQL :- Permit Network Access

Background It is time to allow network access to our PostgreSQL server. Outline Server Configuration ( Files ) postgresql.conf IP Interface ( Listen address ) Port Number Default :- 5432 pg_hba.conf ( PostgreSQL Client Authentication Configuration File ) Rules Firewall Host Firewall Network Firewall Reload Configuration pg_hba configuration Either of these options Command Line Shell … Continue reading PostgreSQL :- Permit Network Access

Annabell Om, A Jamaican Architect in Japan

Videos Profile In this episode of The Melanated Files (MFiles) we introduce Annabell, a Jamaican Architect who works at a Japanese architectural firm in Tokyo, Japan. Annabell shares her experience living and working in Japan for the past five and a half years. Listen as she shares her journey to Japan by way of the … Continue reading Annabell Om, A Jamaican Architect in Japan

Transact SQL – XQuery – Ancestor

Background Playing around with XML, but dug in a quick sand. XML Here is the XML Image Code Code Code Find Nodes whose element matches specific value SQL Output Pass X PATH :- Child::bar/Attribute SQL Output Find Descendants SQL Output Find Ascendants SQL Output Output - Textual Output - Image Source Code Control Git Hub … Continue reading Transact SQL – XQuery – Ancestor

IBM Divestiture – 2019

Background IBM recently completed its purchase of Raleigh's North Carolina Linux Powerhouse, Red Hat. As part of that corporate merger, it appears regulars whether here overseas are concerned of allowing too much vertical technology ( Application software, Operating System, and Integration Software ) to rest in a single entity.   Affected Product Lines HCL Software … Continue reading IBM Divestiture – 2019

SQL Server Data Tools ( SSDT ) – Error – “The Application is not installed”

Background Wanted to quickly go over an error that is easy to self trigger when working with SQL Server Data Tools ( SSDT ).   Triggering Point A few days ago I was working with SSDT, and I was informed that one of the plugins is running slow and prompted if I want to disable … Continue reading SQL Server Data Tools ( SSDT ) – Error – “The Application is not installed”