{"id":108872,"date":"2026-03-25T13:00:00","date_gmt":"2026-03-25T13:00:00","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=108872"},"modified":"2026-03-03T16:52:15","modified_gmt":"2026-03-03T16:52:15","slug":"everything-you-should-know-about-the-sql-server-resource-database","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/everything-you-should-know-about-the-sql-server-resource-database\/","title":{"rendered":"Everything you should know about the SQL Server Resource database"},"content":{"rendered":"\n<p>Every <a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server<\/a> instance contains a database that most people never query, never back up, and never even see in <a href=\"https:\/\/learn.microsoft.com\/en-us\/ssms\/object\/object-explorer\" target=\"_blank\" rel=\"noreferrer noopener\">Object Explorer<\/a>. Yet, without it, SQL Server would not start. Enter the SQL Server\u00a0Resource database.<\/p>\n\n\n\n<p>This article explains\u00a0what the SQL Server Resource database is,\u00a0why it exists, and\u00a0how it affects patching, upgrades, and troubleshooting\u00a0&#8211; without the mythology that often surrounds it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-the-sql-server-resource-database\">What is the SQL Server Resource database?<\/h2>\n\n\n\n<p>The SQL Server Resource database is a\u00a0hidden, read-only system database\u00a0that contains:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>System object definitions<br><\/li>\n\n\n\n<li>System <a href=\"https:\/\/www.red-gate.com\/simple-talk\/blogs\/for-the-love-of-stored-procedures\/\" target=\"_blank\" rel=\"noreferrer noopener\">stored procedures<\/a><br><\/li>\n\n\n\n<li>System views<br><\/li>\n\n\n\n<li>Internal metadata required by the SQL Server engine<\/li>\n<\/ul>\n<\/div>\n\n\n<p>Logically, these objects appear to live in the&nbsp;master&nbsp;database. Physically, they do not. Instead, they live in two files:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>mssqlsystemresource.mdf<br><\/li>\n\n\n\n<li>mssqlsystemresource.ldf<\/li>\n<\/ul>\n<\/div>\n\n\n<p>These files sit alongside the system databases, but they are\u00a0not listed\u00a0as a database in normal system views.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-why-does-the-sql-server-resource-database-even-exist\">Why does the SQL Server Resource database even exist?<\/h2>\n\n\n\n<p>To understand\u00a0<em>why<\/em> the SQL Server Resource database\u00a0exists, it helps to understand what came before it.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-before-sql-server-2005\">Before SQL Server 2005<\/h3>\n\n\n\n<p>In <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=51958\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server 2000<\/a> and earlier:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>System objects physically lived in\u00a0master<br><\/li>\n\n\n\n<li>Patching replaced or modified system objects directly<br><\/li>\n\n\n\n<li>Upgrades were intrusive and risky<br><\/li>\n\n\n\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/podcasts\/rollback-vs-roll-forward-in-databases\/\" target=\"_blank\" rel=\"noreferrer noopener\">Rollbacks<\/a> were difficult or impossible<\/li>\n<\/ul>\n<\/div>\n\n\n<p>The&nbsp;master&nbsp;database was both:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>A configuration database<br><\/li>\n\n\n\n<li>A code container<\/li>\n<\/ul>\n<\/div>\n\n\n<p>That coupling caused real problems.<\/p>\n\n\n\n<p>It was common &#8211; and still is &#8211; for users to create objects in the master database, because it&#8217;s the only place where code can be created and used by all databases. (I wish it was possible to create <em>true<\/em> libraries in SQL Server!)<\/p>\n\n\n\n<p>The problem then, was that the upgrade\/patching code needed to modify the master database couldn&#8217;t be sure of the state of that database &#8211; making it far more likely for updates to fail.<\/p>\n\n\n\n<p>The Resource database was introduced in SQL Server 2005 to solve that very specific problem: to decouple system code from system configuration.<\/p>\n\n\n\n<section id=\"my-first-block-block_57fcf8b7dbb0290747c3e87457ff9b74\" class=\"my-first-block alignwide\">\n    <div class=\"bg-brand-600 text-base-white py-5xl px-4xl rounded-sm bg-gradient-to-r from-brand-600 to-brand-500 red\">\n        <div class=\"gap-4xl items-start md:items-center flex flex-col md:flex-row justify-between\">\n            <div class=\"flex-1 col-span-10 lg:col-span-7\">\n                <h3 class=\"mt-0 font-display mb-2 text-display-sm\">Fast, reliable and consistent SQL Server development&#8230;<\/h3>\n                <div class=\"child:last-of-type:mb-0\">\n                                            &#8230;with SQL Toolbelt Essentials. 10 ingeniously simple tools for accelerating development, reducing risk, and standardizing workflows.                                    <\/div>\n            <\/div>\n                                            <a href=\"https:\/\/www.red-gate.com\/products\/sql-toolbelt-essentials\/\" class=\"btn btn--secondary btn--lg\" aria-label=\"Learn more &amp; try for free: Fast, reliable and consistent SQL Server development...\">Learn more &amp; try for free<\/a>\n                    <\/div>\n    <\/div>\n<\/section>\n\n\n<p>In practical terms:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>Code\u00a0should be patchable<br><\/li>\n\n\n\n<li>Configuration\u00a0should be preserved<\/li>\n<\/ul>\n<\/div>\n\n\n<p>The Resource database contains\u00a0<em>code<\/em>,\u00a0and the master\u00a0contains\u00a0<em>instance state<\/em>. This allows for a much cleaner separation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-lives-where-in-the-sql-server-resource-database\">What lives where in the SQL Server Resource database<\/h2>\n\n\n\n<p>The SQL Server Resource database contains:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>Definitions for system catalog views such as:<ul><li>sys.objects<\/li><\/ul><ul><li>sys.tables<\/li><\/ul><div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>sys.indexes<br><\/li>\n<\/ul>\n<\/div><\/li>\n\n\n\n<li>System stored procedures<br><\/li>\n\n\n\n<li>Internal functions<br><\/li>\n\n\n\n<li>Metadata required for query compilation and execution<\/li>\n<\/ul>\n<\/div>\n\n\n<p>When you run:<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:tsql decode:true \" >    SELECT * FROM sys.objects;<\/pre><\/div>\n\n\n\n<p>SQL Server is reading <em>metadata<\/em> from the Resource database. Rather than metadata, the&nbsp;master&nbsp;database contains:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/learn\/sql-server-authentication-methods\/\" target=\"_blank\" rel=\"noreferrer noopener\">Logins<\/a><br><\/li>\n\n\n\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/blogs\/sql-endpoint-secrets-you-need-to-know\/\" target=\"_blank\" rel=\"noreferrer noopener\">Endpoints<\/a><br><\/li>\n\n\n\n<li>Configuration settings<br><\/li>\n\n\n\n<li>Linked servers<br><\/li>\n\n\n\n<li>Database metadata<br><\/li>\n\n\n\n<li>Service-level state<\/li>\n<\/ul>\n<\/div>\n\n\n<p>The master database&nbsp;<em>references<\/em>&nbsp;system objects; it does not own their definitions.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-does-sql-server-use-the-resource-database\">How does SQL Server use the Resource database?<\/h2>\n\n\n\n<p>At startup:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>SQL Server starts with minimal functionality<br><\/li>\n\n\n\n<li>master\u00a0is brought online<br><\/li>\n\n\n\n<li>The Resource database is attached internally<br><\/li>\n\n\n\n<li>System objects become visible through metadata views<\/li>\n<\/ul>\n<\/div>\n\n\n<p>If the Resource database is missing or corrupted:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>SQL Server\u00a0will not start<br><\/li>\n\n\n\n<li>You cannot rebuild it independently<br><\/li>\n\n\n\n<li>Recovery requires reinstallation or file restoration<\/li>\n<\/ul>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-why-is-the-sql-server-resource-database-read-only\">Why is the SQL Server Resource database read-only?<\/h2>\n\n\n\n<p>The Resource database is\u00a0intentionally read-only.<\/p>\n\n\n\n<p>This prevents:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>Accidental modification<br><\/li>\n\n\n\n<li><a href=\"https:\/\/www.red-gate.com\/blog\/got-drift-redgate-flyway-now-helps-you-resolve-it-quicker\/\" target=\"_blank\" rel=\"noreferrer noopener\">Drift<\/a> between instances<br><\/li>\n\n\n\n<li>Corruption caused by user activity<\/li>\n<\/ul>\n<\/div>\n\n\n<p>It also ensures:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>Consistent system object definitions<br><\/li>\n\n\n\n<li>Predictable patch behavior<br><\/li>\n\n\n\n<li>Repeatable upgrades<\/li>\n<\/ul>\n<\/div>\n\n\n<p>Allowing writes here would reintroduce the same fragility SQL Server had before 2005.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-patching-and-the-sql-server-resource-database\">Patching and the SQL Server Resource database<\/h2>\n\n\n\n<p>When you apply a cumulative update or service pack:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>SQL Server\u00a0replaces the Resource database files<br><\/li>\n\n\n\n<li>System object definitions are updated atomically<br><\/li>\n\n\n\n<li>master\u00a0and user databases are untouched<\/li>\n<\/ul>\n<\/div>\n\n\n<p>This design is why:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>Patching does not modify user metadata<br><\/li>\n\n\n\n<li>Rollbacks are possible<br><\/li>\n\n\n\n<li>Version consistency is easier to maintain<\/li>\n<\/ul>\n<\/div>\n\n\n<section id=\"my-first-block-block_1fd25bc4d09cfe39f27a60da40a8f1de\" class=\"my-first-block alignwide\">\n    <div class=\"bg-brand-600 text-base-white py-5xl px-4xl rounded-sm bg-gradient-to-r from-brand-600 to-brand-500 red\">\n        <div class=\"gap-4xl items-start md:items-center flex flex-col md:flex-row justify-between\">\n            <div class=\"flex-1 col-span-10 lg:col-span-7\">\n                <h3 class=\"mt-0 font-display mb-2 text-display-sm\">Enjoying this article? Subscribe to the Simple Talk newsletter<\/h3>\n                <div class=\"child:last-of-type:mb-0\">\n                                            Get selected articles, event information, podcasts and other industry content delivered straight to your inbox.                                    <\/div>\n            <\/div>\n                                            <a href=\"https:\/\/www.red-gate.com\/simple-talk\/subscribe\/\" class=\"btn btn--secondary btn--lg\" aria-label=\"Subscribe now: Enjoying this article? Subscribe to the Simple Talk newsletter\">Subscribe now<\/a>\n                    <\/div>\n    <\/div>\n<\/section>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-why-don-t-you-back-up-the-sql-server-resource-database\">Why don&#8217;t you back up the SQL Server Resource database?<\/h2>\n\n\n\n<p>You will often hear:<\/p>\n\n\n\n<p><em>You don\u2019t need to back up the Resource database.<\/em><\/p>\n\n\n\n<p>That statement is correct &#8211; but incomplete. Backups of it aren\u2019t useful because:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>The Resource database is version-specific<br><\/li>\n\n\n\n<li>It is replaced during patching<br><\/li>\n\n\n\n<li>Restoring it across versions is unsupported<\/li>\n<\/ul>\n<\/div>\n\n\n<p>A backup does not provide a meaningful recovery path. Instead, you protect the Resource database indirectly by protecting:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>SQL Server installation media<br><\/li>\n\n\n\n<li>Cumulative update installers<br><\/li>\n\n\n\n<li>System database backups (master,\u00a0msdb, distribution)<\/li>\n\n\n\n<li>Encryption keys (SMK, certificates, DMKs)<br><\/li>\n<\/ul>\n<\/div>\n\n\n<p>If the Resource database is lost, recovery is\u00a0reinstallation &#8211; not restore.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-common-myths-about-the-sql-server-resource-database\">Common myths about the SQL Server Resource database<\/h2>\n\n\n\n<p><em>System objects live in master<\/em><\/p>\n\n\n\n<p>Incorrect. They <em>appear<\/em> to live in master, but do not.<\/p>\n\n\n\n<p><em>You can modify system procedures<\/em><\/p>\n\n\n\n<p>You can override behavior in limited ways, but you cannot safely modify the underlying definitions.<\/p>\n\n\n\n<p><em>Corruption in master affects system code<\/em><\/p>\n\n\n\n<p>Usually, it does not. System code lives elsewhere.<\/p>\n\n\n\n<p><em>The Resource database is optional<\/em><\/p>\n\n\n\n<p>Incorrect. SQL Server cannot run without the Resource database.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-to-view-the-sql-server-resource-database-carefully\">How to view the SQL Server Resource database (carefully)<\/h2>\n\n\n\n<p>You\u00a0<em>can<\/em>\u00a0see the SQL Server Resource database files:<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:tsql decode:true \" >SELECT *\n    FROM sys.database_files;\n<\/pre><\/div>\n\n\n\n<p>You can also attach a copy for inspection:<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:tsql decode:true \" >CREATE DATABASE resource_copy\n    ON (FILENAME = '...\\mssqlsystemresource.mdf')\n    FOR ATTACH;\n<\/pre><\/div>\n\n\n\n<p>This should be done:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>Read-only<br><\/li>\n\n\n\n<li>For investigation only<br><\/li>\n\n\n\n<li>Never for modification<\/li>\n<\/ul>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-why-does-understanding-the-sql-server-resource-database-matter\">Why does understanding the SQL Server Resource database matter?<\/h2>\n\n\n\n<p>Understanding the SQL Server Resource database helps you:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>Diagnose startup failures<br><\/li>\n\n\n\n<li>Understand patch behavior<br><\/li>\n\n\n\n<li>Explain why system objects change after updates<br><\/li>\n\n\n\n<li>Avoid dangerous assumptions about\u00a0master<br><\/li>\n\n\n\n<li>Understand SQL Server architecture accurately<\/li>\n<\/ul>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-sql-server-resource-database-in-summary\">The SQL Server Resource database: in summary<\/h2>\n\n\n\n<p>The SQL Server Resource database is invisible by design, but fundamental by necessity. It exists to make SQL Server:<\/p>\n\n\n<div class=\"block-core-list\">\n<ul class=\"wp-block-list\">\n<li>Safer to patch<br><\/li>\n\n\n\n<li>Easier to upgrade<br><\/li>\n\n\n\n<li>More resilient to failure<br><\/li>\n\n\n\n<li>Cleaner in architecture<\/li>\n<\/ul>\n<\/div>\n\n\n<section id=\"faq\" class=\"faq-block my-5xl\">\n    <h2>FAQs: The SQL Server Resource database<\/h2>\n\n                        <h3 class=\"mt-4xl\">1. What is the SQL Server Resource database?<\/h3>\n            <div class=\"faq-answer\">\n                <p data-start=\"89\" data-end=\"244\">A hidden, read-only system database that stores SQL Server system object definitions and internal metadata.<\/p>\n            <\/div>\n                    <h3 class=\"mt-4xl\">2. Where is the SQL Server Resource database stored?<\/h3>\n            <div class=\"faq-answer\">\n                <p data-start=\"246\" data-end=\"359\">In <code data-start=\"275\" data-end=\"300\">mssqlsystemresource.mdf<\/code> and <code data-start=\"305\" data-end=\"330\">mssqlsystemresource.ldf<\/code>, alongside system databases.<\/p>\n            <\/div>\n                    <h3 class=\"mt-4xl\">3. Why does the SQL Server Resource database exist?<\/h3>\n            <div class=\"faq-answer\">\n                <p data-start=\"361\" data-end=\"465\">To separate system code from configuration, making patching and upgrades safer.<\/p>\n            <\/div>\n                    <h3 class=\"mt-4xl\">4. Can you back-up or restore the SQL Server Resource database?<\/h3>\n            <div class=\"faq-answer\">\n                <p data-start=\"467\" data-end=\"562\">No. It\u2019s version-specific and replaced during patching.<\/p>\n            <\/div>\n                    <h3 class=\"mt-4xl\">5. What happens if the SQL Server Resource database is missing or corrupted?<\/h3>\n            <div class=\"faq-answer\">\n                <p data-start=\"564\" data-end=\"683\">SQL Server won\u2019t start; recovery requires reinstalling or restoring the files.<\/p>\n            <\/div>\n                    <h3 class=\"mt-4xl\">6. Does patching modify master in SQL Server?<\/h3>\n            <div class=\"faq-answer\">\n                <p data-start=\"685\" data-end=\"782\">No. Updates replace the Resource database files, not <code data-start=\"773\" data-end=\"781\">master<\/code>.<\/p>\n            <\/div>\n                    <h3 class=\"mt-4xl\">7. Are system objects in master in SQL Server?<\/h3>\n            <div class=\"faq-answer\">\n                <div class=\"flex flex-col text-sm pb-25\">\n<article class=\"text-token-text-primary w-full focus:outline-none [--shadow-height:45px] has-data-writing-block:pointer-events-none has-data-writing-block:-mt-(--shadow-height) has-data-writing-block:pt-(--shadow-height) [&amp;:has([data-writing-block])&gt;*]:pointer-events-auto scroll-mt-[calc(var(--header-height)+min(200px,max(70px,20svh)))]\" dir=\"auto\" data-turn-id=\"request-WEB:358b345f-b330-4df0-bc70-817954b2b779-1\" data-testid=\"conversation-turn-4\" data-scroll-anchor=\"true\" data-turn=\"assistant\">\n<div class=\"text-base my-auto mx-auto pb-10 [--thread-content-margin:--spacing(4)] @w-sm\/main:[--thread-content-margin:--spacing(6)] @w-lg\/main:[--thread-content-margin:--spacing(16)] px-(--thread-content-margin)\">\n<div class=\"[--thread-content-max-width:40rem] @w-lg\/main:[--thread-content-max-width:48rem] mx-auto max-w-(--thread-content-max-width) flex-1 group\/turn-messages focus-visible:outline-hidden relative flex w-full min-w-0 flex-col agent-turn\">\n<div class=\"flex max-w-full flex-col grow\">\n<div class=\"min-h-8 text-message relative flex w-full flex-col items-end gap-2 text-start break-words whitespace-normal [.text-message+&amp;]:mt-1\" dir=\"auto\" data-message-author-role=\"assistant\" data-message-id=\"6b6ef748-d2fe-4bd5-a344-5a880c39b3fd\" data-message-model-slug=\"gpt-5-2\">\n<div class=\"flex w-full flex-col gap-1 empty:hidden first:pt-[1px]\">\n<div class=\"markdown prose dark:prose-invert w-full wrap-break-word light markdown-new-styling\">\n<p data-start=\"784\" data-end=\"893\" data-is-last-node=\"\" data-is-only-node=\"\">No. They appear in <code data-start=\"839\" data-end=\"847\">master<\/code> but physically live in the Resource database.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/article>\n<\/div>\n            <\/div>\n            <\/section>\n","protected":false},"excerpt":{"rendered":"<p>Learn what the SQL Server Resource database is, why it exists, how it affects patching\/ upgrades, and what to do if it\u2019s missing\/corrupted.&hellip;<\/p>\n","protected":false},"author":346483,"featured_media":108873,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143523,53,143524],"tags":[4168,4170,4150,4151],"coauthors":[159368],"class_list":["post-108872","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-featured","category-sql-server","tag-database","tag-database-administration","tag-sql","tag-sql-server"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/108872","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/346483"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=108872"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/108872\/revisions"}],"predecessor-version":[{"id":108954,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/108872\/revisions\/108954"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/108873"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=108872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=108872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=108872"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=108872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}