Jason Strate is senior database architect with data platform. He has been working with Microsoft SQL Server for more fifteen years. His experiences include designing and implementing transactional and data warehousing solutions on Microsoft Data Platform technologies, including SQL Server and Parallel Data Warehouse. A recipient of the Microsoft Most Valuable Professional award for Data Platform (formerly SQL Server) since 2009, he also has achieved the Microsoft Certified Master for SQL Server certification.

Jason enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Conferences include the PASS Summit, TechEd North America, SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and many PASS user group meetings. Jason is an active blogger and author with a focus on SQL Server and related technologies.

  • Fred

    Hi Jason,
    Enjoyed your presentation last Saturday in Iowa City. the links i wrote down for the scripts you showed don't seem to work (i probably wrote them down wrong). can you post those by any chance?
    Fred Rosenberg

  • Leon251280

    we made a tool to help you to perform fine-tuning & solve many problems of your SQL Server instances.

    There is a free trial version.
    Can you give us your opinion?


    SQL Server LifeStyle is an analysis tool of SQL Server instances and their databases. The software comes from direct real-world experience, gained from projects implemented in real environments, by constant study of new versions and active participation in beta programs.
    The program, by means native tools, is not intrusive and does not involve any operational impact.

    thank you

  • Hi Jason, I am one of your ardent follower of your blogs. I appreciate if you could help me how to analyse DBCC MEMORYSTATUS. I did google and could not find anything concrete. Regards Murali