In today’s article, we will learn how to use SQL statements with functions for aggregation and table join, in order to extract data from Peakboard Hub tables. We’ve also covered various topics related to Peakboard Hub lists in other articles (check out the links at the bottom of this page)....
In the realm of database management systems, concurrency control plays a vital role in ensuring data integrity and consistent query results. This article explains how locks in SQL Server databases work, particularly in scenarios where simultaneous reads and writes occur. Additionally, it explores the application of the WITH (NOLOCK) hint...
In this article, we learned how to store historical events in a SQL Server database. Every time a state changes, a new row is created with the timestamp and the name of the new state. As you can see in the sample data, there are two drilling machines switching between...
What are machine states and why would I want to build a data historian? It is common to use Peakboard to collect various states for artefacts. This includes the state of a machine (running, stopped), the state of person (working, having a break), or the state of a door (open,...