SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data. In an earlier column, I showed how ...

If you spend Mondays copying data from email attachments into a "Master" sheet, you're not working in Excel—you're doing manual labor. Power Query fixes that. Master these three core data ...

One of the most basic, common activities when using a cloud service like Microsoft Azure is to simply upload some files. Even though the cloud seems like some complicated entity in which you can't ...

I've installed Horizon View, VMware's Virtual Desktop Infrastructure (VDI) product, dozens of times over the past decade. With each release, for the most part, the installation process gets easier and ...

Storage is a finite IT asset, and organizations can’t get enough of it. Businesses are consuming more storage every day, and it’s up to IT to keep up. Rather than consistently add expensive new ...

As more companies shift their operations to the cloud, choosing the right provider has become a major decision that affects everything from scalability to performance to long-term costs. Amazon Web ...

Software as a service has been a growth driver in the tech industry. Learn about SaaS stocks and how to invest in them here. In some ways, Amazon has lagged its big tech peers in AI. It doesn't have a ...

Modern businesses run on data. Companies regularly capture, store and analyze large amounts of quantitative and qualitative data on consumer behavior, to which they can apply predictive analytics to ...

Don't think that Excel is just for numbers. Many people populate Excel's seemingly infinite grids with data, using it as a flat-file database. It can serve as a relatively effective contact manager or ...