Get the Size of Every MySQL Database and Table
Last updated: August 25, 2026. MySQL reports table data and index allocation through INFORMATION_SCHEMA.TABLES. The following queries convert the byte…
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…
Transfer SQL Server Logins and Passwords Between Instances
Last updated: August 25, 2026. Database users and server logins are separate SQL Server objects. When a database moves to…
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…
Create an On-Demand MySQL Backup from a PHP Application
Last updated: August 25, 2026. An application can offer an “Export database” button, but the web request should authorize the…
jQuery File Upload: Setup and Secure PHP Handling
Last updated: August 25, 2026. The blueimp jQuery File Upload widget provides multiple selection, drag and drop, progress events, chunking,…
Connect PHP through ODBC with DSN and DSN-less Connections
Last updated: August 25, 2026. ODBC lets PHP connect through an installed database driver. A DSN stores driver and connection…
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…