This short post is a cheat sheet for transact SQL or T-SQL for Microsoft Server. I wrote this for myself so if I ever have trouble remembering some of the more common queries(as I don’t work with databases on a daily basis) I can just look them up on my own site. And maybe someone out there on the internet will find this useful for themselves as well.
In this short post, I’ll show you how to read and write to/from the serial port using Powershell.
In this post, I’ll show you how to measure the length or find a break in a coaxial cable with the help of your oscilloscope and waveform generator. We can do this using signal reflection that occurs when a transmission line is not terminated correctly.
In this post, I’ll show you how to measure the value of capacitors and inductors with your oscilloscope and waveform generator. To measure the capacitor we’ll simply which will charge(periodically with a square wave) it through a resistor and measure how much time it takes the capacitor to charge to 63% we can then calculate its value according to the RC time constant formula which is t = RC. We’ll rearrange it to C = t/R to get out the capacitance.
Some tome ago(few years) I was using Google Analytics to check the traffic to this very site. I was looking at the “pages report” where it shows your most visited pages. I discovered that I was getting an error(This site can’t be reached) when I click the hyperlink which was supposed to take you to that particular page on your website.
In this post I will document some of my smaller projects that don’t deserve a whole blog post of their own.
In this post, I’ll show you how to make a cheap portable spectrum analyzer from a TV receiver dongle. The dongle gets sold as a TV (DVB-T) however its an SDR(software defined radio) which means that it can be used to receive pretty much any RF signal(depending on the chip used up to 1-2 GHz) and turn it into a digital one to be later processed by software.
Usually, you would just buy the whole IR module which contains the transmitter, receiver, and amplifier. However, in this post, I’ll show you how you can make your own IR distance sensor/motion detector module.
In this post, I’ll show you a plasma speaker I made many years ago in fact, over 13 years ago. I originally saw this on Instructables and thought it was really cool so I decided I would make one myself. Unlike a traditional speaker which moves air with a diaphragm, a plasma speaker makes sound by utilizing a high voltage electric arc to move air.
In this post, I’ll show you my DIY FPV goggles. These obviously aren’t as good as proper FPV goggles but they are cheap, they work and I was able to make them out of things I already had at home.
