Brian Swan

Insights on HDInsight
Posts
  • Brian Swan

    Design Decisions in the PDO Driver for SQL Server

    • 4 Comments
    I’ve recently talked with the SQL Server Driver for PHP team about some of the harder design decisions they have had to make while building the PDO interface for the sqlsrv driver . Some of these challenging decisions stemmed from the fact that the team...
  • Brian Swan

    What was Microsoft Doing at DrupalCon?

    • 17 Comments
    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...
  • Brian Swan

    This Week’s Link List (April 23, 2010)

    • 0 Comments
    I’m back from an exciting trip to DrupalCon in SF and I’m still reflecting on that experience. Look for a DrupalCon summary from me early next week. In the meantime, I’ll share some of my interesting links for the week. Of course, several of these are...
  • Brian Swan

    PDO Cheat Sheet for SQL Server Driver for PHP

    • 5 Comments
    I know, I know…part of the point in having a common data abstraction layer like PDO is that you only have to know one API for accessing any database…so who needs a cheat sheet? Well, I do. With this weeks release of the SQL Server Driver...
  • Brian Swan

    Comparing the SQLSRV and PDO APIs

    • 7 Comments
    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...
  • Brian Swan

    PDO Support for SQL Server!

    • 2 Comments
    Add SQL Server to the list of databases with PDO support! Today, the SQL Server Driver for PHP team released the SQL Server Driver for PHP 2.0 CTP *, which includes support for PHP Data Objects (PDO). The announcement of the release came during the opening...
  • Brian Swan

    This Week’s Link List (April 16, 2010)

    • 0 Comments
    A longer list than usual this week. There was lots of news/buzz this week around Windows Azure and PHP. The first three links below are follow-ups by attendees of the recent JumpIn Camp in Zurich (which focused on PHP and Azure). The other links provide...
  • Brian Swan

    Preparing for DrupalCon 2010

    • 0 Comments
    If it seems that my blog has been on the quiet side the last couple of weeks, it’s because I’ve been devoting quite a bit of time to preparing for DrupalCon 2010 . I will be there for the main conference (April 19 – April 21), and I will hopefully make...
  • Brian Swan

    Working Down the Stack: Enabling ODBC Tracing with the SQL Server Driver for PHP

    • 1 Comments
    A couple of weeks ago I ran into some problems when figuring out how to do backups and restores with the SQL Server Driver for PHP . The problem itself* isn’t the point of this post, but how the problem took me further down the stack is. The short story...
  • Brian Swan

    This Week’s Link List (April 9, 2010)

    • 0 Comments
    I haven’t been writing as much this week as in past weeks, but I HAVE been paying attention. :-) Here’s my favorite links of the week… · I think this is my favorite link of the week…the Interoperability Lab at Microsoft has announced the availability...
  • Brian Swan

    BACKUP and RESTORE A Database with the SQL Server Driver for PHP

    • 5 Comments
    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...
  • Brian Swan

    This Week’s Link List (April 2, 2010)

    • 0 Comments
    OK…here’s a list of links that grabbed my attention this week: The PHP on Windows Training Kit (which contains LOTS of great demos for almost anything that is PHP on Windows) has been updated so it can be installed on Windows 7: http://english.zachskylesowens...
  • Brian Swan

    Going to DrupalCon!

    • 2 Comments
    I found out this morning that I get to go to DrupalCon SF ! This will be my first Drupal conference...and I'm wondering about a few things: Are you going? I'd like to meet folks...especially if it's over a beer. :-) Is there an inside scoop on...
  • Brian Swan

    Streaming Silverlight Video with PHP

    • 0 Comments
    In this post I hope to take a step towards making good on a promise I made a few weeks ago : to dive into some of the PHP-related projects on CodePlex that piqued my interest. In particular, I’d planned on diving into the Embedding Silverlight in PHP...
  • Brian Swan

    This Week’s Link List (March 26, 2010)

    • 0 Comments
    Here’s the links that I found especially interesting this week…lot’s of news around Microsoft and open source projects. 1. Interesting news from the Open Source Business Conference (OSBC) : “82% about 350,000 projects are Windows compatible” - http...
  • Brian Swan

    Store Images in the Database or File System?

    • 4 Comments
    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...
  • Brian Swan

    CRUD Operations with the OData SDK for PHP

    • 0 Comments
    Last week I wrote a post about retrieving data from an OData feed by using classes that were generated by the OData SDK for PHP . This week I will go one step farther and look at how to perform CREATE, UPDATE, and DELETE operations (CRUD operations) with...
  • Brian Swan

    This Week’s Link List (March 19, 2010)

    • 0 Comments
    I said last week that I wanted to share my favorite links on a weekly basis, and I still do. But I’m changing the title of the weekly post from “This Week’s Greatest Links” (which, I have to admit, wasn’t a great title) to “This Week’s Link List” (which...
  • Brian Swan

    Retrieving Data with the OData SDK for PHP

    • 3 Comments
    [Upadting this post to incorporate some fixes in the OData SDK for PHP. Also adding this link to a related post: CRUD Operations with the OData SDK for PHP .] Availability of the OData SDK for PHP was announced at MIX10 earlier this week . Actually...
  • Brian Swan

    Consuming “Dallas” Data with PHP

    • 0 Comments
    Given that MIX10 is happening this week and that Microsoft Codename “Dallas” (CTP2) was just released , I thought it would be appropriate to look at how to consume “Dallas” data with PHP. (If you are at MIX10 and want more information, the “Dallas” session...
  • Brian Swan

    This Week’s Greatest Links (Mar 12, 2010)

    • 0 Comments
    I’m jealous that my wife can find the time (I don’t know how she does it) to read so many books just for fun. That isn’t to say that the reading I do isn’t fun, it’s just not the curl-up-on-the-couch-and-get-lost-in-a-story kind of reading I would like...
  • Brian Swan

    MSSQL vs. SQLSRV: What’s the Difference? (Part 2)

    • 18 Comments
    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...
  • Brian Swan

    mssql vs. sqlsrv: What’s the Difference? (Part 1)

    • 14 Comments
    [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...
  • Brian Swan

    Best PHP Projects on Codeplex?

    • 5 Comments
    I started this blog a few weeks ago knowing I had a lot to learn about PHP and about using PHP with Microsoft technologies. That thought was reinforced after I spent some time yesterday looking at the all the PHP-related projects on CodePlex . (CodePlex...
  • Brian Swan

    What's the Right Way to Prevent SQL Injection in PHP Scripts?

    • 21 Comments
    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...
Page 7 of 8 (184 items) «45678