SQL Formatter
Raw SQL can be difficult to read when spacing, indentation and line breaks are missing. A well formatted query is easier to debug, learn from and share with others, especially…
Read articleTag: SQL
Set Default Value Of Datetime in SQL Server
When it comes to handling datetime on SQL server it can get quite error prone when you are dealing with different regions and end up getting an out or range…
Read articlePrevent SQL Injection With Classic ASP
Classic ASP might seem like a language that is dead and gone, but it is still alive…somehow. With a language that has become outdated, it can be difficult to fight…
Read articleUsing MySQL Timestamp In a Google Sitemap Lastmod
The lastmod field in sitemaps is subject to a lot of trouble for most people who are trying to build their own dynamic sitemaps. The main issue is that google…
Read article
PDO SQL Queries Using SQL Server And IIS
Most standard PDO tutorials from around the web are going to demonstrate using a MySQL database with apache as a web host. The PDO connection string for this setup is…
Read articleHow To Reset Forgotten MySQL Root Password
So you have chosen an awesome cryptic password that not even you can remember! It happens to us all, but fear not, it’s quite a simple job to reset this.…
Read articleHow To Display PDO SQL Query Error Information
Often it can be quite hard to debug SQL errors when using PHP since PHP will often throw a generic error that doesn’t really help you diagnose the situation. Other…
Read articleInstalling PHPMyAdmin Through Command Line
This will guide will show you what you need to do to install phpmyadmin on CentOS via command line. In order to install phpMyAdmin you need to add a repository…
Read article