How to contribute to SQL Server Documentation

APPLIES TO: SQL Server Azure SQL Database Azure Synapse Analytics Parallel Data Warehouse

Anyone can contribute to SQL Server documentation. This includes correcting typos, suggesting better explanations, and improving technical accuracy. This article explains how to get started with content contributions and how the process works.

There are two main workflows you can use to contribute:

Workflow Description
Edit in your browser Good for small, quick edits of any article.
Edit locally with tools Good for more complex edits, edits involving multiple articles, and frequent contributions to docs.microsoft.com.

All public contributions are validated by the SQL content team for technical accuracy and consistency.

Edit in your browser

You can make simple edits to SQL Server content in your browser and then submit them to Microsoft. For more information, you can see the Microsoft Docs contributor guide overview.

The following steps summarize the process:

  1. On the page you have feedback about, select the Edit link at the top right.
  2. On the next page, select the Pencil icon at the top right.
  3. On the next page, in the Edit file text window, make your edits directly to the text you want to change. If you need help with formatting the new or changed text, see the Markdown Cheatsheet.
  4. After you've made your edits, under Commit changes:
    1. In the first text box, enter a brief description of the change you've made.
    2. In the Add an optional extended description box, provide a brief explanation of your change.
  5. Select Propose file change.
  6. On the Comparing changes page, select Create pull request.
  7. On the Open a pull request page, select Create pull request.

The following GIF demonstrates the end-to-end process for submitting changes in your browser:

Edit SQL Docs

Edit locally with tools

Another editing option is to fork the sql-docs or azure-docs repositories and clone it locally to your machine. You can then use a Markdown editor and a git client to submit the changes. This workflow is good for edits that are more complex or involve multiple files. It is also good for frequent contributors to docs.microsoft.com.

To contribute with this method, see the following articles:

If you submit a pull request with significant changes to documentation, you will get a comment in GitHub asking you to submit an online Contribution License Agreement (CLA). You must complete the online form before your pull request can be accepted.

Recognition

If your changes are accepted, you are recognized as a contributor at the top of the article.

Content contribution recognition

sql-docs overview

This section provides some additional guidance on working in the sql-docs repository.

Important

The information in this section is specific to sql-docs. If you are editing a SQL article in the Azure documentation, see the Readme for the azure-docs repository on GitHub.

The sql-docs repository uses several standard folders to organize the content.

Folder Description
docs Contains all published SQL Server content. Subfolders logically organize different areas of the content.
docs/includes Contains include files. These files are blocks of content that can be included in one or more other topics.
./media Each folder can have one media subfolder for article images. The media folder in turn has subfolders with the same name as the topics that the image appears in. Images should be .png files with all lower-case letters and no spaces.
TOC.MD A table-of-contents file. Each subfolder has the option of using one TOC.MD file.

Applies-to includes

Each SQL Server article contains an applies-to include file after the title. This indicates what areas or versions of SQL Server the article applies to.

Consider the following Markdown example that pulls in the appliesto-ss-asdb-asdw-pdw-md.md include file.

[!INCLUDE[SQL Server Azure SQL Database Synapse Analytics PDW ](../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]

This adds the following text at the top of the article:

Applies to text

To find the correct applies-to include file for your article, use the following tips:

  • For a list of commonly used includes, see SQL Server version and applies-to include files.
  • Look at other articles that cover the same feature or a related task. If you edit that article, you can copy the Markdown for the applies-to include link (you can cancel the edit without submitting it).
  • Search the docs/includes directory for files containing the text "applies-to". You can use the Find button in github to quickly filter. Click on the file to see how it is rendered.
  • Pay attention to the naming convention. If there are x's in the name, they are usually placeholders indicating the lack of support for a service. For example, appliesto-xx-xxxx-asdw-xxx-md.md indicates support for only Azure Synapse Analytics, because only asdw is spelled out, whereas the other fields have x's.
  • Some includes specify a version number, such as tsql-appliesto-ss2017-xxxx-xxxx-xxx-md.md. Only use these includes when you know the feature was introduced with a specific version of SQL Server.

Contributor resources

Tip

If you have product feedback rather than documentation feedback, provide feedback on the SQL Server product here.

Next steps

Explore the sql-docs repository on GitHub.

Find an article, submit a change, and help the SQL Server community.

Thank you!