What SQL Server 2012 Means for PHP Developers

Last week, Microsoft held a virtual conference to announce the availability of SQL Server 2012. The conference included a number of events (speakers, videos, training activities, etc.) that focused on the new functionality available in this release. Now that most of the fanfare has died down a bit, I’d like to take a look at…

1

Version 3.0 (beta) of the SQL Server Drivers for PHP Released!

A Community Technology Preview (a beta release) of v3.0 of the SQL Server Drivers for PHP was released today (see the announcement on the team blog). You can download it here: Download v3.0 of the SQL Server Drivers for PHP. In this release, there are three new features: buffered queries, support for LocalDB, and support…

2

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…

9

PHP Driver for SQL Server – Request for Feature Feedback

Jonathan Guerin, the Program Manager for the SQL Server Driver for PHP, just posted a request for feature feedback on the team blog. I want to make sure that his request gets in front of lots of eyes, so I’m re-posting his request here (below). Jonathan included some links in his post so you can…

0

Using PDO::quote with Parameterized Queries

I spent some time last week investigating a puzzling issue raised in the SQL Server Driver for PHP forums: Need help with PDO::quote() and PDOStatement::bindValue and PDO::execute using new SQLSRVR 2.0 driver. At the heart of the issue was this question: Should you use the PDO::quote method to quote a parameter if you are also…

2

SQL Server Driver for PHP Connection Options: Encrypt

This short post adds to my series on connection options in the SQL Server Driver for PHP. I’ll go into a bit more detail on the Encrypt and TrustServerCertificate options than the driver documentation does. I’ll start with three important points related to these options, then I’ll go into a couple of hypothetical situations that…

1

SQL Server Driver for PHP Connection Options: Failover_Partner

One of the best things about writing this series on connection options for the SQL Server Driver for PHP is that I get to learn about lots of interesting SQL Server features. This time, the Failover_Partner connection option has led me to do a bit of homework on database mirroring. The short story is that as an application…

0

SQL Server Driver for PHP Connection Options: CharacterSet

In this post, I’ll add to my slowly growing series that elaborates on the connection options for the SQL Server Driver for PHP. This time I’ll focus on the CharacterSet option. This is the option that specifies how data will be encoded when it is sent to and from the server.  I’ll take a look…

4

SQL Server Driver for PHP Connection Options: ReturnDatesAsStrings

This is short post to address a frustration I’ve seen mentioned on Twitter and in forums a lot: By default, the SQL Server Driver for PHP returns datetime columns as PHP DateTime objects, not strings. This can be especially frustrating if you are not aware of the ReturnDatesAsStrings connection option. By simply setting this option…

4

Paging Data with Different Cursor Types

This post is a follow up to a post I did last week: Paging Data with the SQL Server Drivers for PHP: Simplified.  In that post, I showed how to leverage scrollable cursors to simplify code for paging data. However, my investigation used only one type of scrollable cursor: a static cursor. In this post,…

0