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 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 MoreHey all, another interesting one today. A client is migrating up to SharePoint on Microsoft 365 from a local Access database. What they needed was a list they could update with client info, and assign unique Purchase Order numbers. With Power Automate and a little DB knowledge we were able to help them out. Since […]
Read MoreHey all, testing out mobile posting on the go today with the WordPress mobile app. I’ll do a write up of how this works later on if anyone is interested! So far it’s much better for “on the fly” positing rather than doing it through the management page!
Read MoreToday we had an interesting challenge. A server room which normally operates at 18 degrees, was over-heating at a whopping 40 degrees! The issue? Heavy Snow! There was a recent heavy snowfall in the area, and the server rooms’ air conditioner unit was mounted on the rooftop of the building. We were able to shut […]
Read MoreStands for “Video Graphics Array.” It is the standard monitor or display interface used in most PCs. Therefore, if a montior is VGA-compatible, it should work with most new computers. The VGA standard was originally developed by IBM in 1987 and allowed for a display resolution of 640×480 pixels. Since then, many revisions of the […]
Read MoreSSD stands for “Solid State Drive” and is a relatively new technology. It is the newest form of “Hard Drive / Disk Drive” that comes with your computer. The benefit of the SSD over the previous hard drive technology is that it has no moving parts, and is accessed by the computer in the same […]
Read MoreStands for “Random Access Memory,” and is pronounced like the male sheep. RAM is made up of small memory chips that form a memory module. These modules are installed in the RAM slots on the motherboard of your computer. Every time you open a program, it gets loaded from the hard drive into the RAM. […]
Read MoreA power supply is a hardware component that supplies power to an electrical device. It receives power from an electrical outlet and converts the current from AC (alternating current) to DC (direct current), which is what the computer requires. It also regulates the voltage to an adequate amount, which allows the computer to run smoothly […]
Read MoreThe motherboard is the main circuit board of your computer and is also known as the mainboard or logic board. If you ever open your computer, the biggest piece of silicon you see is the motherboard. Attached to the motherboard, you’ll find the CPU, ROM, memory RAM expansion slots, PCI slots, and USB ports. It […]
Read More
