Yet Another IT Professional Blog

This one is a bit obvious and straightforward but I keep seeing in different posts that people who start using github or the curious ones are struggling at the beginning on how to setup their git environment to get started with and this question comes back often. "I can't clone a repo from Git and I receive permission denied (public key) error!" Well, the issue is, like the error message states it, ssh certificates not being setup. In summary, you need to create an ssh certificate for your profile and upload your public key to your github account so

NGINX is a great web engine and very easy to get started with. In case you need to share files or make them available trough a web interface, all you need to do this, download the latest version of nginx and run it! It's that simple... For a particular case, I needed to make some folders on my windows machine available so I could share these folder structures on the network (usually I use SMB shares with specific permissions but this was a particular case, don't ask why :) ) The Nginx configuration sits in the "conf" folder when

Today, I needed to do some tests with a newer version of the Chef Client and test my cookbooks. To version 14.12.9-1 to be precise. I also upgraded my ChefDK on my workstation to the 4.2.0 version. I believe that upgrades Ruby version as well and now I have ruby version 2.6.3p62 Right after the upgrade, I tried with a basic knife node list command to see if I needed to reboot or anything was broke... Everything seems to be working fine, except I get this annoying "warning" message. As it's just a warning, I don't really care about it as it just seems to annonce something that is deprecated... Problem; You receive "warning: Win32API is deprecated after Ruby 1.9.1; use fiddle directly instead" warning when using ruby or chef knife commands. Solution; You need to comment out that warning message in Ruby lib scripts.

This is a weird issue that I don't fully understand why it would happen. But the symptoms are very persistent as we're able to reproduce these behavior easily. Issue: The MSMQ (Microsoft Message Queuing) fails to create Public Queues and throws  "the System.Messaging.MessageQueueException (0x80004005): A workgroup installation computer does not support the operation" exception.

A lot of the times, I find myself having multiple Excel or CSV files with different tables & data that at some point, I need to merge them... Here is a not to myself! Use Index and Match formulas. Index Function The INDEX function returns a value or the reference to a value from within a table or range. Match Function The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 25, and 38, then the formula =MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range. Ex : INDEX ( return_range , MATCH ( lookup_value ,  lookup_range , 0)) =INDEX(Sheet1!$B$2:$B$218,MATCH($A2,Sheet1!$A$2:$A$218,0)) In this example, with Match, we're trying to find cell A2's exact value by looking in the "Sheet1", from A2 to A218. When the exact value of A2 is found in the range of Sheet1!$A$2:$A$218, with the Index

Although I don't consider myself a real gamer, I do enjoy playing games from time to time. Since, I've started working at Ubisoft, I'm trying to take advantage of the games available to me. One does not simply work for one of the greatest gaming companies in the world and simply refuse to play their games ;) So after installing uPlay on my computer, I downloaded & installed huge packages of the Assassin's Creed, Crew, South Park, For Honor, etc... Everything was working fine until I decide to lunch on of the Assassin's Creed games.