When it comes to packet filtering on Linux, Nftables (a successor to Iptables) has matured sufficiently in recent years for it to be considered the default tool to use today. However, Iptables is still widely used in modern systems (e.g., Debian buster), with it often being “emulated” by using Nftables as backend, whereupon it becomes merely an alternative syntax to Nftables for defining packet...
Monitor the performance of queries against databases to eliminate unnecessary costs
In our previous article we saw the great advantages of applying Best Programming Practices in SQL Server. We’d like to explore this further, this time focusing on query optimization. SQL is a declarative language: each query declares what we want the database engine to do, but it doesn’t say how. However, it turns out that the how (the plan) is what affects the efficiency of the queries, so it...
Best programming practices for relational databases and cost savings
No time is a bad time to plan improvements. Looking for ways to reduce development costs in the cloud is always a good thing. Process response times in Microsoft SQL Server databases are irreparably deteriorating as our data volume grows. Therefore, we must stay one step ahead by improving our infrastructure and the way we act towards them. Everything can always be improved without needing to...
Robot Framework and test automation
Process automation is becoming increasingly important when developing new software and hardware, as a means to detect implementation failures, carry out behavioral tests involving resources and scenarios, etc. On top of saving employees a great amount of time, it is a quick and easy method that is highly reliable when compared to the alternative: specific tests that have to be run manually. As a...
5G: How it will change our lives
The advent of 5G technology signifies the start of an even more globally connected society, a completely digital society. This technology, expected to be implemented in 2020, will change the way we interact with each other and objects, allowing us to be permanently connected, both to other people, and to everyday objects like the refrigerator or car.The Internet of things boom is imminent, and...
Improving Efficiencies Through PLC PRIME Communications Gateway
Traditional PLC-based smart metering solutions require the installation of PLC data concentrators in remote and unattended second tier substations. PLC Data concentrators handle communications with the different smart meters installed at consumer premises, consolidate the metering data and send it to the AMI management systems. This option involves storing confidential metering data belonging to...
Categories/Tags