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…
Insufficient access rights error when doing backup
All of sudden SQL Server Management studio gives me the following error message when I’m trying to browse for the…
How to transfer logins and passwords between instances of SQL Server
To transfer logins and passwords between different versions of SQL Server, follow these steps: Run the following script on the…
How to be a better PHP developer
Many web developers consider PHP as a second class language. The truth is, as DHH puts it: “You can build…
How to create a dump of MySQL database in one click
Your users probably asked you to add an option to export the whole database to SQL file. This can be…
jQuery File Upload
Wow, Yet another upload plugin! What makes it different? It’s new. Supports all modern technologies. It’s good looking and works…
DSN and DSN-less connections
DSN stands for ‘Data Source Name’. It is an easy way to assign useful and easily rememberable names to data…
Access: Year Function
In Access, the Year function returns an integer between 100 and 9999, inclusive, that represents the year of a date…
Access: WeekdayName Function
In Access, the WeekdayName function returns the name of the day of the week corresponding to the date and the…
Access: Weekday Function
In Access, the Weekday function returns an integer between 1 (Sunday) and 7 (Saturday) that represents the day of the…