Mysl, MSSQL, Oracle, SQLITE, POSTGRES
The Database Engine Service could not resolve the specified location. You are most likely to get this error message, if you try to restore or backup a database from a UNC drive (Mapped drive) If you … Read more
The other day I wrote a piece on renaming a Mysql databases and I thought that it could also be useful if I show you how to rename a Table using phpMyAdmin and MySQL Workbench … Read more
From the easy way to the crazy way here is how to rename a Mysql Database. 1. Using phpMyAdmin Log into your phpMyadmin select the database that you want to rename and click on the … Read more
Handling White space in T-sql is very annoying. When you are comparing strings it is crucial that you remove any white space or special characters that could interfere with your results. You can user rtrim(ltrim … Read more
Here we go again! You are trying to connect to your freshly installed sql server 2008 R2 express edition using localhost as server name and you are getting this error. The purpose of this … Read more
