How to contribute to SQL Server Documentation

APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel 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:

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.

Edit in your browser

You can make simple edits to SQL Server content in your browser and then submit them to Microsoft. The complete process is documented in the article, Microsoft Docs contributor guide overview. The following video demonstrates the end-to-end process for submitting changes in your browser:

Tip

Note that the location of Edit button is slightly different than what is shown in the video, but the process is the same.

Edit button

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[appliesto-ss-asdb-asdw-pdw-md](../includes/appliesto-ss-asdb-asdw-pdw-md.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 SQL Data Warehouse, 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!