admin – WebCheatSheet

SQL

Get size of all databases and tables in MySQL

Code first: This simple SQL query will return the size of all databases of your MySQL Server, listing the largest…

SQL

All of sudden SQL Server Management studio gives me the following error message when I’m trying to browse for the…

SQL

To transfer logins and passwords between different versions of SQL Server, follow these steps: Run the following script on the…

PHP

Many web developers consider PHP as a second class language. The truth is, as DHH puts it: “You can build…

PHP

Your users probably asked you to add an option to export the whole database to SQL file. This can be…

PHP

Wow, Yet another upload plugin! What makes it different? It’s new. Supports all modern technologies. It’s good looking and works…

PHP

DSN stands for ‘Data Source Name’. It is an easy way to assign useful and easily rememberable names to data…

In Access, the Year function returns an integer between 100 and 9999, inclusive, that represents the year of a date…

In Access, the WeekdayName function returns the name of the day of the week corresponding to the date and the…

In Access, the Weekday function returns an integer between 1 (Sunday) and 7 (Saturday) that represents the day of the…