John Welch

John Welch is the Chief Technology Officer at SentryOne, where he leads a team in the development of a suite of data and BI products that make monitoring, building, testing, and documenting data solutions faster and more efficient. John has been working with data, business intelligence, and data warehousing technologies since 2001. He was awarded as a Microsoft Most Valued Professional (MVP) 2009 - 2016 due to his commitment to sharing his knowledge with the IT community, and is an SSAS Maestro. John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), SQL Bits, and others. He has also contributed to multiple books on SQL Server and business intelligence.

Articles by John Welch

John Welch discusses 3 reasons stakeholders may resist change and shares tips for helping stakeholders get on board with planned changes.
John Welch shares a simple problem-solving framework that can be applied to many types of problems.
January 26, 2021 | John Welch | Career, Problem Solving 0
Explore 5 common challenges to implementing DataOps in your organization and how to address them.
September 1, 2020 | John Welch | DataOps, Process Improvement 0
John Welch shares several reasons why open source is a valuable investment for ISVs from both a technical and team member career development perspective.
July 29, 2020 | John Welch | Engineering, Open Source 0
John Welch shares a script that can be used to convert MAXDOP to an Advisory Condition for the SentryOne Monitoring Platform.
John Welch shares a script for checking MAXDOP, a SQL Server setting that controls how many processors may be used for parallel plan execution.
February 18, 2020 | John Welch | Performance, T-SQL, SQL Server, MAXDOP 0
John Welch shares a preview of the articles and open source projects that will be delivered by the SentryOne Engineering team over the next several months.
September 12, 2019 | John Welch | SentryOne Test, DevOps, Engineering 0
In this blog, view and contribute product samples via GitHub that demonstrate how to accomplish common tasks for automated data testing in SentryOne Test.
In this blog post, we answer the questions from our PaaSport to Paradise webinar, including info about SSIS, Azure Data Factory, and Azure DevOps.
June 27, 2019 | John Welch | Azure Data Factory, ETL, SSIS 0
Poor-quality data is a common problem that affects companies of all sizes in all industries. Understanding where to implement data validation tests to solve for it is another challenge.
April 9, 2019 | John Welch | SentryOne, SentryOne Test 0
SentryOne Test, our new SaaS-based data test and validation solution, has been released into public preview. Find out how to take advantage of special preview pricing.
Task Factory 2018.3 provides SSIS components that connect to Amazon S3, Microsoft Azure storage accounts, and Azure Data Factory (ADF).

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More