Have you ever wanted to create a copy of a database table, programmatically?
Could be a part of a stored procedure as a temporary table, or just a quick way of duplicating structure and constraints of the original one.
If so, this Transact-SQL script maybe what you’re looking for.
Sending an email is probably the most convenient way of communicating data or informing us of an event from our ESP8266. It’s cross-platform, works on every device and very reliable. It can alert us when one of the sensors detected something (PIR sensor for movement, MQ2 for air quality or any other environmental sensor).
There are a few ways to get that done, and in this post, I’ll show you my preferable way.
This seems like a topic that has a lot of cover on the internet, and many sites have code snippets for connecting ESP8266 to WiFi networks, however, after using a lot of ESP8266 in my projects I want to recommend my own take on how to achieve this.
Handling resources, redirects and other operations is very easy and useful using the .htaccess file of Apache web server.
Sometimes, we want to block or redirect traffic based on its network IP address.
But what to do when %{REMOTE_ADDR} returns the wrong address? (more…)
This quick tip is for fixing conflicts with tabindex, which often occur when you’re using a content management system that has modules.
If the modules don’t play nice together, index-wise, use this js / jQuery function.
WordPress is a very popular platform, and I have had many WordPress installations over the years (even this site is based on it).
Being that popular has made this platform a target for many hackers. And even though it keeps updating and upgrading, over the years I found myself a victim of hostile takeovers.
In this article, I’ll discuss and demonstrate how to add two-step authentication as an extra level of security to your site or blog.
If you just can’t find how to remove “Archives” from your pages, this quick tip is for you.
This tip is also useful for the woocommerce plugin which uses archive pages, like Archive: Products
Whoever worked a lot with text files possibly had this problem before, you have text file filled with unwanted characters, some are “hidden” (another way of saying that there are characters that your system can’t represent as symbols on your screen) and some are just redundant and not needed.
Every time I add a new device (IOT, server or other) to my home network, I want to make sure that I can rely on it to do its job and keep being connected.
When a device has a critical part to play in my home or office, I want to be alerted when it fails or if it disconnects from the network/internet.
(more…)