MicrosoftDocsMicrosoftDocs/sql-docs/.github/copilot-instructions.md

sql-docs

Copilot instructions1.3k starsChanged 21 months agoCC-BY-4.0View on GitHub

These instructions define a unified style and process standard for authoring and maintaining learn.microsoft.com documentation with GitHub Copilot or other AI assistance. Below are instructions that apply to all Microsoft…

We split this copilot-instructions.md into the rules it gives an agent

9 rules. About 0 are common, 7 are distinctive, and 2 are very specific to this project.

≈0
Common · estimate
Many files like this have a rule of this kind.
≈7
Distinctive · estimate
This author's own choices. Worth a look.
2
Very specific
Tied to their project's names, files or tools. Probably skip.

Licensed with conditions — read it at the source. We count its rules but don't quote them. Read them on GitHub.

≈ “Common” is an estimate: at least 1 in 5 of the 3,669 Copilot instructions files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Mar 31, 2023azurerm_mssql_managed_instance - Unable to configure [System assigned service principal] option via terraform resource — hashicorp/terraform-provider-azurerm9 reactions · 2 comments
Feb 28, 2023sqlpackage option to exclude specific tables from export — microsoft/DacFx7 reactions · 4 comments
Apr 2, 2020.NET Core - Unable to register data tier application — microsoft/DACExtensions3 reactions · 1 comment
Oct 26, 2026Handle SQL serverless connection warmup without transaction replay — r33drichards/webhook-mcp-router1 reaction · 1 comment
Sep 14, 2023Error authenticating to Azure SQL with second User-Assigned Managed Identity — dotnet/SqlClient1 reaction · 7 comments

26 more on GitHub

Aug 21, 2023support T-SQL DATE_BUCKET() function — babelfish-for-postgresql/babelfish_extensions1 reaction · 1 comment
Aug 18, 2023Update placeholder text for servername in Connection pane — microsoft/azuredatastudio1 reaction
Jul 13, 2026[AI-Suggested] Content update request from UUF signal: Wildcard search (%) - SQL Server | Microsoft Learn — OPS-E2E-PPE/sql-docs0 reactions
Dec 10, 2023Implement HIERARCHYID datatype — babelfish-for-postgresql/babelfish_extensions0 reactions
Dec 9, 2023Implement remote DML using four-part object name — babelfish-for-postgresql/babelfish_extensions0 reactions
Dec 9, 2023Implement remote procedure execution using four-part object name — babelfish-for-postgresql/babelfish_extensions0 reactions
Dec 9, 2023Support dropping of multiple triggers in DROP TRIGGER — babelfish-for-postgresql/babelfish_extensions0 reactions
Dec 9, 2023Support dropping of multiple indexes in DROP INDEX — babelfish-for-postgresql/babelfish_extensions0 reactions
Dec 9, 2023Support dropping of multiple databases in DROP DATABASE — babelfish-for-postgresql/babelfish_extensions0 reactions
Dec 9, 2023Implement execution of a stored procedure whose name is a variable — babelfish-for-postgresql/babelfish_extensions0 reactions
Dec 9, 2023Implement sp_addserver procedure — babelfish-for-postgresql/babelfish_extensions0 reactions
Dec 9, 2023Implement INDEX_COL() T-SQL function — babelfish-for-postgresql/babelfish_extensions0 reactions
Dec 9, 2023Implement SET DATEFORMAT T-SQL statement — babelfish-for-postgresql/babelfish_extensions0 reactions
Dec 8, 2023Implement PERMISSIONS() T-SQL function — babelfish-for-postgresql/babelfish_extensions0 reactions
Apr 21, 2023support '[' and ']' wildcharacter for Like operater — babelfish-for-postgresql/postgresql_modified_for_babelfish0 reactions
Aug 4, 2022Display popup for unsupported settings when connecting to Azure Synapse Analytics / PDW — microsoft/azuredatastudio0 reactions
Jun 13, 2021Add DMA (Data Migration Assistant) — beatcracker/toptout0 reactions
Jun 13, 2021Add SQL Server Management Studio (SSMS) — beatcracker/toptout0 reactions
May 17, 2021Add SSMA (SQL Server Migration Assistant) — beatcracker/toptout0 reactions
May 2, 2021Add Azure Data Studio — beatcracker/toptout0 reactions
Sep 3, 2020Question: which respository is the master for 'Operations and Support Jupyter Book - SQL Server 2019 Big Data Clusters'? — anthonydresser/testissues0 reactions · 1 comment
Jun 9, 2020Server.IsTraceFlagOn returns true for session scope flags when isGlobalTraceFlag param is true — microsoft/sqlmanagementobjects0 reactions
Dec 1, 2017Update sql-server-configuration-manager-help — julienstroheker/MS-Hack-A-Doc0 reactions
Dec 1, 2017Update breaking-changes-to-database-engine-features-in-sql-server-2017 — julienstroheker/MS-Hack-A-Doc0 reactions
Dec 1, 2017Update deprecated-database-engine-features-in-sql-server-2017 — julienstroheker/MS-Hack-A-Doc0 reactions
Dec 1, 2017Update sql-server-linux-release-notes — julienstroheker/MS-Hack-A-Doc0 reactions

On Stack Overflow · 13

Oct 18, 2021How do I import a csv file with a column of guids into sql server table with a column of type uniqueidentifier?3 votes
May 8, 2020You do not have permission to use the bulk load statement error3 votes
Oct 19, 2022"Generate scripts" in SQL Server fails on "getting the list of objects from (mydbname)"2 votes
Jun 17, 2021Problems installing msodbcsql17 with Docker2 votes
Jul 2, 2020Azure SQL Grant Access for AD User using PowerShell and ServicePrincipal2 votes

8 more on Stack Overflow

Aug 8, 2019SQL Server Encryption via symmetric keys (AES_256)1 vote
May 23, 2023SSIS : Executing local dtsx package without using Microsoft.SqlServer.Dts.Runtime in .NET 6 with SQL Server 20190 votes · 1 answer
Feb 19, 2023SQL Server 2022 in LXC crashes and won't get back up0 votes
Jul 13, 2021MSSQL tools on Ubuntu (20.10) Docker Image on M1 MacBook0 votes
Feb 22, 2021EF Core, FromSqlRaw with USE HINT0 votes
Jun 12, 2020Why is sql script not valid when referenced by post deploy0 votes
Nov 16, 2019How do you change the DURABILITY option on an existing memory-optimized table in SQL Server 2016?0 votes
Feb 5, 2025Change column length using SqlPackage without recreating table-2 votes

Where files are headingNew Copilot instructions files have more rules about branches and pull requests, and fewer about code style.
Of the Copilot instructions files we read, the 2,297 first seen in the last six months, against the older ones: the kind of rule that gained most share, and the kind that lost most. About files like this in general, not this one, and an estimate, since a kind is a pattern in the words.

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

It worked
Partly
It didn't

What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

Check your setup, free