{"id":8983,"date":"2015-02-17T10:32:20","date_gmt":"2015-02-17T10:32:20","guid":{"rendered":"https:\/\/ca.syspro.com\/blog\/sql-the-perfect-database-partner\/"},"modified":"2021-03-04T14:48:05","modified_gmt":"2021-03-04T14:48:05","slug":"sql-the-perfect-database-partner","status":"publish","type":"post","link":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/","title":{"rendered":"SQL \u2013 The perfect database partner"},"content":{"rendered":"<p>I love the database programming language <a href=\"http:\/\/en.wikipedia.org\/wiki\/SQL\">SQL<\/a>, and I don&#8217;t mind admitting it. \u00a0Ever since I first started to write T-SQL statements in Microsoft Query 2001 for my ICT A-Level exams I&#8217;ve loved the syntax, the structure of the language itself (hence <strong>S<\/strong>tructured <strong>Q<\/strong>uery <strong>L<\/strong>anguage) and its similarity to the English language.<!--more--><\/p>\n<p>I was thrilled therefore when I attended a week-long SQL 2014 training course in December to fill any previous gaps in my knowledge of the Microsoft SQL environment.\u00a0 I filled in so many little gaps, that I have since begun running half-day knowledge sharing sessions at K3 Syspro to share the little tit-bits that I picked up so that our consultants, technical and support teams are aware of the tools available to them to help do their job and pass on their knowledge of these tools to customers and on-site SYSPRO Administrators. SQL issues are often raised by customers through our Helpdesk, dealing with the use of SQL views (to display Custom Form Fields on SRS Stationary), Excel spreadsheets using the ODBC connection to the SYSPRO database, or simply struggles with general SQL performance or permissions when using SYSPRO.<\/p>\n<p>I&#8217;ve outlined some of the most useful tools below:<\/p>\n<ul>\n<li>SQL Traces &amp; SQL Profiler &#8211; I&#8217;d been running SQL traces for years but didn&#8217;t actually realise that the SQL Profiler and SQL Trace technologies are actually completely de-coupled in all versions of SQL Server since traces were first introduced in SQL Server 2005.\u00a0 Put simply, the SQL Trace is the collection of data about transactions that have gone through your SQL Server; SQL Profiler is the GUI tool that helps us read this data in a friendly manner.\u00a0 This means that customers that do not have SQL Profiler installed can still <a href=\"http:\/\/www.toadworld.com\/platforms\/sql-server\/w\/wiki\/9827.running-traces-with-tsql.aspx\">capture a trace using T-SQL code<\/a>.<\/li>\n<\/ul>\n<ul>\n<li>SQL Audit &#8211; This is a much more granular way of tracing SQL transactional activity, and one I hadn&#8217;t seen or used before attending the course.\u00a0 SQL Audit is a very powerful way of tracking what happens on your SQL server within a period of time.\u00a0 There&#8217;s a very useful article <a href=\"http:\/\/bradmcgehee.com\/2010\/03\/30\/an-introduction-to-sql-server-2008-audit\/\">here<\/a>.<\/li>\n<\/ul>\n<ul>\n<li>Dynamic Management (DM) Views &#8211; DM Views are automatically created with every database on your SQL Server and provide ready-made SQL views on important parts of your SQL environment.\u00a0 There are over 200 DM Views included in SQL 2014 as Microsoft keep adding to the list with each release (there were only around 80 included with SQL 2005).\u00a0 Some of the most useful I&#8217;ve found up to now are <strong>sys.dm_server_services<\/strong> (displays status of all SQL services running on your SQL Server), <strong>sys.dm_tran_locks<\/strong> (gives us information on current locks and blocks) and <strong>sys.dm_db_index_physical_stats<\/strong> (shows us the state of all indexes in a database and any recommended actions required to improve them).<\/li>\n<\/ul>\n<ul>\n<li>SQL Agent and Alerts &#8211; I\u2019d come across SQL Agent before as we use them to carry out backups and consistency checks to databases in our current environment here at K3 Syspro.\u00a0 What I didn\u2019t realise, was that we could set up alerts based on a particular trigger in the SQL environment and email to specific Operators when such trigger happens.\u00a0 For example, we can set Alerts to inform us when our Transaction Log reaches a particular size, or even on a specific error message number such as 1205 (this is the error message raised when SQL encounters a &#8216;dead-lock&#8217;).<\/li>\n<\/ul>\n<p>It\u2019s important to understand all aspects of a live production system, and in SYSPRO administration terms, that of course includes the underlying SQL database.<\/p>\n<p>As with most systems that we use day-to-day, it&#8217;s impossible to know everything, so if you&#8217;ve found any great features or tips, please share them and I&#8217;ll publish some of these in a later blog!<\/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\"> 3<\/span> <span class=\"rt-label rt-postfix\">minutes<\/span><\/span>I love the database programming language SQL, and I don&#8217;t mind admitting it. \u00a0Ever since I first started to write T-SQL statements in Microsoft Query 2001 for my ICT A-Level exams I&#8217;ve loved the syntax, the structure of the language itself (hence Structured Query Language) and its similarity to the English language.<\/p>\n","protected":false},"author":144,"featured_media":9621,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-8983","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-applying-and-operating-erp"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.1.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL \u2013 The perfect database partner<\/title>\n<meta name=\"description\" content=\"Useful tips for using SQL in a Microsoft database environment\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL \u2013 The perfect database partner\" \/>\n<meta property=\"og:description\" content=\"Useful tips for using SQL in a Microsoft database environment\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/\" \/>\n<meta property=\"og:site_name\" content=\"SYSPRO Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-17T10:32:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-04T14:48:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/chris_g_perfect_database_partner-300x300-1.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:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/\"},\"author\":{\"name\":\"Chris Grunwell\",\"@id\":\"https:\/\/ca.syspro.com\/blog\/#\/schema\/person\/6499f648908e166882c4ea859e09b4d3\"},\"headline\":\"SQL \u2013 The perfect database partner\",\"datePublished\":\"2015-02-17T10:32:20+00:00\",\"dateModified\":\"2021-03-04T14:48:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/\"},\"wordCount\":641,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/ca.syspro.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/chris_g_perfect_database_partner-300x300-1.png\",\"articleSection\":[\"Applying and Operating ERP\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/\",\"url\":\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/\",\"name\":\"SQL \u2013 The perfect database partner\",\"isPartOf\":{\"@id\":\"https:\/\/ca.syspro.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/chris_g_perfect_database_partner-300x300-1.png\",\"datePublished\":\"2015-02-17T10:32:20+00:00\",\"dateModified\":\"2021-03-04T14:48:05+00:00\",\"description\":\"Useful tips for using SQL in a Microsoft database environment\",\"breadcrumb\":{\"@id\":\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#primaryimage\",\"url\":\"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/chris_g_perfect_database_partner-300x300-1.png\",\"contentUrl\":\"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/chris_g_perfect_database_partner-300x300-1.png\",\"width\":900,\"height\":410},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ca.syspro.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL \u2013 The perfect database partner\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ca.syspro.com\/blog\/#website\",\"url\":\"https:\/\/ca.syspro.com\/blog\/\",\"name\":\"SYSPRO Blog\",\"description\":\"Insights on Business Management Software and ERP\",\"publisher\":{\"@id\":\"https:\/\/ca.syspro.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ca.syspro.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ca.syspro.com\/blog\/#organization\",\"name\":\"SYSPRO\",\"url\":\"https:\/\/ca.syspro.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ca.syspro.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/cropped-syspro-blog-logo.png\",\"contentUrl\":\"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/cropped-syspro-blog-logo.png\",\"width\":260,\"height\":94,\"caption\":\"SYSPRO\"},\"image\":{\"@id\":\"https:\/\/ca.syspro.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/ca.syspro.com\/blog\/#\/schema\/person\/6499f648908e166882c4ea859e09b4d3\",\"name\":\"Chris Grunwell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ca.syspro.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/58b57d60fab74cdb4c53c0fbcf180c81-150x150.jpg\",\"contentUrl\":\"https:\/\/ca.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:\/\/ca.syspro.com\/blog\/author\/chris\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL \u2013 The perfect database partner","description":"Useful tips for using SQL in a Microsoft database environment","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:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/","og_locale":"en_US","og_type":"article","og_title":"SQL \u2013 The perfect database partner","og_description":"Useful tips for using SQL in a Microsoft database environment","og_url":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/","og_site_name":"SYSPRO Blog","article_published_time":"2015-02-17T10:32:20+00:00","article_modified_time":"2021-03-04T14:48:05+00:00","og_image":[{"width":900,"height":410,"url":"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/chris_g_perfect_database_partner-300x300-1.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:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#article","isPartOf":{"@id":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/"},"author":{"name":"Chris Grunwell","@id":"https:\/\/ca.syspro.com\/blog\/#\/schema\/person\/6499f648908e166882c4ea859e09b4d3"},"headline":"SQL \u2013 The perfect database partner","datePublished":"2015-02-17T10:32:20+00:00","dateModified":"2021-03-04T14:48:05+00:00","mainEntityOfPage":{"@id":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/"},"wordCount":641,"commentCount":0,"publisher":{"@id":"https:\/\/ca.syspro.com\/blog\/#organization"},"image":{"@id":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#primaryimage"},"thumbnailUrl":"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/chris_g_perfect_database_partner-300x300-1.png","articleSection":["Applying and Operating ERP"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/","url":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/","name":"SQL \u2013 The perfect database partner","isPartOf":{"@id":"https:\/\/ca.syspro.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#primaryimage"},"image":{"@id":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#primaryimage"},"thumbnailUrl":"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/chris_g_perfect_database_partner-300x300-1.png","datePublished":"2015-02-17T10:32:20+00:00","dateModified":"2021-03-04T14:48:05+00:00","description":"Useful tips for using SQL in a Microsoft database environment","breadcrumb":{"@id":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#primaryimage","url":"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/chris_g_perfect_database_partner-300x300-1.png","contentUrl":"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/chris_g_perfect_database_partner-300x300-1.png","width":900,"height":410},{"@type":"BreadcrumbList","@id":"https:\/\/ca.syspro.com\/blog\/applying-and-operating-erp\/sql-the-perfect-database-partner\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ca.syspro.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL \u2013 The perfect database partner"}]},{"@type":"WebSite","@id":"https:\/\/ca.syspro.com\/blog\/#website","url":"https:\/\/ca.syspro.com\/blog\/","name":"SYSPRO Blog","description":"Insights on Business Management Software and ERP","publisher":{"@id":"https:\/\/ca.syspro.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ca.syspro.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ca.syspro.com\/blog\/#organization","name":"SYSPRO","url":"https:\/\/ca.syspro.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ca.syspro.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/cropped-syspro-blog-logo.png","contentUrl":"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/cropped-syspro-blog-logo.png","width":260,"height":94,"caption":"SYSPRO"},"image":{"@id":"https:\/\/ca.syspro.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ca.syspro.com\/blog\/#\/schema\/person\/6499f648908e166882c4ea859e09b4d3","name":"Chris Grunwell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ca.syspro.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/ca.syspro.com\/blog\/wp-content\/uploads\/2021\/03\/58b57d60fab74cdb4c53c0fbcf180c81-150x150.jpg","contentUrl":"https:\/\/ca.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:\/\/ca.syspro.com\/blog\/author\/chris\/"}]}},"metadata":{"_yoast_wpseo_focuskw":["SQL \u2013 The perfect database partner"],"_yoast_wpseo_focuskw_text_input":["SQL \u2013 The perfect database partner"],"_yoast_wpseo_title":["SQL \u2013 The perfect database partner"],"_yoast_wpseo_metadesc":["Useful tips for using SQL in a Microsoft database environment"],"_yoast_wpseo_content_score":["30"],"_yoast_wpseo_primary_category":[""],"_yoast_wpseo_linkdex":["61"],"_yoast_wpseo_metakeywords":["sql database, sql, syspro database"],"_yoast_wpseo_is_cornerstone":[""],"_wp_page_template":["default"],"_thumbnail_id":["9621"],"_elementor_page_assets":["a:0:{}"]},"_links":{"self":[{"href":"https:\/\/ca.syspro.com\/blog\/wp-json\/wp\/v2\/posts\/8983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ca.syspro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ca.syspro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ca.syspro.com\/blog\/wp-json\/wp\/v2\/users\/144"}],"replies":[{"embeddable":true,"href":"https:\/\/ca.syspro.com\/blog\/wp-json\/wp\/v2\/comments?post=8983"}],"version-history":[{"count":0,"href":"https:\/\/ca.syspro.com\/blog\/wp-json\/wp\/v2\/posts\/8983\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ca.syspro.com\/blog\/wp-json\/wp\/v2\/media\/9621"}],"wp:attachment":[{"href":"https:\/\/ca.syspro.com\/blog\/wp-json\/wp\/v2\/media?parent=8983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ca.syspro.com\/blog\/wp-json\/wp\/v2\/categories?post=8983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ca.syspro.com\/blog\/wp-json\/wp\/v2\/tags?post=8983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}