February 12, 2013 at 9:58 am
From the SQL DBA perspective, what questions would you ask someone applying for a PHP programming job ? Others will be asking the PHP related questions, but I will be meeting the person also and would like to have a few questions to discuss.
Such as, if they can convert PHP code from embedded SQL code to stored procedure calls.
February 12, 2013 at 3:23 pm
Having supported SQL Server for PHP developers that developed locally on Windows but deployed to and had their code tested and hosted on Linux for QA and Production...some random thoughts:
- knowledge of T-SQL Scalar-valued Functions and if they like them
- quick question on Join syntax
- benefits of Stored Procedures versus ad hoc SQL versus prepared statements
- how to protect against SQL injection, plays into previous question
- if PHP on Windows whether they would use the DBLib driver and whether they're familiar with the Microsoft Drivers for PHP
- if PHP on Linux what they use for drivers (FreeTDS or something else)
- how does the driver used from PHP to connect to the database plays into data type compatibility (Unicode, MAX data types, XML, etc.) and how it might impact an upgrade to a newer version of SQL Server
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply