US

Always on support feature integration for ApexSQL

  • always on support feature integration for apexsql icon data storing

    Local data storing

  • always on support feature integration for apexsql failover

    Adjustable failover

  • always on support feature integration for apexsql boosted

    Boosted performance

Project overview

To keep the SQL Server system highly stable and protected, new features and updates are released over time. Some major updates replace or serve as alternatives to older capabilities. For instance, the AlwaysOn feature came as an enterprise-grade alternative to database mirroring. The default support of Always On by the ApexSQL system was what we set out to integrate for the client.

Client information

The client is an established provider of SQL Server solutions for the most various purposes – ApexSQL. Specialists of ApexSQL implement high-quality solutions for giants, such as Intel, NASA, Bank of America, and many more. Since recently, the company has been operating under the wing of Quest, an even bigger software provider that decided to invest in ApexSQL and make it a subsidiary.

always on support feature integration for apexsql project

Business challenge

Businesses that operate in the digital realm rely heavily on software and, in particular, online technologies. SQL Server is the most widely used database management system for keeping business data intact up to date. That’s why it should be maintained properly. Namely, standard systems should be expanded and kept updated to meet the custom requirements of particular companies. New efficient features must be implemented timely.

Technical challenges

Ultimately, we needed to integrate AlwaysOn support for the ApexSQL Audit system with the existing support for Failover Cluster Instances. For that, we had to dive into the system’s code head to toe, integrate new custom libraries, and enable the existing system to audit AlwaysOn clusters. Other major tasks included building a new setup, conducting a clean installation and upgrading from the previous versions, deploying the new feature, and conducting unit testing.

Solution delivered

AlwaysOn support for ApexSQL Audit enables the client’s system to audit clustered instances of the AlwaysOn SQL Server. AlwaysOn AG detects newly added nodes to be audited and applies the related settings. Server-level auditing settings for SQL Server instances are first adjusted on the AlwaysOn AG level and are automatically applied to all SQL Server instances.

always on support feature integration for apexsql project
Claim a 30-minute talk with our experts and get a step-by-step strategy for your project for free!
Talk to our strategist

Key features

always on support feature integration for apexsql key

  • Individual auditing

    Working with the ApexSQL Audit expanded with the AlwaysOn support, a specialist can choose specific sets of availability databases to be audited for more precise work.

  • Custom settings

    For each chosen availability database set, auditing settings can be customized individually to pinpoint particular data sets.

  • One-time events capture

    Mirroring operations between primary and secondary replicas should no longer be collected by default – instead, events are captured once and stored in the central repository to speed things up.

Value to our client

  • Local data storing

    AlwaysOn excludes the necessity of shared storage, which frequently acts as a common point of possible failures.

  • Adjustable failover

    Either automatic or manual failover can be set for AlwaysOn groups, which provides ultimately more data management flexibility.

  • Boosted performance

    Many resource-consuming operations can be offloaded thanks to the new features, increasing the overall performance of the system.

Our tech stack

  • ch C#
  • Visual-Studio-1 Visual Studio
  • net .NET/ASP.NET

Software solutions bringing business values

gartner
5/5
6 reviews
clutch
4.9/5
48 reviews

    Contact us

    100% data privacy guarantee

    Thank you!
    Your request has been sent
    We will get back to you as soon as possible

    USA (Headquarters)

    +16469803276 2810 N Church St, Ste 94987, Wilmington, Delaware 19802-4447

    Denmark

    +4531562900 Copenhagen, 2900 Hellerup, Tuborg Havnepark 7

    Poland

    +48789743438 ul. Księcia Witolda, nr 49, lok. 15,
    50-202 Wrocław

    Lithuania

    +4366475535405 Vilnius, LT-09308,
    Konstitucijos ave.7
    6th floor

    Faroe Islands

    +298201515 Smærugøta 9A, FO-100 Tórshavn,
    Faroe Islands

    Austria

    +4366475535405 Donau-City-Straße 11 - Ares Tower, 1220 Wien

    UAE

    +4366475535405 Emarat Atrium, 423 Al Wasl Area, Dubai, P.O. Box 112344

    Ukraine

    +4366475535405 Vatslava Havela Boulevard, 4,
    Kyiv
    Case study
    Always on support feature integration for ApexSQL
    diceus.com
    Case study
    Always on support feature integration for ApexSQL
    Project overview
    To keep the SQL Server system highly stable and protected, new features and updates are released over time. Some major updates replace or serve as alternatives to older capabilities. For instance, the AlwaysOn feature came as an enterprise-grade alternative to database mirroring. The default support of Always On by the ApexSQL system was what we set out to integrate for the client.
    Client information

    The client is an established provider of SQL Server solutions for the most various purposes – ApexSQL. Specialists of ApexSQL implement high-quality solutions for giants, such as Intel, NASA, Bank of America, and many more. Since recently, the company has been operating under the wing of Quest, an even bigger software provider that decided to invest in ApexSQL and make it a subsidiary.

    Information
    Business challenge

    Businesses that operate in the digital realm rely heavily on software and, in particular, online technologies. SQL Server is the most widely used database management system for keeping business data intact up to date. That’s why it should be maintained properly. Namely, standard systems should be expanded and kept updated to meet the custom requirements of particular companies. New efficient features must be implemented timely.

    Technical challenges

    Ultimately, we needed to integrate AlwaysOn support for the ApexSQL Audit system with the existing support for Failover Cluster Instances. For that, we had to dive into the system’s code head to toe, integrate new custom libraries, and enable the existing system to audit AlwaysOn clusters. Other major tasks included building a new setup, conducting a clean installation and upgrading from the previous versions, deploying the new feature, and conducting unit testing.

    Solution delivered

    AlwaysOn support for ApexSQL Audit enables the client’s system to audit clustered instances of the AlwaysOn SQL Server. AlwaysOn AG detects newly added nodes to be audited and applies the related settings. Server-level auditing settings for SQL Server instances are first adjusted on the AlwaysOn AG level and are automatically applied to all SQL Server instances.

    Key features
    • Individual auditing

      Working with the ApexSQL Audit expanded with the AlwaysOn support, a specialist can choose specific sets of availability databases to be audited for more precise work.

    • Custom settings

      For each chosen availability database set, auditing settings can be customized individually to pinpoint particular data sets.

    • One-time events capture

      Mirroring operations between primary and secondary replicas should no longer be collected by default – instead, events are captured once and stored in the central repository to speed things up.

    Value to our client
    • Local data storing

      AlwaysOn excludes the necessity of shared storage, which frequently acts as a common point of possible failures.

    • Adjustable failover

      Either automatic or manual failover can be set for AlwaysOn groups, which provides ultimately more data management flexibility.

    • Boosted performance

      Many resource-consuming operations can be offloaded thanks to the new features, increasing the overall performance of the system.

    Tech stack used in project
    • C#
    • Visual Studio
    • .NET/ASP.NET
    diceus.com