{"id":676,"date":"2020-01-24T13:43:31","date_gmt":"2020-01-24T13:43:31","guid":{"rendered":"https:\/\/www.sequallity.co.uk\/?p=676"},"modified":"2020-01-27T14:17:01","modified_gmt":"2020-01-27T14:17:01","slug":"comprehensive-list-of-new-features-of-sql-server-2019","status":"publish","type":"post","link":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/","title":{"rendered":"Comprehensive List of New Features of SQL Server 2019"},"content":{"rendered":"\n

New Features of SQL Server 2019<\/h2>\n\n\n\n

It’s that time again to talk about the New Features of SQL Server 2019. Years ago, there was no need to keep so up-to-date with the New Features of SQL Server due to the release dates of each version (I’m talking about you SQL Server 2000 and SQL Server 2005) between each version. Now, with a much increased release cycle it is critical for any SQL Server DBA to stay in touch with these New Features. Of course, you don’t have to know about all the details of the new features, you just have to know what is there. As the Merovingian would say in the Matrix Reloaded, who has time?<\/p>\n\n\n\n

\"Microsoft<\/figure><\/div>\n\n\n\n

Matrix and SQL Sequels<\/h2>\n\n\n\n

Well, that time has now come (as well as a new Matrix sequel, yay) and SQL Server was released towards the latter part of last year on the 4th November 2019.<\/p>\n\n\n\n

You may think that SQL Server 2019 is an unnecessary release. I believe Microsoft are showing their dominance of the RDBMS market and not resting on their laurels but forging ahead with new and innovative features.<\/p>\n\n\n\n

The New Features list is long, so I’m going to add all the new features here from the Microsoft post – What’s new in SQL Server 2019 (15.x)<\/a><\/p>\n\n\n\n

New Features Path<\/h2>\n\n\n\n

My plan, and there must always be a path, Neo, is to go through the most relevant items and have a play and document my findings here, so if there’s a hyperlink then I’ve looked at it, click it, have a read, let me know.<\/p>\n\n\n\n

It will also form a great reference list of any new Sequallity<\/a> SQL Server 2019 training modules<\/a> (SSRS, DBA, TSQL, Performance Tuning) I have to build going forward to include the up-to-date features of SQL Server 2019.<\/p>\n\n\n\n

There’s so much to do…with these New Features<\/h2>\n\n\n\n

There’s no need to feel inundated, I don’t. I am excited by the challenge these new features bring and I am looking forward to the days when a client says, we need this and I go ah-ha, there’s a great new feature in SQL Server 2019 that does that. To be fair, been there already only a month after SQL Server 2019’s release date and the winner was…Optimize For Sequential Key. <\/p>\n\n\n\n

However, I tuned the database so well, we didn’t need to implement this new feature, which is a shame but it meant the client could stay on their 2016 version if they wanted, they didn’t mind going to SQL Server 2019. If performance degrades again, we’ve got this in my bag if needed.<\/p>\n\n\n\n

It’s always good to have a Plan B.<\/p>\n\n\n\n

Big Data Clusters<\/h2>\n\n\n\n

Scalable big data solution
Data virtualization with PolyBase<\/p>\n\n\n\n

Intelligent Query Processing<\/h2>\n\n\n\n

Row mode memory grant feedback
Batch mode on rowstore
Scalar UDF Inlining
Table variable deferred compilation
Approximate query processing with APPROX_COUNT_DISTINCT<\/p>\n\n\n\n

In-Memory Database<\/h2>\n\n\n\n

Hybrid buffer pool
Memory-optimized TempDB metadata
In-Memory OLTP support for Database Snapshots<\/p>\n\n\n\n

Intelligent performance<\/h2>\n\n\n\n

OPTIMIZE_FOR_SEQUENTIAL_KEY
Forcing fast forward and static cursors
Resource governance
Reduced recompilations for workloads
Indirect checkpoint scalability
Concurrent PFS updates
Scheduler worker migration<\/p>\n\n\n\n

Monitoring<\/h2>\n\n\n\n

WAIT_ON_SYNC_STATISTICS_REFRESH
Custom capture policy for Query Store
LIGHTWEIGHT_QUERY_PROFILING
sys.dm_exec_requests column command
sys.dm_exec_query_plan_stats
LAST_QUERY_PLAN_STATS
query_post_execution_plan_profile
sys.dm_db_page_info(database_id, file_id, page_id, mode)<\/p>\n\n\n\n

Graph<\/h2>\n\n\n\n

Edge constraint cascade delete actions
New graph function – SHORTEST_PATH
Partition tables and indexes
Use derived table or view aliases in graph match query<\/p>\n\n\n\n

Unicode support<\/h2>\n\n\n\n

Support for UTF-8 character encoding<\/p>\n\n\n\n

Language extensions<\/h2>\n\n\n\n

New Java language SDK
Java language SDK is open source
Support for Java data types
New default Java Runtime
SQL Server Language Extensions
Register external languages<\/p>\n\n\n\n

Spatial<\/h2>\n\n\n\n

New spatial reference identifiers (SRIDs)<\/p>\n\n\n\n

Error messages<\/h2>\n\n\n\n

Verbose truncation warnings<\/p>\n\n\n\n

Security<\/h2>\n\n\n\n

Always Encrypted with secure enclaves
Certificate management in SQL Server Configuration Manager
Data Discovery & Classification<\/p>\n\n\n\n

Availability Groups<\/h2>\n\n\n\n

Up to five synchronous replicas
Secondary-to-primary replica connection redirection
HADR Benefits<\/p>\n\n\n\n

Recovery<\/h2>\n\n\n\n

Accelerated database recovery<\/p>\n\n\n\n

Resumable operations<\/h2>\n\n\n\n

Online clustered columnstore index build and rebuild
Resumable online rowstore index build
Suspend and resume initial scan for Transparent Data Encryption (TDE)<\/p>\n\n\n\n

Linux<\/h2>\n\n\n\n

Replication support
Support for the Microsoft Distributed Transaction Coordinator (MSDTC)
OpenLDAP support for third-party AD providers
Machine Learning Services on Linux
TempDB improvements
PolyBase on Linux
Change Data Capture (CDC) support<\/p>\n\n\n\n

Containers<\/h2>\n\n\n\n

Microsoft Container Registry
Non-root containers
Red Hat certified container images
PolyBase and Machine Learning support<\/p>\n\n\n\n

Setup Options<\/h2>\n\n\n\n

New memory setup options
New parallelism setup options<\/p>\n\n\n\n

SQL Server Machine Learning Services<\/h2>\n\n\n\n

Partition-based modeling
Windows Server Failover Cluster<\/p>\n\n\n\n

SQL Server Analysis Services<\/h2>\n\n\n\n

Calculation groups in tabular models
Query interleaving
Many-to-many relationships in tabular models
Property settings for resource governance
Governance setting for Power BI cache refreshes
Online attach<\/p>\n\n\n\n

SQL Server Integration Services<\/h2>\n\n\n\n

Flexible file task
Flexible file source and destination<\/p>\n\n\n\n

SQL Server Master Data Services<\/h2>\n\n\n\n

Support for Azure SQL Database managed instance databases
New HTML controls<\/p>\n\n\n\n

SQL Server Reporting Services<\/h2>\n\n\n\n

Azure SQL Managed Instances
Power BI Premium datasets
enhanced accessibility
Azure Active Directory Application Proxy
Transparent Database Encryption
Microsoft Report Builder Updated<\/p>\n","protected":false},"excerpt":{"rendered":"

New Features of SQL Server 2019 It’s that time again to talk about the New Features of SQL Server 2019. Years ago, there was no need to keep so up-to-date with the New Features of SQL Server due to the release dates of each version (I’m talking about you SQL Server 2000 and SQL Server 2005) between each version. Now, with a much increased release cycle it is critical for<\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[426,425,266],"tags":[427],"class_list":["post-676","post","type-post","status-publish","format-standard","hentry","category-sql-server-2019","category-sql-server-new-features","category-sql-server-training","tag-new-features-of-sql-server-2019"],"yoast_head":"\nComprehensive List of New Features of SQL Server 2019<\/title>\n<meta name=\"description\" content=\"Here is a comprehensive list of New Features of SQL Server 2019 and some links to interesting enhancements for administration and tuning.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comprehensive List of New Features of SQL Server 2019\" \/>\n<meta property=\"og:description\" content=\"Here is a comprehensive list of New Features of SQL Server 2019 and some links to interesting enhancements for administration and tuning.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Server Consultancy and SQL Server Training\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-24T13:43:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-27T14:17:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2020\/01\/SQLServer2019Logo.jpg\" \/>\n<meta name=\"author\" content=\"John Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sequallity\" \/>\n<meta name=\"twitter:site\" content=\"@sequallity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/\"},\"author\":{\"name\":\"John Parker\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f\"},\"headline\":\"Comprehensive List of New Features of SQL Server 2019\",\"datePublished\":\"2020-01-24T13:43:31+00:00\",\"dateModified\":\"2020-01-27T14:17:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/\"},\"wordCount\":807,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\"},\"keywords\":[\"New Features of SQL Server 2019\"],\"articleSection\":[\"SQL Server 2019\",\"SQL Server New Features\",\"SQL Server Training\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/\",\"name\":\"Comprehensive List of New Features of SQL Server 2019\",\"isPartOf\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website\"},\"datePublished\":\"2020-01-24T13:43:31+00:00\",\"dateModified\":\"2020-01-27T14:17:01+00:00\",\"description\":\"Here is a comprehensive list of New Features of SQL Server 2019 and some links to interesting enhancements for administration and tuning.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Training\",\"item\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/sql-server-training\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Comprehensive List of New Features of SQL Server 2019\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\",\"name\":\"SQL Server Consultancy and SQL Server Training\",\"description\":\"where SQL and Quality join...\",\"publisher\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\",\"name\":\"Sequallity Limited\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg\",\"contentUrl\":\"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg\",\"width\":800,\"height\":229,\"caption\":\"Sequallity Limited\"},\"image\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/\",\"https:\/\/twitter.com\/sequallity\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f\",\"name\":\"John Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g\",\"caption\":\"John Parker\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Comprehensive List of New Features of SQL Server 2019","description":"Here is a comprehensive list of New Features of SQL Server 2019 and some links to interesting enhancements for administration and tuning.","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:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/","og_locale":"en_GB","og_type":"article","og_title":"Comprehensive List of New Features of SQL Server 2019","og_description":"Here is a comprehensive list of New Features of SQL Server 2019 and some links to interesting enhancements for administration and tuning.","og_url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/","og_site_name":"SQL Server Consultancy and SQL Server Training","article_publisher":"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/","article_published_time":"2020-01-24T13:43:31+00:00","article_modified_time":"2020-01-27T14:17:01+00:00","og_image":[{"url":"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2020\/01\/SQLServer2019Logo.jpg"}],"author":"John Parker","twitter_card":"summary_large_image","twitter_creator":"@sequallity","twitter_site":"@sequallity","twitter_misc":{"Written by":"John Parker","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/#article","isPartOf":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/"},"author":{"name":"John Parker","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f"},"headline":"Comprehensive List of New Features of SQL Server 2019","datePublished":"2020-01-24T13:43:31+00:00","dateModified":"2020-01-27T14:17:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/"},"wordCount":807,"commentCount":0,"publisher":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization"},"keywords":["New Features of SQL Server 2019"],"articleSection":["SQL Server 2019","SQL Server New Features","SQL Server Training"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/","name":"Comprehensive List of New Features of SQL Server 2019","isPartOf":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website"},"datePublished":"2020-01-24T13:43:31+00:00","dateModified":"2020-01-27T14:17:01+00:00","description":"Here is a comprehensive list of New Features of SQL Server 2019 and some links to interesting enhancements for administration and tuning.","breadcrumb":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/comprehensive-list-of-new-features-of-sql-server-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/"},{"@type":"ListItem","position":2,"name":"SQL Server Training","item":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/sql-server-training\/"},{"@type":"ListItem","position":3,"name":"Comprehensive List of New Features of SQL Server 2019"}]},{"@type":"WebSite","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/","name":"SQL Server Consultancy and SQL Server Training","description":"where SQL and Quality join...","publisher":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization","name":"Sequallity Limited","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/","url":"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg","contentUrl":"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg","width":800,"height":229,"caption":"Sequallity Limited"},"image":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/","https:\/\/twitter.com\/sequallity"]},{"@type":"Person","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f","name":"John Parker","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g","caption":"John Parker"}}]}},"_links":{"self":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/676","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/comments?post=676"}],"version-history":[{"count":4,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/676\/revisions"}],"predecessor-version":[{"id":703,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/676\/revisions\/703"}],"wp:attachment":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/media?parent=676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/categories?post=676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/tags?post=676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}