Consuming SQL Server Result Sets as XML with PHP

At last month’s SQL Server JumpIn! Camp, one of the SQL Server features that generated some excitement among the participants was SQL Server’s ability to return result sets as XML. I felt a bit foolish for not having investigated this feature, so I’m rectifying that with this post. The SQL Server XML functionality is very…


SQL Server JumpIn! Camp Wrap Up

As I arrived yesterday for day 4 (the last day) of the SQL Server JumpIn! Camp, one participant said to me,“I’m starting to feel worn down.” I think that was the general sentiment of everyone that was there…and with good reason. During each day of the camp, PHP developers worked side-by-side with Microsoft developers to…


Looking Forward to Next Week’s SQL Server JumpIn! Camp

Next week, Microsoft will host its second SQL Server JumpIn! Camp, and I’m very excited to be a participant (take a look at the list (below) of PHP applications and frameworks that will be represented and you will understand why!). I was fortunate enough to attend the first JumpIn! Camp (last November), and what I…


Interview with Julian Egelstaff, Technical Architect at Freeform Solutions

I recently had a chance to catch up with Julian Egelstaff, Technical Architect at Freeform Solutions. Julian attended last year’s SQL Server JumpIn! Camp where he worked with Microsoft engineers and other participants to add SQL Server support to Formulize, a PHP application that lets you to quickly create forms and reports in your website….


Interview: Ashay Chaudhary on the SQL Server JumpIn! Camp

Well, December did finally slow down a bit and I had a chance to catch up with Ashay Chaudhary, the Program Manager for the Microsoft Drivers for SQL Server for PHP. We had a lot to catch up about because we haven’t found much time to sit down and chat since the JumpIn! Camp last…


Troubleshooting and Performance Tuning with SQL Server Traces

A couple of weeks ago I wrote a post (How to Change Database Settings with the PDO_SQLSRV Driver) that highlighted a problem that came up at the November JumpIn! Camp in Redmond. To get to the root of the problem (and eventually a solution), I used SQL Profiler to monitor events on my database server….


Converting MySQL Queries to MS SQL Server Queries

At the JumpIn! Camp that took place a few weeks ago, PHP developers from several countries were invited to come to Redmond and work closely with Microsoft developers to build support for SQL Server and SQL Azure into their applications.  (As expected, the camp was more than just that. It was also an excellent two-way…


Why Pass Parameters by Reference in the SQLSRV Driver?

Last week at JumpIn Camp we spent quite a bit of time focusing on the SQL Server Driver for PHP. As developers worked to build SQL Server support into their applications, they had lots of questions about how both the SQLSRV and PDO_SQLSRV drivers work under the hood. One of the questions that came up…


SQL Server Driver for PHP Connection Options: Connection Pooling

I’m back in from conferences in Germany (PHP World Kongress and TechEd) and am now at Jump In! Camp. I’ll echo what I seems to be a common sentiment after the first couple of days: it’s very cool to be surrounded by so many smart folks (and humbling too). It’s been fun having my knowledge…