{"id":270,"date":"2015-01-30T19:44:11","date_gmt":"2015-01-31T02:44:11","guid":{"rendered":"http:\/\/s1095387061.online-home.ca\/?p=270"},"modified":"2018-05-25T14:23:48","modified_gmt":"2018-05-25T20:23:49","slug":"mssql-tips-tip-17","status":"publish","type":"post","link":"https:\/\/databaserefresh.com\/blog\/mssql-tips-tip-17\/","title":{"rendered":"MSSQL Tips: Tip #17 \u2013 Using Policy Based Management to check that SQL Server indexes are created in the correct filegroup"},"content":{"rendered":"<p>Another tip about using Policy Based Management for the SQL Server checks.<\/p>\n<p>Please read the latest MSSQL Tip:  &#8220;<a title=\"Using Policy Based Management to check that SQL Server indexes are created in the correct filegroup\" href=\"http:\/\/www.mssqltips.com\/sqlservertip\/3478\/using-policy-based-management-to-check-that-sql-server-indexes-are-created-in-the-correct-filegroup\/\" target=\"_blank\">Using Policy Based Management to check that SQL Server indexes are created in the correct filegroup<\/a>&#8220;.<\/p>\n<p>Check out all of my tips here: <a title=\"http:\/\/www.mssqltips.com\/sqlserverauthor\/94\/svetlana-golovko\/\" href=\"http:\/\/www.mssqltips.com\/sqlserverauthor\/94\/svetlana-golovko\/\" target=\"_blank\">http:\/\/www.mssqltips.com\/sqlserverauthor\/94\/svetlana-golovko\/<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Another tip about using Policy Based Management for the SQL Server checks. Please read the latest MSSQL Tip: &#8220;Using Policy Based Management to check that SQL Server indexes are created in the correct filegroup&#8220;. Check out all of my tips &hellip; <a href=\"https:\/\/databaserefresh.com\/blog\/mssql-tips-tip-17\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[12,7,3,30],"tags":[66,67,62,32,47,48,39],"class_list":["post-270","post","type-post","status-publish","format-standard","hentry","category-dba_checks","category-sql_maint","category-sql_server","category-tips-sql_server","tag-filegroups","tag-indexes","tag-monitoring-2","tag-mssql-tips","tag-pbm","tag-policies","tag-policy-based-management"],"_links":{"self":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/comments?post=270"}],"version-history":[{"count":2,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/270\/revisions"}],"predecessor-version":[{"id":272,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/posts\/270\/revisions\/272"}],"wp:attachment":[{"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/media?parent=270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/categories?post=270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/databaserefresh.com\/blog\/wp-json\/wp\/v2\/tags?post=270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}