While recording my VMware vSphere 5 Training course this past summer, I made mention that I developed a process for building an effective naming convention for enterprises. Server and desktop ...

Note: The best way to install and use this extension is by installing the InterSystems ObjectScript Extension Pack and following the documentation here. This is a LSP compliant language server for ...

Systematic collections of peat mid-infrared spectra and other peat properties are scarce, but useful to understand peat chemistry and develop spectral prediction models. The Peatland Mid-Infrared ...

To include aggregated values in your paginated report, you can use built-in aggregate functions in expressions. The default aggregate function for numeric fields is SUM. You can edit the expression ...

In the last tip, I reviewed the syntax for numeric Spark SQL functions. This tip focuses on the available string functions. The sheer number of string functions in Spark SQL requires them to be broken ...

A lot of DAX performance problems relate to the use of strict and eager evaluation with the IF or SWITCH functions. It’s an incredibly complex, “it depends”, black-box type of topic and naturally ...

Machine learning and deep learning have been widely embraced, and even more widely misunderstood. In this article, I’ll step back and explain both machine learning and deep learning in basic terms, ...

The TO_DATE function, for some reason, does not cast to DATE data-type. Instead, it is just an alias for TIMESTAMP_FORMAT. Also, if the host variable isn't a character data type, you have to wrap the ...

When you build a Power Apps canvas app there are many different data sources you can choose to use such as SharePoint, Microsoft Dataverse, SQL (on-premises), Azure SQL (online), Excel, and others ...

Data clustering is the process of placing data items into groups so that items within a group are similar and items in different groups are dissimilar. The most common technique for clustering numeric ...