{"id":4020,"date":"2014-08-25T15:24:50","date_gmt":"2014-08-25T13:24:50","guid":{"rendered":"http:\/\/andreas-wolter.com\/datenbank-consulting-services\/"},"modified":"2025-02-20T01:17:35","modified_gmt":"2025-02-20T00:17:35","slug":"database-consulting-services","status":"publish","type":"page","link":"https:\/\/andreas-wolter.com\/en\/database-consulting-services\/","title":{"rendered":"Database Consulting Services"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-we8eac-917e10d58560ac83070f8abd579bcbb2\">\n#top .av-special-heading.av-we8eac-917e10d58560ac83070f8abd579bcbb2{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-we8eac-917e10d58560ac83070f8abd579bcbb2 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-we8eac-917e10d58560ac83070f8abd579bcbb2 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-we8eac-917e10d58560ac83070f8abd579bcbb2 av-special-heading-h1 blockquote modern-quote modern-centered  avia-builder-el-0  el_before_av_hr  avia-builder-el-first '><h1 class='av-special-heading-tag'  itemprop=\"headline\"  >Database Consulting Services<\/h1><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-utg2lw-16dabc2edd4c69ff73ded5b01cee3e6a\">\n#top .hr.hr-invisible.av-utg2lw-16dabc2edd4c69ff73ded5b01cee3e6a{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-utg2lw-16dabc2edd4c69ff73ded5b01cee3e6a hr-invisible  avia-builder-el-1  el_after_av_heading  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<section  class='av_textblock_section av-tmjkr8-9e8b41f9e8bdaa58f3e95b2408185146 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Whether you\u2019re using SQL Server on-premises, in the cloud with Microsoft Azure Virtual Machine\/IaaS, or as a PaaS solution with Azure SQL Database: With more than 20 years of experience in SQL Server and several years working on the Microsoft SQL Server\/Azure SQL product team, I offer the expertise needed to ensure your data is secure and effectively managed.<\/p>\n<p>I offer the following services:<\/p>\n<h2>Data-Security<\/h2>\n<ul>\n<li><strong>Product management<\/strong> for database security\n<ul>\n<li><strong>Access Control<\/strong> (Authentication and Authorization)<\/li>\n<li><strong>Encryption<\/strong><\/li>\n<li><strong>Auditing<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>Secure<\/strong> SQL Server database <strong>architecture<\/strong><\/li>\n<li><a href=\"https:\/\/andreas-wolter.com\/en\/database-consulting-services\/security-check-sql-server-database\/\"><strong>Security assessment<\/strong><\/a><\/li>\n<\/ul>\n<h2>SQL Server Performance and High Availability<\/h2>\n<ul>\n<li><a href=\"https:\/\/andreas-wolter.com\/en\/database-consulting-services\/sql-server-health-configuration-check\/\">Standardized <strong>Health Check<\/strong> for SQL Server<\/a><\/li>\n<li><strong>Migration<\/strong> of SQL Server to the most current release (SQL Server 2022)<\/li>\n<li><strong>Consolidation<\/strong> of SQL Servers to save licenses and hardware<\/li>\n<li>Designing and Implementing <strong>Highly Available SQL Server systems<\/strong>\n<ul>\n<li>Always On Availability Groups<\/li>\n<li>Failover Cluster Instances<\/li>\n<li>Log shipping for Standby<\/li>\n<\/ul>\n<\/li>\n<li><strong>Monitoring<\/strong> solutions<\/li>\n<li><strong>Data rescue<\/strong> in the case of data corruption<\/li>\n<li>Implementing routine server <strong>maintenance<\/strong><\/li>\n<li><a href=\"https:\/\/andreas-wolter.com\/en\/database-consulting-services\/performance-analysis-sql-server\/\"><strong>Performance Analysis<\/strong><\/a><\/li>\n<li><strong>Performance Optimization<\/strong> &#038; Tuning<\/li>\n<li>Architecture &#038; design of\u00a0<strong><strong>large\u00a0<\/strong>scalable data warehouse systems<\/strong><\/li>\n<li>Architecture &#038; design of <strong>high performance OLTP systems<\/strong><\/li>\n<\/ul>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-e379w-783b1c38d7110a2ed4c352ed7f2d9a99 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><h3><\/h3>\n<h3><a href=\"https:\/\/andreas-wolter.com\/en\/contact\/\">Contact me<\/a> for an individual offer or a package for the required number of servers.<\/h3>\n<\/div><\/section>","protected":false},"excerpt":{"rendered":"","protected":false},"author":4,"featured_media":0,"parent":0,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-4020","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages\/4020","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/comments?post=4020"}],"version-history":[{"count":17,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages\/4020\/revisions"}],"predecessor-version":[{"id":6717,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/pages\/4020\/revisions\/6717"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=4020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}