MySQL Cheat Sheet - Quick Reference Guide

  • 24 April 2023
  • ADM

A concise MySQL cheat sheet providing a quick reference guide for common MySQL commands, database and table operations, data manipulation, and more.


How to run HyperV Ubuntu VM in full screen

  • 24 November 2020
  • ADM

When I installed Ubuntu Desktop in HyperV, the VM was running with a 1152x864 screen resolution and I could not get the machine to run full screen. The max resolution that hyperv_fb is supporting is 1920x1080.


How to show open database connections in MySQL

  • 07 April 2020
  • ADM

How to show open database connections in MySQL using show status and show processlist command.


Robots.txt File in SEO

  • 13 February 2020
  • George

A robots.txt file tells search engine crawlers which pages or files the crawler can or can't request from your site. This is used mainly to avoid overloading your site with requests; it is not a mechanism for keeping a web page out of Google. To keep a web page out of Google, you should use noindex directives, or to password-protect your page.


How to use JSON Object in JavaScript

  • 06 February 2020
  • ADM

JSON is part of JavaScript programming language and is the main choise when it comes to data manipulation in JavaScript.

JSON is used from storing data, transfering data between client and server to configuring data.


How to change DNS settings from command line

  • 18 June 2019
  • ADM

The command line tool used to change the DNS settings is netsh which allows you to configure just about any aspect of your network connections in Windows. In order to use the tool the command line needs to be started as Administrator.