Brian Swan

Insights on HDInsight
Posts
  • Brian Swan

    Reflecting on DrupalCon Denver

    • 4 Comments
    I saw a Tweet on Monday that nicely summed up the start to my week: The only thing worse than a Monday is a Monday after #DrupalCon . I’m not sure I’ve quoted it exactly , but I’m sure I’ve captured the sentiment. My Monday wasn’t...
  • 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

    Rendering SQL Server Reports as Excel Documents with PHP

    • 4 Comments
    I wrote a post a while back about getting started with SQL Server Reporting Services (SSRS) and PHP that has generated lots of questions (both in the comments and in e-mail and conversations I’ve had since then). One of the most common questions...
  • Brian Swan

    Paging Data with the SQL Server Drivers for PHP: Simplified

    • 4 Comments
    One of the best insights I had at the SQL Server JumpIn! Camp back in November was this: Lots of PHP applications and frameworks generate SQL queries dynamically. I’m sure that for very experienced developers, that realization comes across as somewhat...
  • 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

    SQL Server Driver for PHP Connection Options: ReturnDatesAsStrings

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

    SQL Server Driver for PHP Connection Options: CharacterSet

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

    Updating PHP Settings in Windows Azure

    • 3 Comments
    I came across this question on Twitter last week: “How can I turn display_errors on for an application that is running in Windows Azure?” I have to admit that I was stumped. The only thing I could think of was to re-deploy the application...
  • Brian Swan

    Book Review: Easy PHP Websites with the Zend Framework

    • 3 Comments
    Several weeks ago (more than I’m willing to admit) Jason Gilmore asked approached me on Twitter and asked me if I’d be interested in reviewing his latest book, Easy PHP Websites with the Zend Framework . I was familiar with Jason’s publications...
  • Brian Swan

    Converting MySQL Queries to MS SQL Server Queries

    • 3 Comments
    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,...
  • 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

    Introduction

    • 3 Comments
    <Tap, tap…> Is this thing on? Hi. My name is Brian Swan. I’m a PHP fan AND I work at Microsoft. Not too long ago, that self-description might have triggered an identity crisis, but recently the intersection between PHP and Microsoft has become...
  • Brian Swan

    SQL Express Size Limit – Filestream Excepted

    • 3 Comments
    I’ve written a couple of blog posts about the Filestream feature that is available with SQL Server Express: one post on my blog ( Store Images in the Database or Filesystem? ) and one post as a guest writer on the SQL Server Driver for PHP Team...
  • Brian Swan

    Now Available: SQL Server Migration Assistant for MySQL!

    • 3 Comments
    The SQL Server Migration Assistant (SSMA) team announced today the availability of the migration assistant for MySQL! (Yes, it supports SQL Server Express.) You can… Read the team’s announcement here: Microsoft Announces SQL Server...
  • Brian Swan

    The SQL Server ODBC Driver for Linux is Available!

    • 3 Comments
    The first beta release of the SQL Server ODBC Driver for Linux is available for download! As announced in October , the “Multiplatform Team” (a.k.a. the “MPlat Team”) has released a preview version of a driver that will provide...
  • Brian Swan

    Accessing Hadoop Logs in HDInsight

    • 3 Comments

    This is a quick post to outline the types of logs that are written to your Azure storage account when you spin up an HDInsight cluster.

    ...
  • Brian Swan

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

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

    Consuming SQL Azure Data with the OData SDK for PHP

    • 2 Comments
    One of the interesting incubation projects that the SQL Azure team is working on is the SQL Azure OData Service. If that sentence makes no sense to you, then start by reading this short overview on the SQL Azure team blog: Introduction to Open Data Protocol...
  • Brian Swan

    PHP on Windows Resources from DPC Presentation

    • 2 Comments
    My “PHP on Windows” presentation at the Dutch PHP Conference (presented today…whew!) focused on the recent improvements in interoperability between PHP and Microsoft Technologies (my slides are attached to this post). If you attended...
  • Brian Swan

    CTP 2 of Microsoft Driver for PHP for SQL Server Released!

    • 2 Comments
    The SQL Server Driver for PHP team has announced the release of CTP 2 of the Microsoft Driver for PHP for SQL Server 2.0 ( download here ). (If you don’t know what a “CTP” release is, see Ashay’s blog post from yesterday .) Back...
  • Brian Swan

    Top 10 PHP-Microsoft Resources

    • 2 Comments
    As I’ve learned (and continue to learn) PHP and Microsoft technologies, I’ve found some very helpful resources on the web. But, they are sometimes hard to find, and they certainly aren’t usually found in one place. So, before I begin drilling into some...
  • Brian Swan

    How to Run PHP in Windows Azure

    • 2 Comments
    In my last post I described how to access SQL Azure from PHP, but I described how to do this when PHP was running on my local server. In other words, I only described how to leverage half the cloud. In this post, I’ll leverage the other half of...
  • 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

    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

    How to Page Data with the SQL Server Drivers for PHP

    • 2 Comments
    [Author's note: See this post for an alternative strategy for paging data: Paging Data with the SQL Server Drivers for PHP: Simplified .] Shortly after the 1.0 version of the SQL Server Driver for PHP was released , I posted on the team blog as about...
Page 2 of 8 (184 items) 12345»