PhpRiot
News Archive
PhpRiot Newsletter
Your Email Address:

More information

Brian Swan's Blog: What SQL Server 2012 Means for PHP Developers

Note: This article was originally published at PHPDeveloper on 14 March 2012.
PHPDeveloper

Brian Swan (of Microsoft) has a new post to his blog talking about what SQL Server 2012 means for PHP developers - what the latest version of this MS database has to offer and how to get a basic install up and working in your environment.

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 what some of that new functionality means for PHP developers. Combined with the release of the Microsoft Driver for SQL Server for PHP, I think the SQL Server 2012 release makes some big improvements in developing PHP/SQL Server applications.

He includes instructions on getting the latest version set up with the SQL Server Express LocalDB (and command line tools). He mentions only a few of the new things this latest version has to offer - easier pagination with OFFSET/FETCH NEXT, client-side cursors and other things like "AlwaysOn Connectivity" and the PDO::ATTR_EMULATE_PREPARES constant.