Brian Swan

Insights on HDInsight

Browse by Tags

Tagged Content List
  • Blog Post: 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,...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Paging Data with the SQL Server Drivers for PHP: Simplified

    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 naive – and perhaps it is. However, to...
  • Blog Post: Interview: Ashay Chaudhary on the SQL Server JumpIn! Camp

    Well, December did finally slow down a bit and I had a chance to catch up with Ashay Chaudhary , the Program Manager for the Microsoft Drivers for SQL Server for PHP . We had a lot to catch up about because we haven’t found much time to sit down and chat since the JumpIn! Camp last November. Ashay...
  • Blog Post: Update Release of the PHP Drivers for SQL Server

    An update release to the Microsoft Drivers for SQL Server for PHP 2.0 is now available. You can download it here and you can read what Ashay Chaudhary (Program Manager for the drivers) had to say about the release here . The release contains fixes for 4 bugs: Long column names allowed by SQL Server...
  • Blog Post: Why Pass Parameters by Reference in the SQLSRV Driver?

    Last week at JumpIn Camp we spent quite a bit of time focusing on the SQL Server Driver for PHP . As developers worked to build SQL Server support into their applications, they had lots of questions about how both the SQLSRV and PDO_SQLSRV drivers work under the hood. One of the questions that came up...
  • Blog Post: SQL Server Driver for PHP Connection Options: Snapshot Isolation

    In the post I wrote last week about transaction isolation levels I left out an important option: the snapshot isolation level for database transactions. I’ll cover the snapshot isolation level in this post, and (as in my earlier post) I’ll look at what happens at the database level when using...
  • Blog Post: PHP Drivers for SQL Server Released!

    Today, the SQL Server Driver for PHP team released the production-ready 2.0 versions of the SQLSRV and PDO_SQLSRV drivers for SQL Server. You can… Read the official announcement on the SQL Server Driver for PHP team blog here: Microsoft Drivers for PHP for SQL Server 2.0 Released! Download...
  • Blog Post: How to Page Data with the SQL Server Drivers for PHP

    [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 how to page data with the driver . In the v1.1...
  • Blog Post: CTP 2 of Microsoft Driver for PHP for SQL Server Released!

    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 in April the team announced the release of CTP1...
  • Blog Post: Understanding Cursor Options in the SQL Server Driver for PHP

    After v1.0 of the SQL Server Driver for PHP was released (back in July of 2008), the development team received lots of requests to implement “scrollable result sets” (i.e. random access to the rows in a result set) in the next release. They met this request by adding a new option to the sqlsrv_query...
  • Blog Post: Comparing the SQLSRV and PDO APIs

    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 some code. So, as a learning exercise, I converted...
  • Blog Post: PDO Support for SQL Server!

    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 keynote speech at DrupalCon 2010 . In the keynote...
  • Blog Post: Working Down the Stack: Enabling ODBC Tracing with the SQL Server Driver for PHP

    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 is that a query I was executing from PHP seemed...
  • Blog Post: BACKUP and RESTORE A Database with the SQL Server Driver for PHP

    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 your data. For a non-critical application with minimal...
  • Blog Post: Store Images in the Database or File System?

    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 is covered in the driver documentation ). Then...
  • Blog Post: MSSQL vs. SQLSRV: What’s the Difference? (Part 2)

    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 you might use if you were considering moving to the...
Page 1 of 2 (30 items) 12