{"id":2868,"date":"2012-11-19T14:18:00","date_gmt":"2012-11-19T13:18:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/"},"modified":"2012-11-19T14:18:00","modified_gmt":"2012-11-19T13:18:00","slug":"risk-and-health-assessment-program-for-microsoft-sql-server","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/","title":{"rendered":"Risk and Health Assessment Program for Microsoft SQL Server"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_RAP-logo.jpg\" alt=\"\" \/><\/p>\n<p>I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The\u00a0SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation\u00a0of your client environment by a Microsoft SQL Server Engineer. The SQLRAP program will collect data from the SQL Servers, perform a very thorough analysis, and generate reports as well as recommendations. After that, you will be able to talk to the Engineer about the findings. Let&#8217;s see now in more details how it works.<\/p>\n<h3>Scoping tool<\/h3>\n<p>To start our\u00a0Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) we first have to download and run the scoping tool.<br \/>\nThe scoping tool will verify connectivity requirements, permissions requirements, and other prerequisites for the successful execution of the SQLRAP toolset. Before running the scoping tool, Microsoft .NET Framework 4.0 and Microsoft Baseline Security Analyzer 2.1.1 have to be installed.<\/p>\n<p>The scoping tool runs without making any changes to our environment, it simply uses standard operations such as WMI queries, LDAP queries, port queries and so on. It is completely read-only. It has minimal network impact and also doesn\u2019t overload the target system. It may take it several minutes or even hours to complete depending upon the size of the environment.<\/p>\n<p>The scoping must be run from a computer that has full network connectivity for all SQL Servers targeted. This should be the same computer that will be used during the SQLRAP engagement. It must be run using an account that has Enterprise Admin privileges and local administrative access on every SQL Server targeted. Ideally, it should be a dedicated account that will also be used during the SQLRAP engagement. The account does not need to remain after the engagement is complete.<\/p>\n<p>The scoping tool runs through below areas to collect data and create report:<\/p>\n<ul>\n<li><strong>Correct .NET Libraries Installed<\/strong><br \/>\n.NET Framework version 4.0 (Full) must be installed to ensure Tools are able to perform properly.<\/li>\n<li><strong>Operating System Memory<\/strong><br \/>\nChecks to determine if the minimum recommended amount of memory (2GB) is installed on the Tool Server. Having less memory may result in the number of test cases fail with &#8220;Out of Memory&#8221; errors.<\/li>\n<li><strong>Operating System Processor<\/strong><br \/>\nChecks to determine if the minimum processor speed is available in the Tool Server.<\/li>\n<li><strong>Latest Version of Windows Update Agent Installed<\/strong><br \/>\nWindows Update Agent (WUA) framework must be installed on the target servers in order the MBSA test case could scan the target servers for missing updates.<\/li>\n<li><strong>Wmi Check (Win32_ComputerSystem)<\/strong><br \/>\nValidates the specified WMI class is available on each target system.\u00a0 Most of the data collection methods used during a RAP rely heavily upon WMI.\u00a0 If WMI is unavailable either because of lack of connectivity or permissions it is effectively as if the target system is completely unreachable from a data collection and analysis perspective.<\/li>\n<li><strong>Port 135 (End Point Mapper)<\/strong><br \/>\nValidates connectivity over TCP port 135 (End Point Mapper).\u00a0 This port is used during RPC communication to determine the listening port of an RPC service.<\/li>\n<li><strong>Ping<\/strong><br \/>\nPerforms an ICMP ping against the NetBIOS name of each target system.\u00a0 Certain tests during a RAP leverage ICMP pings to determine if a target system is available.<\/li>\n<li><strong>Remote Registry<\/strong><br \/>\nValidates remote Registry access is available by connecting to the HKEY_LOCAL_MACHINE Registry hive of each target system.<\/li>\n<li><strong>Admin Shares<\/strong><br \/>\nPerforms a WMI query against the Win32_Shares class to enumerate the default administrative shares on each target system to validate they exist.\u00a0 This test only validates the shares exist, it does not attempt to connect to them.<\/li>\n<li><strong>Query Logman<\/strong><br \/>\nLogman.exe is used during the Risk Assessment to collect performance counters from the tools machine.\u00a0 This check ensures Logman.exe works against remote machines by running &#8216;logman.exe \/query \/s [machine]&#8217;.<\/li>\n<li><strong>Windows Update Service Running<\/strong><br \/>\nValidates the Automatic Updates\/Windows Updates service is running on each target system.\u00a0 This service is required in order to evaluate the target systems for missing security updates. If this service is disabled intentionally for security reasons as of now, consider enabling the service for brief time during the SQLRAP engagement.<\/li>\n<li><strong>MBSA Installed<\/strong><br \/>\nMicrosoft Baseline Security Assessment (MBSA) is used during the Risk Assessment to determine missing hotfixes. This check verifies that MBSA is installed on the local machine.<\/li>\n<li><strong>DCOM Installed<\/strong><br \/>\nValidates Distributed COM (DCOM) is enabled on each target system.\u00a0 Most of the data collection methods used during the risk assessment require DCOM be enabled.<\/li>\n<li><strong>Tools Machine &#8211; OS Version<\/strong><br \/>\nDetermines the operating system version of the computer the scoping tool is run on. The tools machine must run Windows Server 2003 with Service Pack 2 or higher. Older server operating systems or workstation operating systems are not supported as the tools machine.<\/li>\n<li><strong>Tools Machine &#8211; OS Language<\/strong><br \/>\nDetermines if the installed operating system language is English on the computer running the tool.\u00a0 Currently, the tools machine must run an English language Windows operating system. Target systems may be non-English OS.<\/li>\n<li><strong>Tools Machine &#8211; OS Locale<\/strong><br \/>\nDetermines if the installed operating system locale is English (United States) on the computer running the tool.\u00a0 Currently, the tools machine must have its locale set as English (United States). Target systems may have non-English (United States) locale.<\/li>\n<li><strong>Port 139 (NetBIOS) and 445 (SMB)<\/strong><br \/>\nValidates connectivity over TCP port 139 (NetBIOS) and 445 (SMB).\u00a0 TCP port 139 is used during NetBIOS communications.\u00a0 TCP port 445 is used when remotely accessing the File and Printer Sharing (Server) service components.\u00a0 This check verifies access to at least one of these ports is available.<\/li>\n<li><strong>SysAdmin on Databases<\/strong><br \/>\nChecks to verify that the current user is a sysadmin on the content database instances.\u00a0 This is required in order to run the SQL BPA and a number of other test cases.<\/li>\n<li><strong>OS Supportability Check<\/strong><br \/>\nDetermines if the target operating system supported or not. A RAP cannot be conducted against environments running unsupported products.<\/li>\n<li><strong>OS and SP RAP Supportability Check<\/strong><br \/>\nDetermines if the target operating system and service pack have been tested for compatibility with the RAP. A RAP can be conducted against untested environments, however the RAP content is not validated or ensured to be functional.\u00a0 The delivery should proceed at the risk of the customer.<\/li>\n<\/ul>\n<p>The result for our future RAP dedicated server is:<\/p>\n<p><a><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-7.jpg\" alt=\"\" \/><\/a><\/p>\n<p>We have an error for Tools Machine \u2013 OS Locale here, so we can click the next button to see what it means and correct it. But it\u2019s a good starting point to have just one error!<\/p>\n<p><a class=\"easyblog-thumb-preview title=RAP-8.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/RAP-8.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-8.jpg\" alt=\"\" \/><\/a><\/p>\n<p>The local default language is set to Swiss French, code 100c, and it should be set to English (United States), code 0409, for the SQLRAP.<br \/>\nSo, we have to change it to fullfill the requirement and rerun the scoping to have 0 failed and 0 warnings.<\/p>\n<p>When all errors are resolved we have to generate a report for the scoring and mail it to our Technical Account Manager (TAM) for validation of our environment.<\/p>\n<p><a class=\"easyblog-thumb-preview title=RAP-11.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/RAP-11.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-11.jpg\" alt=\"\" \/><\/a><\/p>\n<p>The first step of the SQLRAP, the scoring, is done.<\/p>\n<h3>RAP as a Service for SQL Server<\/h3>\n<p>RAP as a Service for Microsoft SQL Server is a proactive service delivered by a Microsoft accredited engineer to diagnose potential issues with your Microsoft SQL Server environment. This service is available for Microsoft SQL Server with up to five instances running SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012.<\/p>\n<p>It will focus on the following aspects of your SQL Server environment:<\/p>\n<ul>\n<li>SQL Configurations<\/li>\n<li>SQL Database Design and Options<\/li>\n<li>SQL Security<\/li>\n<li>SQL Performance<\/li>\n<li>SQL Operations and Maintenance<\/li>\n<li>SQL Error Log Analysis<\/li>\n<li>SQL Instance Properties<\/li>\n<li>SQL Server 2012 AlwaysOn Health<\/li>\n<li>Cluster Resources<\/li>\n<li>Operational Excellence<\/li>\n<\/ul>\n<p>Now that we have scoped our environment and installed the prerequisites tools, we can download, install and run the \u201cRAP as a Service for SQL Server\u201d from our Dashboard. Access to this page should be granted by your TAM.<\/p>\n<p>SQLRAP dashboard:<\/p>\n<p><a class=\"easyblog-thumb-preview title=RAP-13.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/RAP-13.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-13.jpg\" alt=\"\" \/><\/a><\/p>\n<p>After having installed the tool \u201cRAP as a Service for SQL Server\u201d, you can run it and access the frontend which will give you the possibility to assess up to five instances of SQL Server, collect data, and submit this data for analysis. The data is collected remotely and allows you to run the assessment on your own schedule.<\/p>\n<p>On the first screen, click Next:<\/p>\n<p><a><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-1.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Choose the assessment file which was created during the installation process:<\/p>\n<p><a class=\"easyblog-thumb-preview title=RAP-2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/RAP-2.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-2.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Click Next and confirm your assessment in the following screen to have the possibility to determine what to assess:<\/p>\n<p><a class=\"easyblog-thumb-preview title=RAP-5.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/RAP-5.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-5.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Enter an SQL server name and click \u201cDiscover my environment&#8221;:<\/p>\n<p><a class=\"easyblog-thumb-preview title=RAP-15.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/RAP-15.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-15.jpg\" alt=\"\" \/><\/a><\/p>\n<p>The tool will check your environment configuration. When it\u2019s done, you can click the Next button to start collecting data from your environment:<\/p>\n<p><a class=\"easyblog-thumb-preview title=RAP-6.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/RAP-6.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-6.jpg\" alt=\"\" \/><\/a><\/p>\n<p>When the \u201ccollect data\u201d is done, the Next button will be available and you have the possibility to submit your data after having entered your submission access key, which is available on your dashboard:<\/p>\n<p><a class=\"easyblog-thumb-preview title=RAP-9.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/RAP-9.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-9.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Data will go through the cloud via a secured transmission and we are able to view the result immediately on the dedicated dashboard.<\/p>\n<p>View Collected data:<\/p>\n<p><a class=\"easyblog-thumb-preview title=RAP-14.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/RAP-14.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-14.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Or have a look at View Issues:<\/p>\n<p><a class=\"easyblog-thumb-preview title=RAP-16.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/RAP-16.jpg\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_RAP-16.jpg\" alt=\"\" \/><\/a><\/p>\n<p>For each issue you have a description, all affected objects, recommended reading, and how to troubleshoot.<\/p>\n<h3>Benefits<\/h3>\n<p>Now that our environment has been analyzed, a Microsoft accredited engineer will come to you to review the findings, provide recommendations on each issue, show you the configuration best practices, as well as for knowledge transfer, and to build a remediation plan with you.<br \/>\nHe will also go over the SQL Server Profiler, the performance monitor, and some others tool. He will also make sure that you know how to use it to perform a self-analysis.<\/p>\n<p>The result from your SQLRAP will remain available on your online portal for one year. You have the possibility to reassess your environment during one year to see if changes are beneficial or assess other instances (different from the first five ones).<\/p>\n<p>Keys benefits:<\/p>\n<ul>\n<li>Result on an online portal<\/li>\n<li>Reassessment possible for one year, if wanted<\/li>\n<li>Access to best practice updates for one year<\/li>\n<li>Assessment of others SQL Server possible<\/li>\n<li>Reports online for issue findings<\/li>\n<li>Knowledge transfer<\/li>\n<\/ul>\n<h3>Conclusion<\/h3>\n<p>This experience was really meaningful and even if you are familiar with SQL Server\u00a0best practices, you will probably discover new ones.<br \/>\nIt is always good to refresh its know-how and have the possibility to discuss with an SQL Server Microsoft accredited engineer.<br \/>\nSQLRAP provides up-to-date recommendations and allows you to keep a healthy environment and be more proactive during the configuration of a new server. I will continue to assess my environments during the next year with this tool and see if there are new features or best practice updates.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The\u00a0SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation\u00a0of your client environment by [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":2869,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[49,359,51,54,360],"type_dbi":[],"class_list":["post-2868","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-microsoft","tag-scoring","tag-sql-server","tag-sql-server-2012","tag-sqlrap"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Risk and Health Assessment Program for Microsoft SQL Server - dbi Blog<\/title>\n<meta name=\"description\" content=\"I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation of your client environment by a Microsoft SQL Server Engineer.\" \/>\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.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Risk and Health Assessment Program for Microsoft SQL Server\" \/>\n<meta property=\"og:description\" content=\"I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation of your client environment by a Microsoft SQL Server Engineer.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-19T13:18:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_RAP-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"358\" \/>\n\t<meta property=\"og:image:height\" content=\"104\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Savorgnano\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Savorgnano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"Risk and Health Assessment Program for Microsoft SQL Server\",\"datePublished\":\"2012-11-19T13:18:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/\"},\"wordCount\":1773,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_RAP-logo.jpg\",\"keywords\":[\"Microsoft\",\"Scoring\",\"SQL Server\",\"SQL Server 2012\",\"SQLRAP\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/\",\"name\":\"Risk and Health Assessment Program for Microsoft SQL Server - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_RAP-logo.jpg\",\"datePublished\":\"2012-11-19T13:18:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"description\":\"I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation of your client environment by a Microsoft SQL Server Engineer.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_RAP-logo.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_RAP-logo.jpg\",\"width\":358,\"height\":104},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Risk and Health Assessment Program for Microsoft SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Risk and Health Assessment Program for Microsoft SQL Server - dbi Blog","description":"I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation of your client environment by a Microsoft SQL Server Engineer.","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.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Risk and Health Assessment Program for Microsoft SQL Server","og_description":"I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation of your client environment by a Microsoft SQL Server Engineer.","og_url":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/","og_site_name":"dbi Blog","article_published_time":"2012-11-19T13:18:00+00:00","og_image":[{"width":358,"height":104,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_RAP-logo.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"Risk and Health Assessment Program for Microsoft SQL Server","datePublished":"2012-11-19T13:18:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/"},"wordCount":1773,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_RAP-logo.jpg","keywords":["Microsoft","Scoring","SQL Server","SQL Server 2012","SQLRAP"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/","url":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/","name":"Risk and Health Assessment Program for Microsoft SQL Server - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_RAP-logo.jpg","datePublished":"2012-11-19T13:18:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"description":"I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation of your client environment by a Microsoft SQL Server Engineer.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_RAP-logo.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_RAP-logo.jpg","width":358,"height":104},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/risk-and-health-assessment-program-for-microsoft-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Risk and Health Assessment Program for Microsoft SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2868","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2868"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2868\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2869"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2868"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}