Category: Programming

    • Tech
    • Comments Off on Veeam – Tape Drive Inventory
    Veeam – Tape Drive Inventory

    Hey 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 More
    • SQL – CAST() / CONCAT()

    Hey 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 More
    • SQL – MAX/Greatest()

    Hey 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 More
    • Tech
    • Comments Off on MSSQL to MySQL – Foreword
    MSSQL to MySQL – Foreword

    Hey 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