MySQL Cheat Sheet - Quick Reference Guide
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
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
How to show open database connections in MySQL using show status
and show processlist
command.
Robots.txt File in SEO
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
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
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.