COVID-19 Protocol

It is almost business as usual at Nicom, because we are used to working remotely, as we work in an industry where it is commonplace to do so. So from March 18-31, 2020, we are practicing “social distancing,” which means we are working mostly from our homes. The best way to reach us is via email, but if you call and get our voice mail, do leave a message as we will be checking frequently. We plan to have one person in the office from 6:30 to 9:30 on business days. We will be having no face-to-face meetings, opting for phones, conferencing systems, Microsoft Teams, Skype, and Zoom. We don’t expect any projects to be delayed as a result of the coronavirus. Please refer to our Contact page on this website. Stay safe. Be kind to one another. Practice social distancing. Take care of your families.


As we neared the new millennium back in the 90s, we realized there were two ways to solve the looming Y2K problem. One was to expand the “year” fields in databases to have 4 digits instead of two. That would postpone the problem until the year 10000. Another way was to leave the fields in the databases as 2 digits and throw in some logic to decide which century it belongs to. You could, for example, say: IF year IS GREATER THAN 80 THEN century = “19” ELSE century = “20”. That would have solved the problem until the year 2080. The arbitrary value of 80 is what some people call the “pivot year.”

Except some people decided the pivot year would be 20, and guess what? Systems started failing last week. Back in the 90s, a lot of people would have probably said that the program wouldn’t still be in use in twenty years, and still others likely said they themselves wouldn’t be.

The Y2K.2 problem is not as severe as Y2K because there are far fewer instances, and also you can just punt the pivot year ahead another 20 years, which would be an easy fix (assuming you can find the source code).

Some programs store the year in full 4 digits, but allow a 2-digit shortcut. That is what Excel does. I just tested it out and on my computer their pivot year is 30. If you enter 29/12/31 it converts it to 2029/12/31. If you enter 30/1/1 it converts it to 1930/1/1. I just did a bit of research, and there is a default two-digit year range that you can set in the Windows Control Panel (Regional Settings). There you can set the pivot year to whatever you want.

SQL Server 2008 Support ending in July, 2019

If you are still running applications on Microsoft’s SQL Server 2008, you should be aware that support for this platform is ending on July 9, 2019. As of that date, you will no longer be getting security updates from Microsoft. Microsoft does make options available, such as moving to the Cloud (Azure platform), or upgrading to a later version of SQL Server, such as SQL Server 2017. Nicom’s Technical Support group can help you with these decisions. Give us a call at (902) 497-1153!

Blockchain Demystified

If you’re wondering what all this is about regarding Blockchain, here is a brief article I wrote for Business Voice: Blockchain Demystified.

Nicom-Built Data Dashboards now Online at Port of Halifax

The strength of a seaport lies in the stakeholders that participate in its supply chain. These stakeholders consist of terminal operators, shipping lines, freight forwarders, road and rail operators, federal authorities, and the other countless operators that are involved in moving goods along.

All these participants in the supply chain generate data, and need data to operate efficiently. This need has led to the creation of data dashboard systems that make information available to those who need it, in a privacy-preserving manner.

These systems, which are web-enabled and mobile friendly, have been developed by Nicom IT Solutions of Halifax. More information and a link to the site are at