[et_pb_section fb_built=”1″ custom_padding_last_edited=”on|phone” module_class=”top-banner” _builder_version=”4.7.0″ _module_preset=”default” background_color=”#f7f7f7″ use_background_color_gradient=”on” background_color_gradient_start=”rgba(0,0,0,0.4)” background_color_gradient_end=”rgba(0,0,0,0.29)” background_color_gradient_overlays_image=”on” background_image=”https://www.zagtech.com/wp-content/uploads/2020/12/sql-assessment-cover.jpg” background_position=”top_center” custom_padding=”90px||70px||false|false” custom_padding_tablet=”50px||25px||false|false” custom_padding_phone=””][et_pb_row _builder_version=”4.7.0″ _module_preset=”default” custom_margin=”||||false|false” custom_padding=”0px||0px|||”][et_pb_column type=”4_4″ _builder_version=”4.6.6″ _module_preset=”default”][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” header_text_color=”#ffffff” header_font_size=”50px” header_4_line_height=”1.3em” width=”100%” width_tablet=”100%” width_phone=”” width_last_edited=”on|phone” custom_margin=”||8px||false|false” header_font_size_tablet=”35px” header_font_size_phone=”” header_font_size_last_edited=”on|tablet”]

SQL Assessment

[/et_pb_text][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” header_4_font=”Proxima Nova – Regular||||||||” header_4_text_color=”#ffffff” header_4_font_size=”22px” width=”61%” custom_margin=”||||false|false”]

Assess The Health of Your Database

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ custom_padding_last_edited=”on|phone” _builder_version=”4.7.0″ _module_preset=”default” background_image=”https://www.zagtech.com/wp-content/uploads/2020/11/bavkground-gray.jpg” custom_margin=”70px||70px||true|false” custom_margin_tablet=”0px||0px||true|false” custom_margin_phone=”” custom_margin_last_edited=”on|phone” custom_padding=”70px||70px||true|false” custom_padding_tablet=”50px||50px||true|false” custom_padding_phone=”” background_last_edited=”on|desktop” background_enable_image_tablet=”off”][et_pb_row column_structure=”1_2,1_2″ make_equal=”on” custom_padding_last_edited=”off|desktop” module_class=”reverse” _builder_version=”4.7.0″ _module_preset=”default” custom_padding=”1px||1px||true|false” custom_padding_tablet=”||20px||false|false” custom_padding_phone=”50px||20px||false|false”][et_pb_column type=”1_2″ _builder_version=”4.7.0″ _module_preset=”default”][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” quote_font_size=”18px” header_2_font_size=”36px” width=”98%” width_tablet=”100%” width_phone=”” width_last_edited=”on|phone”]

SQL Server Review

Many organizations adopt Microsoft SQL Server to manage their database and host their applications. However, companies without a dedicated Database Administrator do not have the resources to ensure their database is running properly and up to date.

ZAG provides a health check, where we will make recommendations on how to ensure your SQL Server meets your business needs. ZAG suggests this service to any organization that has not reviewed their SQL server in a year or more (not including SQL Express).

Some companies may also be running older versions such as SQL 2005 that are End of Life. Running SQL Server End of Support and Extended Support will result in the loss of security updates, compatibility errors with newer servers and application platforms, and may require purchasing expensive hotfix support.

[/et_pb_text][/et_pb_column][et_pb_column type=”1_2″ disabled_on=”on|on|off” _builder_version=”4.7.0″ _module_preset=”default” background_image=”https://www.zagtech.com/wp-content/uploads/2020/12/sql-image-1.jpg” box_shadow_style=”preset2″ box_shadow_spread=”-7px”][et_pb_divider show_divider=”off” _builder_version=”4.7.0″ _module_preset=”default” custom_padding_tablet=”150px||150px||true|false” custom_padding_phone=”” custom_padding_last_edited=”on|phone”][/et_pb_divider][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ custom_padding_last_edited=”on|phone” _builder_version=”4.7.0″ _module_preset=”default” background_color=”#f7f7f7″ custom_margin=”||||false|false” custom_padding=”70px||130px||false|” custom_padding_tablet=”50px||50px||true|false” custom_padding_phone=””][et_pb_row custom_padding_last_edited=”on|tablet” _builder_version=”4.7.0″ _module_preset=”default” custom_padding=”0px||20px||false|false” custom_padding_tablet=”” custom_padding_phone=””][et_pb_column type=”4_4″ _builder_version=”4.7.0″ _module_preset=”default”][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” quote_font_size=”18px” header_font=”Proxima Nova – Regular|600||on|||||” header_text_align=”left” header_2_text_align=”center” header_2_font_size=”36px” width=”96%” width_tablet=”100%” width_phone=”” width_last_edited=”on|phone” custom_margin=”||||false|false” header_text_align_tablet=”” header_text_align_phone=”center” header_text_align_last_edited=”on|phone” header_2_text_align_tablet=”left” header_2_text_align_phone=”” header_2_text_align_last_edited=”on|phone” icon_placement_phone=”top” icon_placement_last_edited=”on|phone” image_max_width_phone=”105px” image_max_width_last_edited=”on|phone”]

Get Actionable Outcomes

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.7.0″ _module_preset=”default” custom_margin=”|auto||auto|false|false” custom_padding=”0px||0px|||”][et_pb_column type=”1_2″ _builder_version=”4.7.0″ _module_preset=”default”][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” ul_line_height=”2em” quote_font_size=”18px” width=”100%” width_tablet=”100%” width_phone=”” width_last_edited=”on|phone” custom_margin=”||0px||false|false” custom_padding=”||||false|false”]

SQL Health Check Includes:

[/et_pb_text][et_pb_accordion open_toggle_background_color=”#ffffff” closed_toggle_background_color=”#f7f7f7″ icon_color=”#1dc690″ _builder_version=”4.7.0″ _module_preset=”default” toggle_text_color=”#145da1″ toggle_font=”Proxima Nova – Regular|600||on|||||” toggle_line_height=”1.3em” body_font=”Neue Haas Unica||||||||” body_text_color=”#333333″ body_ul_item_indent=”30px”][et_pb_accordion_item title=”SQL Server Backup Review” open=”on” _builder_version=”4.7.0″ _module_preset=”default” body_ul_line_height=”2em”]

Backups, index maintenance, database integrity checks
Recovery model and RTO/RPO objectives
Backup methodology and storage review

[/et_pb_accordion_item][et_pb_accordion_item title=”ASSESS DATABASE CONFIGURATION” _builder_version=”4.7.0″ _module_preset=”default” body_ul_line_height=”2em” open=”off”]

SQL best practices review
Log and trace files review
Check MDOP and Cost Threshold for Parallelism values
Disk layout/file placements for database files and log files

[/et_pb_accordion_item][et_pb_accordion_item title=”SQL SERVER REVIEW AND ASSESSMENT” _builder_version=”4.7.0″ _module_preset=”default” body_ul_line_height=”2em” open=”off”]

A review and analysis of database configuration
Security, stability and availability

[/et_pb_accordion_item][et_pb_accordion_item title=”CHECK VERSIONING AND SPECS” _builder_version=”4.7.0″ _module_preset=”default” body_ul_line_height=”2em” open=”off”]

Service pack levels and version end of life dates for current version of SQL
Database software configuration review

[/et_pb_accordion_item][/et_pb_accordion][et_pb_code _builder_version=”4.7.0″ _module_preset=”default”][/et_pb_code][/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.7.0″ _module_preset=”default”][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” ul_line_height=”2em” quote_font_size=”18px” width=”100%” width_tablet=”100%” width_phone=”” width_last_edited=”on|phone” custom_margin=”||0px||false|false” custom_padding=”||||false|false”]

Assessment may result in:

[/et_pb_text][et_pb_accordion open_toggle_background_color=”#ffffff” closed_toggle_background_color=”#f7f7f7″ icon_color=”#1dc690″ _builder_version=”4.7.0″ _module_preset=”default” toggle_text_color=”#145da1″ toggle_font=”Proxima Nova – Regular|600||on|||||” toggle_line_height=”1.3em” body_font=”Neue Haas Unica||||||||” body_text_color=”#333333″ body_ul_item_indent=”30px”][et_pb_accordion_item title=”REMOTE DBA SERVICE DISASTER RECOVERY PLANNING” open=”on” _builder_version=”4.7.0″ _module_preset=”default” body_ul_line_height=”2em”]

Recommend appropriate methodologies (Log Shipping/Replication/AG/Clustering) as applicable (based on Edition/Version)

[/et_pb_accordion_item][et_pb_accordion_item title=”PERFORMANCE TUNING” _builder_version=”4.7.0″ _module_preset=”default” body_ul_line_height=”2em” open=”off”]

Memory pressure/Disk latency
Performance review for long running/IO intensive queries
Assess indexing strategy (used/unused/duplicate)
Assess Execution plans for query-level performance

[/et_pb_accordion_item][et_pb_accordion_item title=”HARDWARE & SQL SERVER UPGRADES” _builder_version=”4.7.0″ _module_preset=”default” body_ul_line_height=”2em” open=”off”]

Assess current and projected business needs and propose a roadmap

[/et_pb_accordion_item][et_pb_accordion_item title=”GENERAL SQL SERVER CONSULTING” _builder_version=”4.7.0″ _module_preset=”default” body_ul_line_height=”2em” open=”off”]

Assess issues, analyze and recommend solutions based on severity.

[/et_pb_accordion_item][/et_pb_accordion][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ custom_padding_last_edited=”on|tablet” _builder_version=”4.7.0″ _module_preset=”default” background_color=”#ffffff” max_width=”1920px” module_alignment=”center” custom_margin=”||||false|false” custom_margin_tablet=”||||false|false” custom_margin_phone=”” custom_margin_last_edited=”on|phone” custom_padding=”0px||0px||false|false” custom_padding_tablet=”” custom_padding_phone=””][et_pb_row column_structure=”3_5,2_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.7.0″ _module_preset=”default” background_color=”#ffffff” width=”100%” width_tablet=”80%” width_phone=”” width_last_edited=”on|phone” max_width=”none” custom_padding=”0px||0px||false|false” custom_padding_tablet=”70px||50px||false|false” custom_padding_phone=”||50px||false|false”][et_pb_column type=”3_5″ _builder_version=”4.7.0″ _module_preset=”default” custom_padding=”100px||100px||true|false” custom_padding_tablet=”0px||0px||true|false” custom_padding_phone=”0px||0px||false|false” custom_padding_last_edited=”on|phone” custom_css_main_element_last_edited=”on|phone” custom_css_main_element_phone=”padding-top:0px!important;”][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” header_2_font_size=”36px” header_4_line_height=”1.3em” width=”550px” width_tablet=”500px” width_phone=”100%” width_last_edited=”on|phone” module_alignment=”right” custom_margin=”||40px||false|false” module_alignment_tablet=”left” module_alignment_phone=”” module_alignment_last_edited=”on|phone”]

About Databases

[/et_pb_text][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” quote_font_size=”18px” header_4_text_color=”#1dc690″ width=”550px” width_tablet=”500px” width_phone=”100%” width_last_edited=”on|phone” module_alignment=”right” custom_margin=”-42px||25px||false|false” module_alignment_tablet=”left” module_alignment_phone=”” module_alignment_last_edited=”on|phone”]

How to maximize your Return on Investment

[/et_pb_text][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” link_font=”Neue Haas Unica|||on|||||” link_text_color=”#ffffff” header_4_line_height=”1.3em” width=”550px” width_tablet=”500px” width_phone=”100%” width_last_edited=”on|tablet” module_alignment=”right” custom_margin=”||||false|false” custom_margin_tablet=”||||false|false” custom_margin_phone=”||50px||false|false” custom_margin_last_edited=”off|desktop” module_alignment_tablet=”left” module_alignment_phone=”” module_alignment_last_edited=”on|tablet”]Discuss Databases With ZAG[/et_pb_text][/et_pb_column][et_pb_column type=”2_5″ disabled_on=”on|on|off” _builder_version=”4.7.0″ _module_preset=”default”][et_pb_image src=”https://www.zagtech.com/wp-content/uploads/2020/12/database-cta.png” alt=”Careers” title_text=”database-cta” align=”right” _builder_version=”4.7.0″ _module_preset=”default” position_origin_a=”center_left” width=”324px” custom_margin=”-117px||-1px||false|false” custom_padding=”||0px||false|false”][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ custom_padding_last_edited=”on|phone” _builder_version=”4.7.0″ _module_preset=”default” background_color=”#f7f7f7″ background_image=”https://www.zagtech.com/wp-content/uploads/2020/11/background-gray-v2.jpg” custom_padding=”70px||70px||true|” custom_padding_tablet=”50px||50px||true|false” custom_padding_phone=”” background_last_edited=”on|phone” background_enable_image_tablet=”off”][et_pb_row column_structure=”1_2,1_2″ make_equal=”on” custom_padding_last_edited=”on|phone” _builder_version=”4.7.0″ _module_preset=”default” custom_margin_tablet=”” custom_margin_phone=”” custom_margin_last_edited=”on|phone” custom_padding=”0px||0px||false|false” custom_padding_tablet=”0px||||false|false” custom_padding_phone=”0px||||false|false”][et_pb_column type=”1_2″ disabled_on=”on|on|off” _builder_version=”4.7.0″ _module_preset=”default” background_image=”https://www.zagtech.com/wp-content/uploads/2020/12/sql-image-2.jpg” box_shadow_style=”preset2″ box_shadow_spread=”-7px”][et_pb_divider show_divider=”off” _builder_version=”4.7.0″ _module_preset=”default” custom_padding_tablet=”150px||150px||true|false” custom_padding_phone=”” custom_padding_last_edited=”on|phone”][/et_pb_divider][/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.7.0″ _module_preset=”default”][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” quote_font_size=”18px” header_2_font_size=”36px” width=”96%” width_tablet=”100%” width_phone=”” width_last_edited=”on|phone”]

Choosing the Right Database

Behind the clouds, mobile devices, and apps that your organization uses to do business lays the heart of it all: the database. Selecting and implementing the correct database is an important decision. Faulty databases can cause inaccurate data parsing, slow speeds, and the dreaded crash, which are all real issues that may face your company today.

ZAG has the experience to help you with your database needs, including: design and implementation, administration and maintenance, and data analysis and reporting. We can help manage and protect your database system for its entire life cycle.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ custom_padding_last_edited=”on|phone” _builder_version=”4.7.0″ _module_preset=”default” background_image=”https://www.zagtech.com/wp-content/uploads/2020/11/bavkground-gray.jpg” custom_margin=”70px||70px||true|false” custom_margin_tablet=”0px||0px||true|false” custom_margin_phone=”” custom_margin_last_edited=”on|phone” custom_padding=”70px||70px||true|false” custom_padding_tablet=”50px||50px||true|false” custom_padding_phone=”” background_last_edited=”on|desktop” background_enable_image_tablet=”off”][et_pb_row column_structure=”1_2,1_2″ make_equal=”on” custom_padding_last_edited=”off|desktop” module_class=”reverse” _builder_version=”4.7.0″ _module_preset=”default” custom_padding=”1px||1px||true|false” custom_padding_tablet=”||20px||false|false” custom_padding_phone=”50px||20px||false|false”][et_pb_column type=”1_2″ _builder_version=”4.7.0″ _module_preset=”default”][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” quote_font_size=”18px” header_2_font_size=”36px” width=”100%” width_tablet=”100%” width_phone=”” width_last_edited=”on|phone”]

Microsoft SQL Server

SQL Servers are the most secure of all major database platforms. SQL delivers 99.9999% up-time, return on investment of up to 189% in one year, and can save you 460% annually compared to Oracle solutions.

Your organization can implement a cloud-ready platform with SQL Server 2006, get built-in mission critical capabilities, and enable breakthrough insights across the organization with familiar analytics tools and enterprise-ready big data solutions.

Common architecture and tools enable Hybrid IT infrastructures that help move your business forward and unlock new business models.

[/et_pb_text][/et_pb_column][et_pb_column type=”1_2″ disabled_on=”on|on|off” _builder_version=”4.7.0″ _module_preset=”default” background_image=”https://www.zagtech.com/wp-content/uploads/2020/12/sql-image-3.jpg” box_shadow_style=”preset2″ box_shadow_spread=”-7px”][et_pb_divider show_divider=”off” _builder_version=”4.7.0″ _module_preset=”default” custom_padding_tablet=”150px||150px||true|false” custom_padding_phone=”” custom_padding_last_edited=”on|phone”][/et_pb_divider][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ custom_padding_last_edited=”on|phone” _builder_version=”4.7.0″ _module_preset=”default” custom_padding=”0px||70px|||” custom_padding_tablet=”50px||50px||true|false” custom_padding_phone=””][et_pb_row custom_padding_last_edited=”on|tablet” _builder_version=”4.7.0″ _module_preset=”default” custom_padding=”0px||1px||false|false” custom_padding_tablet=”” custom_padding_phone=””][et_pb_column type=”4_4″ _builder_version=”4.7.0″ _module_preset=”default”][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” quote_font_size=”18px” header_font=”Proxima Nova – Regular|600||on|||||” header_text_align=”left” header_2_text_align=”center” header_2_font_size=”36px” width=”96%” width_tablet=”100%” width_phone=”” width_last_edited=”on|phone” custom_margin=”||||false|false” header_text_align_tablet=”” header_text_align_phone=”center” header_text_align_last_edited=”on|phone” header_2_text_align_tablet=”left” header_2_text_align_phone=”” header_2_text_align_last_edited=”on|phone” icon_placement_phone=”top” icon_placement_last_edited=”on|phone” image_max_width_phone=”105px” image_max_width_last_edited=”on|phone”]

Contact ZAG Today

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”4.7.0″ _module_preset=”default” custom_padding=”0px||0px|||”][et_pb_column type=”4_4″ _builder_version=”4.7.0″ _module_preset=”default”][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” quote_font_size=”18px” text_orientation=”center” width=”62%” width_tablet=”100%” width_phone=”” width_last_edited=”on|phone” module_alignment=”center” text_orientation_tablet=”left” text_orientation_phone=”” text_orientation_last_edited=”on|phone”]

ZAG’s Microsoft-certified IT consultants can help provide customized IT business solutions using SQL Server as the backbone for your environment. Utilizing SQL Reporting Services, your company can gain a dedicated Database Administrator who can provide your business with valuable business intelligence data that will provide you an immediate ROI.

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”4.7.0″ _module_preset=”default” custom_padding=”44px||0px|||”][et_pb_column type=”4_4″ _builder_version=”4.6.6″ _module_preset=”default”][et_pb_button button_url=”/contact/” button_text=”Discuss Database Management With ZAG” button_alignment=”center” button_text_last_edited=”off|desktop” button_alignment_tablet=”left” button_alignment_phone=”” button_alignment_last_edited=”on|phone” _builder_version=”4.8.0″ _module_preset=”default” custom_button=”on” button_text_size=”15px” button_text_color=”#ffffff” button_bg_color=”#1dc690″ button_border_color=”#1dc690″ button_border_radius=”0px” button_font=”Proxima Nova – Regular|500||on|||||” button_use_icon=”off” custom_margin=”-2px|||||” custom_padding=”10px|38px|10px|38px|true|true” hover_enabled=”0″ custom_css_main_element=”text-align:center;” button_bg_color__hover_enabled=”on|desktop” button_bg_color__hover=”#145da1″ button_bg_enable_color__hover=”on” button_border_color__hover_enabled=”on|desktop” button_border_color__hover=”#145da1″ custom_css_main_element_last_edited=”on|desktop” sticky_enabled=”0″][/et_pb_button][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.7.0″ _module_preset=”default” background_color=”#f7f7f7″ module_alignment=”center” custom_margin=”0px||||false|false” custom_margin_tablet=”70px||||false|false” custom_margin_last_edited=”off|desktop” custom_padding=”0px||0px||false|false”][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|desktop” _builder_version=”4.7.0″ _module_preset=”default” background_color=”#f7f7f7″ width=”100%” width_tablet=”80%” width_phone=”” width_last_edited=”on|phone” max_width=”none” custom_padding=”0px||0px||false|false” custom_padding_tablet=”70px||70px||false|false” custom_padding_phone=”||70px||false|false”][et_pb_column type=”2_5″ disabled_on=”on|on|off” _builder_version=”4.7.0″ _module_preset=”default”][et_pb_image src=”https://www.zagtech.com/wp-content/uploads/2020/11/critical-incident-cta-1.png” alt=”Careers” title_text=”critical-incident-cta” _builder_version=”4.7.0″ _module_preset=”default” position_origin_a=”center_left” width=”324px” custom_margin=”-117px||-1px||false|false” custom_padding=”||0px||false|false”][/et_pb_image][/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.7.0″ _module_preset=”default” custom_padding=”108px||108px||true|false” custom_padding_tablet=”0px||0px||true|false” custom_padding_phone=”0px||0px||false|false” custom_padding_last_edited=”on|phone” custom_css_main_element_last_edited=”off|phone”][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” header_2_font_size=”36px” header_4_line_height=”1.3em” width=”550px” width_tablet=”500px” width_phone=”100%” width_last_edited=”on|phone” module_alignment=”left” custom_margin=”||40px||false|false” module_alignment_tablet=”left” module_alignment_phone=”” module_alignment_last_edited=”on|phone”]

Critical Incident?

[/et_pb_text][et_pb_text _builder_version=”4.7.0″ _module_preset=”default” quote_font_size=”18px” header_4_text_color=”#1dc690″ width=”550px” width_tablet=”500px” width_phone=”100%” width_last_edited=”on|phone” module_alignment=”left” custom_margin=”-42px||25px||false|false” module_alignment_tablet=”left” module_alignment_phone=”” module_alignment_last_edited=”on|phone”]

Call Our Team Now for Immediate Assistance

+1 408.383.2020

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]