Category: Coding Tutorials
-
ESP32 CAM: How To Save Still Images On An SD Card
Here’s a video that shows how to save a series of still images from the ESP32 CAM microcontroller module onto an SD card. You could use this as the basis of a home monitoring IoT application. I use it to make time lapse movies from a series of still images. The ESP32 CAM module has […]
-
How to Make a Doll with Hidden Spycam!
Here’s a fun little project I made with a very expensive doll and a couple of very cheap electronics components. In this tutorial I actually place the camera inside of a doll’s head, but you could just use this tutorial to place the webcam anywhere you like. To build this hidden spycam you will need […]
-
A Very Basic SQL Cursor for SQL Server (T-SQL)
Here’s a quick overview video of how to write and use a basic cursor in SQL Server’s T-SQL. The SQL code for both a regular SELECT cursor as well as an UPDATE cursor is below. Cursors are really useful if you want to perform a specific action on all of the rows in a particular […]
-
Lego Cantina Plays The Cantina Music ???
The Lego Mos Eisley Cantina 75290 is an incredible Lego set but soon after I had completed it I realised something was missing… that famous music played by Figrin D’an and the Modal Nodes. After much searching online I found out a way to play music on an Arduino Uno using a simple piezo buzzer […]
-
I Built a Lego Sized TV for the Friends Apartment Set (10292)
In this video we’ll learn how to make a miniature sized TV for the Lego Creator Expert Friends Apartments set 10292. Then you can recreate the girls (and Ross) watching Phoebe in Smelly Cat and the boys watching Baywatch! All you need is an Arduino Uno, an SSD1306 128×64 0.96 inch OLED display and a […]
-
Arduino + TFT Display With Multicolor Sprites (ST7735S 80×160 Module)
In this video you can see how I created a mock up display of the classic Nintendo Donkey Kong game on an Arduino Uno. The display module used is an ST7735S 80×160 TFT screen sourced from eBay. Arduino Uno sketch source code is further down the page… The graphics were created using the Adafruit GFX […]
-
How to Query SQL Server Full-Text Search Using CONTAINS and FREETEXT
Leave a LIKE on YouTube if you found this tutorial useful and SUBSCRIBE for more coding videos. Speaking of LIKE, in this coding lesson I show some different methods of searching SQL Server tables using LIKE %%, CONTAINS, FREETEXT, CONTAINSTABLE and FREETEXTTABLE. If you’re searching a table and your query is a single word then […]