Jay's Blog

[coding, debugging, and troubleshooting with Microsoft Technologies]

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

    How do I track this in my Stored Procedure? (Using a custom trace event)

    • 0 Comments
      It’s been a while since I’ve posted an entry as I’ve been busy with moving to a different position that has me working dedicated to one customer here in my PFE role at MS.  I’ve been keeping up with the topics I want to post about, so there...
  • Jay's Blog

    Cool Windows 7 Feature…

    • 0 Comments
    I’d have to say that one of my favorite new features from Windows 7 – that doesn’t seem to be all that well known – is the new Problem Steps Recorder. It’s a great way for someone to show you the steps they’ve taken...
  • Jay's Blog

    Creating a custom performance monitor counter for SQL Server

    • 3 Comments
    If you have ever needed to monitor a value in SQL Server, or follow the trend of anything that can be expressed in a numerical value – then creating a custom performance monitor counter could be just what you need…. For this example, I...
  • Jay's Blog

    How do I set a breakpoint in a CLR Stored Procedure already deployed and running on a live SQL Server and debug is using Visual Studio?

    • 3 Comments
    For information on setup and debugging a CLR stored procedure in a direct-debug scenario by “stepping-through” the code from within Visual Studio, OR by using a test TSQL script from with Visual Studio, refer to the following MSDN article...
  • Jay's Blog

    How can I create a dump of SQL Server?

    • 0 Comments
    You can create a memory dump of the SQL Server process space in several ways. There are many external tools that can help you accomplish this such as userdump.exe, debugdiag.exe, and ADPlus.exe. In this post, I’ll cover 3 common ways to accomplish...
  • Jay's Blog

    What do I need to know to be good at debugging?

    • 0 Comments
    From time to time I will get this question from people learning to debug application code. Debugging is an unusual skill and is a combination of art and science. However, IMHO the following 3 items or characteristics are super important for being successful...
  • Jay's Blog

    Basic Debugging Concepts and Setup - Part 2 (Basic & Common Commands)

    • 0 Comments
    So if you read my previous post on Basic Debugging Concepts and Setup, you are familiar with how to open a SQL Server dump or attach to the SQL Server process (sqlservr.exe). You are also familiar with what symbols are and why we need them. If you missed...
  • Jay's Blog

    Windows 7 God Mode

    • 0 Comments
    Was browsing through my RSS feeds today and saw this on Channel 9: http://www.downloadsquad.com/2010/01/03/stupid-windows-7-trick-unlock-the-secret-god-mode-folder/ You can create a special folder that has shortcuts for just about every task one...
  • Jay's Blog

    Basic Debugging Concepts and Setup

    • 0 Comments
    In my blog, from time to time I will rely on debugging to explain or prove out a concept. In this context, I am talking about debugging the SQL Server engine itself – not debugging any TSQL code written to run within SQL Server (although I am sure...
  • Jay's Blog

    Hello World

    • 0 Comments
    Welcome to my MSDN blog. I am excited at the prospect of contributing to the MSDN community and helping people do more and solve problems with MS SQL Server. My goal is to keep this blog strictly to the business of SQL Server coding, debugging, and troubleshooting...
  • Jay's Blog

    Test entry

    • 0 Comments
    This is a test entry to make sure Live Writer is working – please ignore
Page 2 of 2 (36 items) 12