{"id":8958,"date":"2014-11-04T10:46:42","date_gmt":"2014-11-04T10:46:42","guid":{"rendered":"https:\/\/sg.syspro.com\/blog\/high-level-customization-get-it-right\/"},"modified":"2025-04-02T11:44:15","modified_gmt":"2025-04-02T09:44:15","slug":"high-level-customization-get-it-right","status":"publish","type":"post","link":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/","title":{"rendered":"High Level Customization &#8211; Get it Right!"},"content":{"rendered":"<p>I have been spending a great deal more time \u2018on the road\u2019 in recent months due to the change in my position in July at K3 Syspro. As well as crossing England\u2019s infamous <a href=\"http:\/\/en.wikipedia.org\/wiki\/North%E2%80%93South_divide_(England)\">North\/South divide<\/a> on a weekly basis, I have also come into contact with some very high-level customizations both within and outside of the SYSPRO system &#8211; some good, some bad.\u00a0 This has lead me to ponder how best to connect all of these technologies to work in the most effective way.\u00a0 The technologies I\u2019ve come into contact with on my travels can be summarized as follows:<\/p>\n<p><!--more--><\/p>\n<ul>\n<li>SYSRPRO Trigger programs \u2013 simple triggers that fire from SYSPRO events as they happen<\/li>\n<li>SYSPRO Electronic Signatures \u2013 a much more granular and powerful event-driven technology that extends the possibilities available in SYSPRO Triggers<\/li>\n<li>SYSPRO Event Management \u2013 the ability to send emails, generate a log file and run standard and non-standard SYSPRO programs from events in the business process<\/li>\n<li>SQL Triggers &#8211; a technology available within Microsoft SQL Server to fire events from changes to core data in your SYSPRO database<\/li>\n<li>SQL Stored Procedures \u2013 another powerful facet of Microsoft SQL Server, allowing high-level business transactions to be handled at the core data level, outside of the SYSPRO program<\/li>\n<li>SQL Service Broker \u2013 an inherent feature of Microsoft SQL Server that acts as a queue, waits for \u2018messages\u2019 and executes business logic when these \u2018messages\u2019 are received<\/li>\n<li><a href=\"http:\/\/www.k3syspro.com\/case-studies\/dudson-group-2\">K3 Syspro\u2019s DataSwitch<\/a> \u2013 a powerful automation product of K3 Syspro\u2019s that can handle thousands of Business Object transactions in minutes, leveraging SYSPRO\u2019s Business Objects framework<\/li>\n<li>Windows Scheduled Tasks \u2013 a long-standing feature of Windows that allows programs, scripts and automation to fire on various timers throughout the week<\/li>\n<li>VBScripting \u2013 a scripting language supported by SYSPRO programs to add additional functionality to the transactions and processes carried out in SYSPRO programs<\/li>\n<\/ul>\n<p>The challenge as I have found is how to best leverage each of these technologies for the requirement at hand.\u00a0 With the power and flexibility behind these technologies, in particular SYSPRO and Microsoft SQL Server, it is possible to achieve the same goal many different ways. So how do you build a complex customization in the best way?\u00a0 I have some thoughts:<\/p>\n<ul>\n<li>Document your requirements thoroughly: Many of the available technologies are essentially fired from a particular \u2018event\u2019 in your business process; so work out what exactly this is, how often it fires and exactly what should\/shouldn\u2019t happen off the back of this.\u00a0 Document this two ways \u2013 in non-technical board-level terms, and in high-level technical terms.\u00a0 This will act as an instruction guide for those on both sides of the fence.<\/li>\n<li>Involve experts or understand the technologies thoroughly: Generally speaking, each of the technologies listed above is best used for a particular purpose. But only with those who know the products intimately are you able to choose the best product for the job and design a solution that meets generally-accepted best practice.\u00a0 This may involve additional expense but you really can\u2019t beat sitting down with an expert.<\/li>\n<li>Be aware of knock-on effects and caveats: As follow-on from the above, be aware of caveats and potential pitfalls in the use of some of these technologies.\u00a0 For example, all global SYSPRO support desks are aware of the impact of poorly written SQL Triggers in SYSPRO SQL tables.\u00a0 This doesn\u2019t mean don\u2019t use them, it means be sure that another technology isn\u2019t better suited for the purpose (SYSPRO Electronic Signatures for example).\u00a0\u00a0 As with any new feature or solution (no matter how small), test, test and test again!<\/li>\n<\/ul>\n<p>I firmly believe (and follow) the old adage \u201cFail to plan, plan to fail\u201d.\u00a0 Planning additional time\/budget to plan, agree and sign-off on the best technological approach for your high-level customizations is worth its weight in gold. Your entire solution will be quicker, more efficient and robust enough to withstand upgrades in the future.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Reading Time: <\/span> <span class=\"rt-time\"> 4<\/span> <span class=\"rt-label rt-postfix\">minutes<\/span><\/span>I have been spending a great deal more time \u2018on the road\u2019 in recent months due to the change in my position in July at K3 Syspro. As well as crossing England\u2019s infamous North\/South divide on a weekly basis, I have also come into contact with some very high-level customizations both within and outside of &#8230; <a title=\"High Level Customization &#8211; Get it Right!\" class=\"read-more\" href=\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/\" aria-label=\"Read more about High Level Customization &#8211; Get it Right!\">Read more<\/a><\/p>\n","protected":false},"author":144,"featured_media":6237,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[269],"tags":[],"class_list":["post-8958","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-owning-or-running-erp"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>High Level Customization - Get it Right!<\/title>\n<meta name=\"description\" content=\"How to plan and leverage the best technological approach for your high-level customizations\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"High Level Customization - Get it Right!\" \/>\n<meta property=\"og:description\" content=\"How to plan and leverage the best technological approach for your high-level customizations\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/\" \/>\n<meta property=\"og:site_name\" content=\"SYSPRO Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-11-04T10:46:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-02T09:44:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2020\/12\/chris_g_customization.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"410\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Chris Grunwell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chris Grunwell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/\"},\"author\":{\"name\":\"Chris Grunwell\",\"@id\":\"https:\/\/sg.syspro.com\/blog\/#\/schema\/person\/0d36f3ef40ed6fa763691a823554ea35\"},\"headline\":\"High Level Customization &#8211; Get it Right!\",\"datePublished\":\"2014-11-04T10:46:42+00:00\",\"dateModified\":\"2025-04-02T09:44:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/\"},\"wordCount\":660,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sg.syspro.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2020\/12\/chris_g_customization.png\",\"articleSection\":[\"Managing-Operating ERP\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/\",\"url\":\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/\",\"name\":\"High Level Customization - Get it Right!\",\"isPartOf\":{\"@id\":\"https:\/\/sg.syspro.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2020\/12\/chris_g_customization.png\",\"datePublished\":\"2014-11-04T10:46:42+00:00\",\"dateModified\":\"2025-04-02T09:44:15+00:00\",\"description\":\"How to plan and leverage the best technological approach for your high-level customizations\",\"breadcrumb\":{\"@id\":\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#primaryimage\",\"url\":\"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2020\/12\/chris_g_customization.png\",\"contentUrl\":\"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2020\/12\/chris_g_customization.png\",\"width\":900,\"height\":410,\"caption\":\"chris_g_customization\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sg.syspro.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"High Level Customization &#8211; Get it Right!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sg.syspro.com\/blog\/#website\",\"url\":\"https:\/\/sg.syspro.com\/blog\/\",\"name\":\"SYSPRO Blog\",\"description\":\"Insights on Business Management Software and ERP\",\"publisher\":{\"@id\":\"https:\/\/sg.syspro.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sg.syspro.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sg.syspro.com\/blog\/#organization\",\"name\":\"SYSPRO\",\"url\":\"https:\/\/sg.syspro.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sg.syspro.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/cropped-syspro-blog-logo.png\",\"contentUrl\":\"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/cropped-syspro-blog-logo.png\",\"width\":260,\"height\":94,\"caption\":\"SYSPRO\"},\"image\":{\"@id\":\"https:\/\/sg.syspro.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/sg.syspro.com\/blog\/#\/schema\/person\/0d36f3ef40ed6fa763691a823554ea35\",\"name\":\"Chris Grunwell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/58b57d60fab74cdb4c53c0fbcf180c81-150x150.jpg\",\"url\":\"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/58b57d60fab74cdb4c53c0fbcf180c81-150x150.jpg\",\"contentUrl\":\"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/58b57d60fab74cdb4c53c0fbcf180c81-150x150.jpg\",\"caption\":\"Chris Grunwell\"},\"description\":\"Chris Grunwell is a Specialist Services Consultant at K3 SYSPRO, and joined the company in 2012. Chris thrives on being a technical \u2018doctor\u2019, diagnosing, testing and fixing all things technical. During his career Chris has been involved in IT Management, IT Support, Software Development, IT Sales and Web Development. Before joining K3 SYSPRO he worked at Steel Software Solutions as their Commercial Manager, where he was responsible for managing both the support and development team, sales and marketing of the flagship ERP product, sales, budgeting, and HR. In his current role at K3 SYSPRO he constantly pushes himself to help customers, test products, write user guides (and whatever else gets thrown at him). Chris obtained a BSc degree in Information &amp; Communication Management from Northumbria University in 2005, and also holds a Foundation PRINCE2 qualification.\",\"sameAs\":[\"http:\/\/www.syspro.com\"],\"url\":\"https:\/\/sg.syspro.com\/blog\/author\/chris\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"High Level Customization - Get it Right!","description":"How to plan and leverage the best technological approach for your high-level customizations","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:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/","og_locale":"en_US","og_type":"article","og_title":"High Level Customization - Get it Right!","og_description":"How to plan and leverage the best technological approach for your high-level customizations","og_url":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/","og_site_name":"SYSPRO Blog","article_published_time":"2014-11-04T10:46:42+00:00","article_modified_time":"2025-04-02T09:44:15+00:00","og_image":[{"width":900,"height":410,"url":"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2020\/12\/chris_g_customization.png","type":"image\/png"}],"author":"Chris Grunwell","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chris Grunwell","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#article","isPartOf":{"@id":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/"},"author":{"name":"Chris Grunwell","@id":"https:\/\/sg.syspro.com\/blog\/#\/schema\/person\/0d36f3ef40ed6fa763691a823554ea35"},"headline":"High Level Customization &#8211; Get it Right!","datePublished":"2014-11-04T10:46:42+00:00","dateModified":"2025-04-02T09:44:15+00:00","mainEntityOfPage":{"@id":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/"},"wordCount":660,"commentCount":0,"publisher":{"@id":"https:\/\/sg.syspro.com\/blog\/#organization"},"image":{"@id":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#primaryimage"},"thumbnailUrl":"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2020\/12\/chris_g_customization.png","articleSection":["Managing-Operating ERP"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/","url":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/","name":"High Level Customization - Get it Right!","isPartOf":{"@id":"https:\/\/sg.syspro.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#primaryimage"},"image":{"@id":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#primaryimage"},"thumbnailUrl":"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2020\/12\/chris_g_customization.png","datePublished":"2014-11-04T10:46:42+00:00","dateModified":"2025-04-02T09:44:15+00:00","description":"How to plan and leverage the best technological approach for your high-level customizations","breadcrumb":{"@id":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#primaryimage","url":"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2020\/12\/chris_g_customization.png","contentUrl":"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2020\/12\/chris_g_customization.png","width":900,"height":410,"caption":"chris_g_customization"},{"@type":"BreadcrumbList","@id":"https:\/\/sg.syspro.com\/blog\/owning-or-running-erp\/high-level-customization-get-it-right\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sg.syspro.com\/blog\/"},{"@type":"ListItem","position":2,"name":"High Level Customization &#8211; Get it Right!"}]},{"@type":"WebSite","@id":"https:\/\/sg.syspro.com\/blog\/#website","url":"https:\/\/sg.syspro.com\/blog\/","name":"SYSPRO Blog","description":"Insights on Business Management Software and ERP","publisher":{"@id":"https:\/\/sg.syspro.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sg.syspro.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/sg.syspro.com\/blog\/#organization","name":"SYSPRO","url":"https:\/\/sg.syspro.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sg.syspro.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/cropped-syspro-blog-logo.png","contentUrl":"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/cropped-syspro-blog-logo.png","width":260,"height":94,"caption":"SYSPRO"},"image":{"@id":"https:\/\/sg.syspro.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sg.syspro.com\/blog\/#\/schema\/person\/0d36f3ef40ed6fa763691a823554ea35","name":"Chris Grunwell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/58b57d60fab74cdb4c53c0fbcf180c81-150x150.jpg","url":"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/58b57d60fab74cdb4c53c0fbcf180c81-150x150.jpg","contentUrl":"https:\/\/sg.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/58b57d60fab74cdb4c53c0fbcf180c81-150x150.jpg","caption":"Chris Grunwell"},"description":"Chris Grunwell is a Specialist Services Consultant at K3 SYSPRO, and joined the company in 2012. Chris thrives on being a technical \u2018doctor\u2019, diagnosing, testing and fixing all things technical. During his career Chris has been involved in IT Management, IT Support, Software Development, IT Sales and Web Development. Before joining K3 SYSPRO he worked at Steel Software Solutions as their Commercial Manager, where he was responsible for managing both the support and development team, sales and marketing of the flagship ERP product, sales, budgeting, and HR. In his current role at K3 SYSPRO he constantly pushes himself to help customers, test products, write user guides (and whatever else gets thrown at him). Chris obtained a BSc degree in Information &amp; Communication Management from Northumbria University in 2005, and also holds a Foundation PRINCE2 qualification.","sameAs":["http:\/\/www.syspro.com"],"url":"https:\/\/sg.syspro.com\/blog\/author\/chris\/"}]}},"metadata":{"_yoast_wpseo_focuskw":["High Level Customization - Get it Right!"],"_yoast_wpseo_focuskw_text_input":["High Level Customization - Get it Right!"],"_yoast_wpseo_title":["High Level Customization - Get it Right!"],"_yoast_wpseo_metadesc":["How to plan and leverage the best technological approach for your high-level customizations"],"_yoast_wpseo_content_score":["30"],"_yoast_wpseo_primary_category":[""],"_yoast_wpseo_linkdex":["63"],"_yoast_wpseo_metakeywords":["customization, sql triggers, microsoft sql server"],"_wp_page_template":["default"],"_thumbnail_id":["6237"],"_edit_lock":["1743586947:226"],"_edit_last":["226"],"_webdados_fb_open_graph_specific_image":[""],"_webdados_fb_open_graph_specific_title":[""],"ao_post_optimize":["a:6:{s:16:\"ao_post_optimize\";s:2:\"on\";s:19:\"ao_post_js_optimize\";s:2:\"on\";s:20:\"ao_post_css_optimize\";s:2:\"on\";s:12:\"ao_post_ccss\";s:2:\"on\";s:16:\"ao_post_lazyload\";s:2:\"on\";s:15:\"ao_post_preload\";s:0:\"\";}"],"_yoast_wpseo_estimated-reading-time-minutes":[""],"_elementor_page_assets":["a:0:{}"]},"_links":{"self":[{"href":"https:\/\/sg.syspro.com\/blog\/wp-json\/wp\/v2\/posts\/8958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sg.syspro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sg.syspro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sg.syspro.com\/blog\/wp-json\/wp\/v2\/users\/144"}],"replies":[{"embeddable":true,"href":"https:\/\/sg.syspro.com\/blog\/wp-json\/wp\/v2\/comments?post=8958"}],"version-history":[{"count":1,"href":"https:\/\/sg.syspro.com\/blog\/wp-json\/wp\/v2\/posts\/8958\/revisions"}],"predecessor-version":[{"id":10876,"href":"https:\/\/sg.syspro.com\/blog\/wp-json\/wp\/v2\/posts\/8958\/revisions\/10876"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sg.syspro.com\/blog\/wp-json\/wp\/v2\/media\/6237"}],"wp:attachment":[{"href":"https:\/\/sg.syspro.com\/blog\/wp-json\/wp\/v2\/media?parent=8958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sg.syspro.com\/blog\/wp-json\/wp\/v2\/categories?post=8958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sg.syspro.com\/blog\/wp-json\/wp\/v2\/tags?post=8958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}