Jay's Blog

[coding, debugging, and troubleshooting with Microsoft Technologies]

February, 2011

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

    Required rights for SQL Server service account

    • 1 Comments
    This topic comes up from time to time in my daily support work, so I thought I would make a quick post on the rights required if you do not want the SQL Server service account to be a member of the Local Administrators group on Windows. Having the SQL...
  • Jay's Blog

    Uninstalling a SQL Server Service Pack

    • 2 Comments
    Did you know that starting with service packs (Service Pack 1) in SQL Server 2008 you can uninstall them from Add/Remove Programs like any other update? But as always, backup both your user and system databases before applying any update, hot fix, cumulative...
  • Jay's Blog

    Finding which queries were executing from a SQL Memory Dump – revisited

    • 8 Comments
    A message about the previous post on finding queries in a SQL Memory Dump file: Back in October I did a post on finding queries in SQL Server Memory Dumps.  It has been a popular topic, but some have had difficulties following it.  After reviewing...
  • Jay's Blog

    Using DBCC PAGE

    • 0 Comments
    DBCC PAGE is an undocumented – and unsupported – DBCC statement in SQL Server for dumping the raw contents of a single database page.   It will return all the metadata stored in the page, and with the right detail level parameter – return the...
Page 1 of 1 (4 items)