July 2023 – WebCheatSheet

SQL

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…

SQL

Last updated: August 29, 2026. Database users and server logins are separate SQL Server objects. When a database moves to…

PHP

Last updated: August 26, 2026. Reliable PHP code starts with explicit inputs, predictable types, secure database access, and tests around…

PHP

Last updated: August 25, 2026. An application can offer an “Export database” button, but the web request should authorize the…

PHP

Last updated: August 29, 2026. The blueimp jQuery File Upload widget provides multiple selection, drag and drop, progress events, chunking,…

PHP

Last updated: August 25, 2026. ODBC lets PHP connect through an installed database driver. A DSN stores driver and connection…

Last updated: August 26, 2026. The Year function returns the four-digit year component of a date. Syntax Argument Description date…

Last updated: August 26, 2026. The WeekdayName function returns the localized name of a weekday number. Syntax Argument Description weekday…

Last updated: August 26, 2026. The Weekday function returns a number identifying the day of the week for a date.…

Last updated: August 26, 2026. The Val function reads the numeric prefix of a string and returns a number. Syntax…