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…
Author: admin
Fix SQL Server ‘Insufficient Access Rights’ During Backup
Last updated: August 26, 2026. A SQL Server backup can fail because the login lacks database backup permission or because…
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 Write Better PHP
Last updated: August 26, 2026. Reliable PHP code starts with explicit inputs, predictable types, secure database access, and tests around…
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
Last updated: August 26, 2026. The Year function returns the four-digit year component of a date. Syntax Argument Description date…
Access WeekdayName Function
Last updated: August 26, 2026. The WeekdayName function returns the localized name of a weekday number. Syntax Argument Description weekday…
Access Weekday Function
Last updated: August 26, 2026. The Weekday function returns a number identifying the day of the week for a date.…