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

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”

Error :- “Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.ReportViewer.WinForms, Version=13.0.0.0, Culture=neutral”

Background Running SQL Server Tools, but run into an exception. Error Error Image Error Text Trouble Shooting The cited assembly is Microsoft.ReportViewer.WinForm and the version is 13.0.0.0. 13.0.0.0 maps to SQL Server 2016. Remediation Outline Artifacts Please access the corresponding SQL Server Feature Pack Again 13.0.0.0 maps to SQL Server 2016 The web link for … Continue reading Error :- “Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.ReportViewer.WinForms, Version=13.0.0.0, Culture=neutral”