Welcome !!!

Hi Everyone, Thanks for checking out my WordPress Blog. Thanks, Zam

Connecting to SQL Server DB compiling and running with Java

Introduction Hi everyone, I've been practising Java programming to prepare for Data Structures and Algorithms for my Uni course (for those interested... it's UO Applied Data Structures). And I've been following an old textbook from my TAFE days called The Java Way 2nd Edition by Gerard Sparke (an excellent book that helped me translate UML …

Installing & Setting up Vim on Windows

So.... my Linux laptop is started to make weird noises in the last couple of days (might need to clean or replace one of the fans). For now, I've put it aside because there are a few parts I need to buy and a few little things I need to fix other than the fan; …

Removing Hyper-V and Installing VirtualBox, VirtualBox Guest Add-On & Setting up shared folders

Hyper-V for any Linux distro is horrible (including Ubuntu). I've decided to go back to VirtualBox. The first thing to do is to remove Hyper-V. Removing Hyper-V To remove Hyper-V; go to Settings > Apps, and in the top right, you will see "Related Settings". And then click on Program & Features which will open …

Simple Data Cleaning Trick In SQL

Hi Everyone, It's been a month since I've started my new job (Yay!!) and I've been doing a lot of Data Conversion!!! I wrote a dynamic script yesterday that removes whitespaces and any form of garbage data like #REF! or #N/A and so on from all character-based columns. I'm using cursors to go through all …

Manjaro and Redshift

Introduction Hi Everyone, I switched to Manjaro Xfce 😀 😀 😀.....from Ubuntu....then Debian..... then Ubuntu. Why I switch over to Manjaro? The main reason for the change: Debian still doesn't have any support for Nvidia PRIME. Ubuntu installer is broken (I should say it doesn't jive well with Nvidia Hybrid Graphics on my laptop for …

Connecting to MS SQL Server from R

Introduction I was asked at work to do some data analysis (sorry can't tell ya what it is ;)). And I realised that it was going to be a nightmare dumping the data into Excel doing analysis in Excel or writing a whole bunch of SQL queries, querying the same tables/datasets. So I decided to …

Raspberry Pi Router…..Connection Dropouts

Hi Everyone, Over the last couple of days; my Raspberry Pi Router has been having dropouts. And it hasn't been fun. As of writing this blog post. The kernel version that I am currently running is 4.14.79-v7+. First thing I did was ping my laptop from the router and got the following message: ping: sendmsg: …

Ubuntu 14.04 LTS Browse Network and SMB Tree was not displaying other PC’s on the Network; How to Fix It !!!

This a post from my old blog site posted 10/10/2014....WordPress has better formatting tools and capabilities :D. After installing Ubuntu 14.04 Trusty Tahr on my laptop, if you go into File Browser > Browse Network, you won't see any other PC's on the network and if your run the command smbtree, it does not display anything …

Wifi-To-Wifi Routing On Raspberry PI

Introduction and Initial Setup First and foremost, install Raspbian Desktop on your Raspberry PI and then run: sudo raspi-config to update and do the initial setup on your Raspberry PI. Once you have done that, install a network manager!!! As I mentioned in my previous post, The tutorials that you have seen online are outdated. …

Raspberry PI Wifi Extender/Router

Hi Everyone. I haven't blog for a while now, had a few things going on. But good news, I'm moved into a new place (student accommodation, since I'm still at uni). Bad news the Wifi service that they're providing here restricts me to only 5 devices. Goods news is 25 Mps Internet Connection with Unlimited …