{"id":1313,"date":"2019-05-14T00:00:00","date_gmt":"2019-05-14T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks"},"modified":"2025-06-23T23:53:29","modified_gmt":"2025-06-24T06:53:29","slug":"operationalizing-your-database-health-checks-using-sql-notebooks","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/","title":{"rendered":"Operationalizing your PostgreSQL database health checks using SQL Notebooks"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In Craig Kerstiens\u2018s blog post, \u201c<a href=\"https:\/\/www.citusdata.com\/blog\/2019\/03\/29\/health-checks-for-your-postgres-database\/\" target=\"_blank\" rel=\"noopener\">A health check playbook for your Postgres database<\/a>\u201d he emphasizes the need for periodic checks for your Postgres databases to ensure it\u2019s healthy and performing well. Most Postgres database administrators and community members would usually bookmark or save such articles so they can revisit them and reuse the queries shared in the article to run checks against their databases. The common challenge with this approach is, you end up with many saved archives, and searching through them when you need it is time consuming and less productive. A better way to operationalize your health check runbooks and database scripts is by creating <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/sql-notebooks\" target=\"_blank\" rel=\"noopener\">SQL Notebooks in Azure Data Studio<\/a>. A screenshot of the notebook is below, and we have uploaded the same in our <a href=\"https:\/\/github.com\/Azure\/azure-postgresql\/blob\/master\/samples\/Health%20Checks\/Postgres_database_health_check_notebook.ipynb\" target=\"_blank\" rel=\"noopener\">GitHub repository<\/a> for anyone in the community to download or contribute to it.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/05\/e3ade0c6-0e0f-4ab3-a23d-9542269f4ae8.webp\" alt=\"Screenshot of Postgres database health check notebook\" style=\"border-radius:0px\" title=\"Screenshot of Postgres database health check notebook\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The concept of interactive notebooks, although new in the SQL world, is one of the preferred ways for data scientists to record, understand, and reproduce data analysis in the Python world. The Python now called \u201cJupyter\u201d notebook was first developed in 2011 by a team led by data scientist Fernando P\u00e9rez, and computational physicist Brian Granger. As Fernando P\u00e9rez said, \u201cWe built it by solving problems that we ourselves had as researchers and educators.\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The concept of recording context along with the SQL code is not new for database administrators. In most organizations, database administrators would maintain a document with operational practices along with links to the SQL scripts that need to be run and the order they need to be run in. This is to ensure data quality, consistency, and performance is maintained for end users. However, as time passes people move on, code evolves, and the documentation often becomes stale. Meanwhile, the scripts are updated by engineers as they learn, adapt, and operate, making the documentation and its context less relevant. With SQL Notebooks, the engineers updating the code tend to also update the explanatory text in front of them to explain the edits with relevant context.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As a database engineer, it makes sense to create and maintain a health check notebook where you can maintain your curated SQL scripts along with explanatory text, images, and web links to provide context to anyone reading it or using it for the first time. Notebooks help you record not just the what, but the why, which is often more important. They also make it easy to share and collaborate with the team.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With that understanding, we recorded Craig\u2019s blog into a health check notebook which not only provides monitoring scripts but also explains why you need to run them. The notebook can be reused, updated, or enhanced by anyone in the community as needed.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-get-started-with-azure-data-studio\">How to get started with Azure Data Studio<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">There are even more features to discover, like Git source control integration and customized dashboards and widgets. You can start using the preview for PostgreSQL in Azure Data Studio today, check out the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/postgres-extension?view=sql-server-2017\" target=\"_blank\" rel=\"noopener\">install instructions<\/a>. To start using our preview PostgreSQL extension for Visual Studio Code, learn more on our <a href=\"https:\/\/github.com\/Microsoft\/vscode-postgresql\" target=\"_blank\" rel=\"noopener\">GitHub page<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These two features are in preview and your feedback is critical to making them better and making them work for you. Share your feedback on our PostgreSQL GitHub pages for <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio-postgresql\" target=\"_blank\" rel=\"noopener\">Azure Data Studio<\/a> or <a href=\"https:\/\/github.com\/Microsoft\/vscode-postgresql\" target=\"_blank\" rel=\"noopener\">Visual Studio Code<\/a> respectively.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you would like to follow the development and progress of SQL Notebook in Azure Data Studio, visit the <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\" target=\"_blank\" rel=\"noopener\">Azure Data Studio GitHub page<\/a>. Our engineering team is regularly going through the untriaged issues and assigning issues into different <a href=\"https:\/\/cloudblogs.microsoft.com\/sqlserver\/2019\/03\/18\/the-march-release-of-azure-data-studio-is-now-available\/\" target=\"_blank\" rel=\"noopener\">monthly milestones<\/a> so you know we are working on them, and your votes on issues help us prioritize. If you have any feature requests or issues, please submit to our <a href=\"https:\/\/github.com\/microsoft\/azuredatastudio\/issues\" target=\"_blank\" rel=\"noopener\">GitHub issues page<\/a>. For any questions, feel free to comment below or tweet us <a href=\"https:\/\/twitter.com\/azuredbpostgres\" target=\"_blank\" rel=\"noopener\">@AzureDBPostgres<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"acknowledgements\">Acknowledgements<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Special thanks to Craig Kerstiens and Rachel Agyemang for their contributions to this posting.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Craig Kerstiens\u2018s latest blog post, \u201cA health check playbook for your Postgres database\u201d he emphasizes the need for periodic checks for your Postgres databases to ensure it\u2019s healthy and performing well.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473,1466],"tags":[],"audience":[3057,3055,3056],"content-type":[1511],"product":[1565],"tech-community":[],"topic":[],"coauthors":[528],"class_list":["post-1313","post","type-post","status-publish","format-standard","hentry","category-databases","category-hybrid-multicloud","audience-data-professionals","audience-developers","audience-it-implementors","content-type-best-practices","product-azure-database-for-postgresql","review-flag-free-1680286579-836","review-flag-new-1680286579-546"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Operationalizing your PostgreSQL database health checks using SQL Notebooks | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"In Craig Kerstiens\u2018s latest blog post, \u201cA health check playbook for your Postgres database\u201d he emphasizes the need for periodic checks for your Postgres databases to ensure it\u2019s healthy and performing well.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Operationalizing your PostgreSQL database health checks using SQL Notebooks | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"In Craig Kerstiens\u2018s latest blog post, \u201cA health check playbook for your Postgres database\u201d he emphasizes the need for periodic checks for your Postgres databases to ensure it\u2019s healthy and performing well.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-14T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-24T06:53:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/05\/e3ade0c6-0e0f-4ab3-a23d-9542269f4ae8.webp\" \/>\n<meta name=\"author\" content=\"Parikshit Savjani\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Parikshit Savjani\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/parikshit-savjani\/\",\"@type\":\"Person\",\"@name\":\"Parikshit Savjani\"}],\"headline\":\"Operationalizing your PostgreSQL database health checks using SQL Notebooks\",\"datePublished\":\"2019-05-14T00:00:00+00:00\",\"dateModified\":\"2025-06-24T06:53:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/\"},\"wordCount\":665,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/05\/e3ade0c6-0e0f-4ab3-a23d-9542269f4ae8.webp\",\"articleSection\":[\"Databases\",\"Hybrid + multicloud\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/\",\"name\":\"Operationalizing your PostgreSQL database health checks using SQL Notebooks | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/05\/e3ade0c6-0e0f-4ab3-a23d-9542269f4ae8.webp\",\"datePublished\":\"2019-05-14T00:00:00+00:00\",\"dateModified\":\"2025-06-24T06:53:29+00:00\",\"description\":\"In Craig Kerstiens\u2018s latest blog post, \u201cA health check playbook for your Postgres database\u201d he emphasizes the need for periodic checks for your Postgres databases to ensure it\u2019s healthy and performing well.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/05\/e3ade0c6-0e0f-4ab3-a23d-9542269f4ae8.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/05\/e3ade0c6-0e0f-4ab3-a23d-9542269f4ae8.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Operationalizing your PostgreSQL database health checks using SQL Notebooks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Operationalizing your PostgreSQL database health checks using SQL Notebooks | Microsoft Azure Blog","description":"In Craig Kerstiens\u2018s latest blog post, \u201cA health check playbook for your Postgres database\u201d he emphasizes the need for periodic checks for your Postgres databases to ensure it\u2019s healthy and performing well.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/","og_locale":"en_US","og_type":"article","og_title":"Operationalizing your PostgreSQL database health checks using SQL Notebooks | Microsoft Azure Blog","og_description":"In Craig Kerstiens\u2018s latest blog post, \u201cA health check playbook for your Postgres database\u201d he emphasizes the need for periodic checks for your Postgres databases to ensure it\u2019s healthy and performing well.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2019-05-14T00:00:00+00:00","article_modified_time":"2025-06-24T06:53:29+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/05\/e3ade0c6-0e0f-4ab3-a23d-9542269f4ae8.webp","type":"","width":"","height":""}],"author":"Parikshit Savjani","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Parikshit Savjani","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/parikshit-savjani\/","@type":"Person","@name":"Parikshit Savjani"}],"headline":"Operationalizing your PostgreSQL database health checks using SQL Notebooks","datePublished":"2019-05-14T00:00:00+00:00","dateModified":"2025-06-24T06:53:29+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/"},"wordCount":665,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/05\/e3ade0c6-0e0f-4ab3-a23d-9542269f4ae8.webp","articleSection":["Databases","Hybrid + multicloud"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/","name":"Operationalizing your PostgreSQL database health checks using SQL Notebooks | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/05\/e3ade0c6-0e0f-4ab3-a23d-9542269f4ae8.webp","datePublished":"2019-05-14T00:00:00+00:00","dateModified":"2025-06-24T06:53:29+00:00","description":"In Craig Kerstiens\u2018s latest blog post, \u201cA health check playbook for your Postgres database\u201d he emphasizes the need for periodic checks for your Postgres databases to ensure it\u2019s healthy and performing well.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/05\/e3ade0c6-0e0f-4ab3-a23d-9542269f4ae8.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/05\/e3ade0c6-0e0f-4ab3-a23d-9542269f4ae8.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/operationalizing-your-database-health-checks-using-sql-notebooks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Operationalizing your PostgreSQL database health checks using SQL Notebooks"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=1313"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1313\/revisions"}],"predecessor-version":[{"id":42922,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/1313\/revisions\/42922"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=1313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=1313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=1313"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=1313"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=1313"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=1313"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=1313"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=1313"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=1313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}