How to prevent SQL injection in PHP scripts is probably a topic that doesn’t need anything more written about it. It is pretty easy to find blog posts, documentation, videos, etc. that explain the importance of preventing SQL injection and suggestions...

The Interoperability team here at Microsoft recently released the SSRS SDK for PHP (SSRS = SQL Server Reporting Services ). At the time of the announcement, I was very excited to check out this SDK, but I was so busy that I’ve just recently had a chance...

In my last post , I promised a comparison of the APIs for the MSSQL and SQLSRV extensions of PHP, so here it is. I constructed the table below assuming some familiarity with the MSSQL extension. I’m aiming to provide a high-level comparison that...

In a recent post I took a look at how to get started with SQL Server Reporting Services (SSRS) . In this post I’ll dive into the SSRS SDK for PHP that was recently released by the Interoperability team here at Microsoft. The SSRS SDK for PHP allows you...

Note: WebMatrix now supports PHP "out of the box". You no loger need to do any manual configuration (as detailed in this post) to get PHP support in WebMatrix. For more information, see http://www.microsoft.com/web/webmatrix/features.aspx . Last week...

[Part 2 of this post is here .] The SQL Server Driver for PHP (also called the " sqlsrv " driver for it’s API prefix) has been available since July of 2008, but I still often see the "old" driver (the " mssql " driver) used to connect to SQL Server...

In this morning’s keynote address at the Professional Association of SQL Server (PASS) Summit 2011 , Quentin Clark (Corporate Vice President at Microsoft) announced that a preview of the Microsoft SQL Server ODBC Driver for Linux will soon be widely...

Okay, okay. I know that Java Database Connectivity (JDBC) doesn’t have much (if anything) to do with PHP, so I apologize in advance if you are tuning in expecting to find something PHP-related. However, I temper my apology with the idea that getting...

In my last post , I provided an overview of using the SQL Server Driver for PHP . One of the driver features I didn’t mention in that post is the support for Integrated Windows Authentication when connecting to a server. So, that’s what I’ll take a closer...

It seems to be a well kept secret that WordPress runs on a SQL Server or SQL Azure database. At least it was well kept from me until recently. (Perhaps that says something about my ability to follow current news, but that’s a topic for another day.) In...

Last week I had the good fortune of presenting at the the Seattle PHP Meet Up on a topic I knew only a little about: transaction isolation levels. It was fun doing the homework to learn more and I’ll share what I learned in this post. However, before...

[Updated November 9th, 2011] In this post, I’ll show you how to get started with PHP and SQL Azure . I’ll walk you through building a very simple Web page in the same way I did in a recent post: Getting Started with the SQL Server Driver for PHP . That...

Following on the heels of announcements a couple of weeks ago , the Interoperability Team at Microsoft is announcing the availability of another update to the Windows Azure Tools for Eclipse . In this post, I’ll use the updated Eclipse plug-i to...

When I’ve asked people about their strategies for preventing SQL injection, one response is sometimes “I use stored procedures.” But, stored procedures do not , by themselves, necessarily protect against SQL injection . The usefulness...

Microsoft is getting serious about offering SQL Server access from Linux...and your input is being requested. Actually, the request is that you provide your thoughts about Microsoft offering ODBC support for non-Windows platforms (which would provide...

Whew! DrupalCon was fun…and exhausting. I don’t know why, but I’m always surprised that conferences can be simultaneously exhausting and energizing. Right now, it feels good to be back home, and I’m enjoying looking back on my experience with the perspective...

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 ....

Last month, the Interoperability team at Microsoft highlighted work done to move the Screen Actors Guild Awards Drupal website from a Linux-Apache-MySQL-PHP (LAMP) environment to the Windows Azure platform: SAG Awards Drupal Website Moves to Windows Azure...

I intended for this post to be about how to use the SQL Server Driver for PHP to get images in an out of SQL Server Express , but the truth is that it’s fairly easy…so easy that I eventually thought it wasn’t a very interesting topic. (Besides, this topic...

Last week, Ruslan Yakushev announced the release of the 1.1 version of the PHP Manager for IIS . I thought a tour of the PHP Manager functionality might work best in video format. I’d be interested learning what you think of the PHP Manager itself, but...

Following yesterday’s announcement of the availability of a PDO driver for SQL Server ( SQL Server Driver for PHP 2.0 CTP 1 ), I thought I’d take a closer look at the PDO interface. For me, the best way to get to know a new API is to write...

In this post, I’ll focus on the basics of using the SQL Server Driver for PHP to insert and retrieve data in a SQL Server Express database. I’ll build a web page that exposes enough of the driver functionality for you to understand the basics...

A couple of months ago, Rob Allen pointed out in a blog post that no Zend Framework PDO adapter existed for SQL Server. But, he also noted that it would be easy to write one…so he did: https://github.com/akrabat/Akrabat/blob/master/zf1/Akrabat...

In this post I’ll look at how to use the SQL Server Driver for PHP to backup and restore a database. It is important to understand that there are many ways to backup and restore a database. The strategy you choose really depends on your application and...

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,...