Hey all, very excited to share this story with you. We have been waiting for a chance to try out the new Star Link system, and I am happy to report that so far it really does deliver on its promise. I will post the pictures of our install below. Star Link is still in […]
Read MoreHey All, another fun one. We had a client who was uploading files to a SharePoint collection via a script, and using the PnP Management Shell. Sometime last year a new version of the PnP Management Shell was released, and the local module needed to be updated. After the update, the following error was being […]
Read MoreHey All, back again with another interesting problem and solution that we hope will help others out there in the tech world. If you have never heard of Veeam backup & recovery, I encourage you to do a quick google search. It is a fantastic product that allows you to backup and restore systems and […]
Read MoreHey All, Another interesting troubleshooting session to share. We had a site that was trying to add a new Ubiquiti UAP-AC-HD (access point) to an existing infrastructure. The issue we were running into, is that when we attempted to run the “inform” command on the access point, we kept getting an error in the logs […]
Read More2FA is an abbreviation for “two-factor authentication,” a security measure used to authenticate a person’s identity. It requires two forms of authentication, such as a password and a phone number, which a user needs to provide to be granted access to information. In general, there are three factors that can be used for authenticating identity: […]
Read MoreStands for “Uninterruptible Power Supply.” In the technology world, UPS is more than just a brown shipping company. It is also a type of power supply that uses battery backup to maintain power during unexpected power outages. A typical consumer UPS is a surge protector that contains a high-capacity rechargeable battery. Smaller UPS devices look like bulky […]
Read MoreHey All, This is more of a PSA. I wanted to make a suggestion, to consider installing a UPS ( check out our Tech Terms – UPS for more info ) with your sensitive networking equipment. We had a case a few weeks ago where the internet and networking servicers continuously were going offline. As […]
Read MoreHey all, here’s another conversion tip. In our project, Excel can join the contents of two fields together by using the following: =(A1)&(B1) In this example, we will join 2 values together. Lets say 10 is in A1 and 33 is in B1. So our code will be: =(10)&(33) In MSSQL, this can be done […]
Read MoreHey all, this is the first big conversion I ran into with MSSQL and MySQL. In Excel, you can use the MAX() function to find the highest value in a row. =MAX(A1, B1, C1) When this is converted into MSSQL, we need to use an additional function in order to find this result. SET MaxValue […]
Read MoreHey All, Back again with the power of knowledge! Recently we have been helping out a client to turn an Excel document into a database as a part of a new online application. On our first pass, we had converted the excel formulas into MSSQL, but in the end the choice was made to move […]
Read More
