Jay's Blog

[coding, debugging, and troubleshooting with Microsoft Technologies]

October, 2012

Blog - About

About Jay's Blog

I am a Premier Field Engineer (PFE) working with Independent Software Vendors (ISVs) that develop solutions using Microsoft Technologies.  This affords me the opportunity to travel to many different places to work with customers that are doing a lot of interesting things with Microsoft Software.  When onsite, I am working with customers to help resolve performance issues or to find better ways to implement solutions using Microsoft products.  I also deliver onsite classes or customized training for development customers.  Most of my time is spent with software development, SQL Server, and Windows Azure.  I've been in the IT Industry for 17 years with most of that focused on database support and development.   This blog draws on my experiences "in the field" as a Microsoft PFE.

  • Jay's Blog

    Orphaned Locks - Idle Session - and XACT_ABORT

    Sometimes you might see a situation where a session is holding locks, blocking other sessions for an extended period of time, but does not have an active request and appears to be Idle.  This can happen in a few different scenarios, but here we’ll...
  • Jay's Blog

    Sequence Objects in SQL 2012 and SQL 2008

      Sequence Objects are new starting in SQL Server 2012.  They work similarly to an IDENTITY value, but where the IDENTITY value is scoped to a specific column in a specific table, the Sequence Object is scoped to the entire database and controlled...
Page 1 of 1 (2 items)