ConsultingBy_white

SQL Optimization

Maintenance

Backup & Recovery

Security & Auditing

Stability

SQL is the world’s leading application data storage platform.  Whether you’re aware of it or not, your firm likely has numerous SQL instances on various different servers.  

Line of Business applications and ERP systems rely on SQL for storage, organization and rapid retrieval of data stored within. One of the leading causes of degradation in performance for SQL based applications is lack of maintenance and optimization of SQL Server back end.  

SQL is built on multiple layers of technology and any bottlenecks in these layers such as storage can have a profound impact on the overall system. As data is added, the content grows making it harder to locate. SQL has special indexes and statistics that are used for rapid retrieval of this data. As these indexes grow and become fragmented, the performance is impacted.  

With proper maintenance your applications can see tremendous performance increases.  Reports which used to take minutes to produce can be delivered in seconds. 

Indexes are only a tiny portion of the SQL platform which needs to be managed properly.  SiRON Health & Risk Assessment assesses each of these critical points and the existing operational plans against Microsoft best practices for the SQL Server platform. At the end of the process, you should have a clear understanding of potential risks that affect the implementation and ongoing support of your SQL Server solution. In addition, the assessment includes recommendations that provide a clear roadmap for remediation of risks so you can make informed decisions to support immediate and future business needs.

SQL Health and Risk Assessment

SiRON’s SQL Health and Risk Assessment uses Microsoft Best Practice Recommendations to analyze and assess the SQL infrastructure from the ground up.  We look at components which may affect certain areas of the system and ensure that the system adheres to those best practices. The process looks at the following but not limited to high level:

  • Backend infrastructure which provides the foundation on which the platform (operating system) and SQL is built on.

  • Windows platform:

    • Resources and relevant performance metrics.

    • Event Logs.

    • Configuration.

    • Clustering and High-Availability.

    • Backups and recovery.

  • SQL Server:

    • SQL specific performance counters.

    • Backup procedures and policies.

    • Maintenance Solution.

    • Index fragmentation and effectiveness.

    • Configuration and how it stands relevant to best practices.

    • Security and Auditing.

    • SQL specific metrics used to identify and isolate any potential problems.

    • High-Availability, replication and database mirroring.

  • Application front end (server side)

  • Application client (PC side)

  • General Security Issues and Vulnerabilities

  • Stability of the system

  • Hardware Load Balancing

  • Replication

  • Disaster Recovery

  • Auditing

The assessment is scaled up or down based on the individual client’s needs and information discovered as we progress through the assessment process.  At the end of this process you will have a clear understanding of your SQL environment, the issues affecting it and the roadmap to remediate them.

SQL Injection Vulnerabilities

SQL Injection is one of the most common web attack mechanisms used by hackers to steal data from organizations. Even the least likely candidates like VISA, Yahoo and world banks have been hacked using this attack method. It essentially allows an attacker to inject SQL commands by inserting rouge commands into a filed like a login or contact form on your site in order to allow them to gain access to the data held within the database.  Using these rouge commands attacker can cause the SQL backend to return data such as client information and other confidential data.  In some cases attacker can gain unrestricted access to the entire system.

Let us help ensure your organization is protected against vulnerabilities that could cause exposure and damage your firms reputation, possibly leading to legal action.