Sergey Kornilov – Page 9

Scope Redis Cache Keys Safely in Multi-Tenant SaaS

Enforce tenant-prefixed Redis keys behind one cache wrapper and understand where shared-instance eviction still crosses tenant boundaries.

PHP

Validate an uploaded image by its detected MIME type and an explicit extension map instead of assuming image/jpeg must use one filename extension.

Use two correlated EXISTS tests in Microsoft Access to return each item only when it is associated with both selected locations.

SQL

Check SQL Server compatibility, parameter sniffing, predicate eligibility, statistics, and Extended Events when PSP does not create query variants.

Email, PHP

Configure Microsoft Entra ID and use PHP with Microsoft Graph to read Outlook mail securely through OAuth 2.0 without storing mailbox passwords.

SQL

Choose MySQL indexes from measured query patterns, use composite keys where filters travel together, and check their effect with EXPLAIN.

SQL

Insert multiple MySQL rows while resolving foreign keys from stable business keys with one INSERT SELECT statement and explicit validation.

SQL

Define, assign, and call SQL Server output parameters correctly, including the OUTPUT keyword at both the procedure and caller boundaries.

PHP

Find the operation that consumes a PHP request’s time budget, measure slow sections, and fix the underlying bottleneck before increasing the limit.

PHP

Guess a CSV delimiter from multiple sampled records in PHP using consistent parsed column counts, while detecting ambiguous or malformed files.