Posts by Gillian Johnson

Business Development & Marketing Manager at Aireforge. My posts are written with the help of the Aireforge team, who have more than thirty years’ experience in SQL Server management, optimization and tuning. We create simple, easy to use tools that help you navigate some of the issues we’ve seen over the years.

Improve customer experience with Aireforge Studio

intuitive are the leading travel technology supplier of the iVector reservation platform. They wanted to ensure they caught any performance issues before they impacted customers, whilst optimising the ‘health’ of their servers.  Using Aireforge Studio, they identified areas to troubleshoot in minutes. In hours, they’d made changes to improve usability. Now, they have a roadmap of improvements to make their application perform even better than before.

The Challenge

intuitive provide a complete reservation platform for Tour Operators, Online Travel Agents and Hotel Wholesalers. Their customers’ databases vary as much as they do – from value-for-money holidays that rely on high transactions, to low-volume, exclusive tours. But whatever the customer, the need is the same: fast, scalable and reliable applications.

Their approach to hosting and server management has always been to know about issues before they impacted customers, but they wanted to take this even further.

The Solution

intuitive’s Infrastructure team ran Aireforge Studio. Within minutes, the application identified areas to improve performance and reduce resource consumption.

They uncovered some significant optimisations very quickly, followed by performance and efficiency tweaks that will combine to improve the overall user experience. The team set to work going through the list of recommendations. Within a few clicks, they were able to make many enhancements, by using the in-app scripts.

Next, intuitive plan to use the recommendations to improve customer service. They’re also going to replace their manual list of regular customer health checks with Aireforge Studio’s as part of their workflow.

The Result

Happier customers.

By following in-app recommendations, intuitive significantly reduced a key query for within their holidays quote repricing function. This will result in time savings for their users and an improved experience for the end customer.

Increased data security and performance.

By following best practices, the team has further improved how they identify and resolve issues before they impact customers. They can be more proactive, adding value to the way their client’s data is managed and providing a great service. 

Better insight.

The team plan to use Aireforge Studio’s shared profile to provide a central overview of their databases. They have confidence to make changes because Aireforge Studio provides links to the resources backing their recommendations.

Photo by Glenn Carstens-Peters on Unsplash

Save time with Aireforge Studio: a case study

José Guay is an incredibly busy director at a software company. He uses Aireforge Studio to find issues with his client’s databases. By using in-app prioritization and suggestions, he can get results for his customers, in a smarter, faster way. This frees up time to spend it where he’s needed the most – providing expert advice and mentorship for his team.

The Challenge

José wears many hats at work – director, developer, account manager, mentor and database manager. He works at CSW Solutions, a full-service software development company. Their clients are diverse, ranging from Cultural Institutions to Financial Services.

His biggest test is accomplishing everything the team sets out to do. Their standards are high for their clients and they aim to excel in all areas. However, when managing such a variety of customers and services, it’s a constant balancing act. José is a SQL Server expert, but with so much to do, he doesn’t get as much time as he would like to keep on top of the latest technical changes.

The Solution

José uses Aireforge Studio to get a full overview of his client’s databases, fast. For companies with large estates, it gives him a quick understanding of what issues should be handled as a priority. This means he can handle his workload more strategically. He then uses the in-app suggestions combined with his own experience to implement solutions.

José also uses the application to conduct quarterly checks and reviews. This helps him standardize what’s checked regularly and ensures client’s estates are optimized in accordance with the latest updates to SQL Server.

The Result

Happier clients. By working more efficiently, José and his team can optimize databases even faster than before, with results that the customer can benefit from immediately.


More time. By standardizing some database tasks and using in-app knowledge rather than having to always rely on his own, José’s valuable experience can be focused elsewhere.


Increased innovation. The team can stay on top of the latest technical changes without having to spend hours researching through the in-app knowledge base.

Lead image courtesy of Unsplash.

Why database management can make or break your business

Like it or not, all businesses now rely on their data and infrastructure for everything they do. The database is at the heart of any organization, regardless of sector. It contains everything you need to function: customer’s personal details, orders, leads, projects, employee information – the list goes on. So, when there are problems with your databases, it impacts all other aspects of the business. By neglecting database management, your company is taking a serious risk. There’s also a high chance you’re wasting money on infrastructure and jeopardising future growth. Can your business afford to ignore it?

The price you pay for poor database management

Expensive downtime
98% of organizations say a single hour of downtime costs them over $100,000. For enterprise organizations, this figure increases to $1-5 million per hour! Of course, every business is different, but once you’ve considered the loss of financial transactions, staff productivity, etc. you can see how the figures stack up. On top of that, the cost per hour is increasing, as more of our work relies on interconnected systems.

Loss of reputation
There are only so many times a client will try to make a transaction before giving up and going elsewhere. Repeated outage is not just unprofessional – it can risk you losing customers if it happens often enough.

Fines
SLAs, regulatory breaches, industry fines. Whether you have any explicitly linked to downtime or not, the effect on services can be detrimental enough to trigger a breach.

Loss of productivity
If staff can’t access the information they need to work, there’s not much they can do.

High running costs
How much are you paying for infrastructure you don’t need? If the IT team don’t have the capacity or experience to routinely make improvements to the server estate, then the answer is almost certainly too much.

The benefits of good database management

Leaner, faster working
By speeding up your databases, you’ll help to reduce everything above leaving you with a quick, more effective foundation on which to run your business.

Happy customers, and more of them
Your customers will not only be happier with your faster services, but you’ll have the capacity to complete more sales through your new faster transactions, growing your business significantly.

Saving serious money
By making your existing infrastructure work harder, you’re less likely to need to buy or lease new hardware. Even better, you might be able to cut down what you’re using. One Aireforge customer reduced the servers needed for their work from 64 to 1 by using the application, saving them over $1 million.

Business growth
Imagine all the things your business could achieve with a faster, more efficient database, increasing your sales and more productive teams?

How we help
Our database management tool Aireforge Studio makes improvements to your servers easy. Designed for IT teams, the application analyzes your servers and makes recommendations on how you can improve efficiency, stability and security.

We give you what you need to make the changes, so busy teams can take advantage of the latest industry knowledge without spending hours researching them. All advice is linked to supporting articles making the process transparent, giving you the confidence you need to make changes to your invaluable systems.

Do you want to make drastic improvements to your business through effective database management? Send me an email at gillian@aireforge.com and I’ll be in touch.

Four ways to use instance snapshots

Instance snapshots can be invaluable to anyone working with servers. From tracking differences over time, to change deployment, here are some ideas on how they can help you. Then, discover how you can use the free tools in Aireforge Studio to implement them.

Tracking differences over time

By taking a snapshot of your servers’ configuration at the right moment, you can use it as a baseline for comparison in the future. This is helpful when:

  • You’re taking a holiday and you want to know what happened while you were away.
  • You want to capture the ‘before’ of a client’s servers prior to a health check. You might add this to a report to show the improvements you’ve made.
  • There’s a change freeze and you’d like extra reassurance nothing has been amended by accident.

Change deployment

When you’re deploying changes:

Take a snapshot prior to any changes to use as a configuration back up. Then, when you’re making changes, you can test them against an exact recreation of your servers, helping to minimize mistakes when you go live. You can also do this during performance tuning.

When someone else is deploying changes:

With a snapshot, you’ll be able to see any impact others’ changes may have had on your servers by comparing a pre-changes snapshot with post-release servers.

Remote troubleshooting

Working with servers that you don’t have access to? Get your customer to capture a configuration snapshot, then use this for analysis, comparison and more. This way, you’ll get the information you need, save support costs and reduce turnaround time.

Golden configuration template

When you’ve got a server into an ideal state, you might use a snapshot of it to:

  • Share configurations with colleagues as an example of best practice.
  • Use as a reference or template for future server setup.
  • Use as future reference for the same server if it experiences performance issues later down the line.
  • Create example files to distribute with your software to aid installations.

How Aireforge Studio helps

In Aireforge Studio’s Compare module (totally free), you can capture and save a snapshot. Then, use it for comparison against the same servers (for comparing server differences over time), comparing against other servers (useful when using your server as a golden template, or for viewing and sharing.

Taking a snapshot

From the Compare tab, check the server/s you want to take a configuration snapshot of.  Press the ‘Snapshot’ button, then choose ‘All comparisons’ or ‘Selected comparisons’ (depending on whether you want to snapshot all configuration or just a subset).

Snapshot button

You will then be prompted to save the snapshot to file. That’s it! You can now use this saved snapshot to compare against any of your servers within Aireforge Studio.

Using a snapshot

To compare the snapshot against the same servers captured within it, go straight to the next step. To compare against other servers, select those you wish to compare against first.

Press ‘Load’ and select the snapshot to open. If you recently took the snapshot, it will appear on the drop-down menu.

snapshot 2

Next, a dialog will be shown to let you choose what to do with the snapshot:

Loading snapshot dialog

  • Compare with same servers: compares the contents of the snapshot against the current state of the same servers.
  • Compare with currently selected servers: compares the contents of the snapshot against the currently checked servers on the Compare tab.
  • View only: simply opens the snapshot for viewing, without taking any new snapshot.

When comparing the snapshot against any servers, the comparison will be against the current state of the servers. You will now be presented with the comparison results or a view-only snapshot file.

Watch the video

All of the functionality in this post is free. Download yours at aireforge.com

Image courtesy of https://unsplash.com/@makariostang

Continue reading →

Potential pitfalls using Always On Availability Groups

Always On Availability Groups are a great way to improve uptime and protect against data loss. However, whilst the databases within the availability groups are synchronized, the instance objects, users and configuration settings that the system relies on are not. This could cause the following to happen when you failover:

  • Authentication issues. Your users and database roles are synchronized but do not match up to a server login or server role. Your systems are down and you’re helpless.
  • Missing/incorrect Agent Jobs. A difference in job steps or schedules can result in jobs not being run or data issues due to missing changes and bug fixes.
  • Missing server objects. Issues with Linked Servers, Trigger or an incorrect configuration setting could result in queries failing or performing much slower than the primary.

It’s very easy for server objects to become out of sync, causing the above. Changing a user, fixing a script within jobs, updating the job schedule: these regular tasks can all cause major issues after failing over.

“You should routinely maintain the same set of user logins and SQL Server Agent jobs on every primary database of an Always On availability group and the corresponding secondary databases.” Microsoft Docs

How do I fix it?

Here are some ways you can protect yourself from Availability Groups becoming out of sync:

  1. Use an active directory to help mitigate the SID issues (be aware that you might still encounter differences using this method– users’ rights or disabled users, for example).
  2. Manually compare the SIDs between your instance and AG using scripts.
  3. Compare job information using a text comparison tool like code compare.
  4. Create your own custom script that covers every possible object and setting and manually compare the results on a regular basis.
  5. Use the free comparison tool in Aireforge Community Edition.

I’m too busy for that – is there a faster way?

Use Aireforge Studio’s instance-level comparison tool to quickly spot differences (it’s free). Identify varying SIDs, user access rights, server configuration (e.g. max threshold) between your instances in a few clicks.

You can incorporate these comparisons into weekly checks. Many of our users even run these daily so they’re less likely to be caught out during failover. As a minimum, you could compare and fix any differences before planned failovers or any significant changes.

I’ve found the changes, but I need help fixing it…

Aireforge Advise (not free, but reasonable), will give you the SQL to fix these differences once you’ve identified them.

Aireforge Studio simplifies database management for SQL Server & Azure SQL databases. Download for free at aireforge.com.

How to use Aireforge Studio as a free RDP & SSMS Manager

Working with an estate of hundreds of servers? Finding it difficult to keep a shared, central list of server information up to date?

Everyone seems to have their own solution for maintaining the details their team needs for SQL Server Management Studio/Remote Desktop. Maybe you store this information in a spreadsheet or text file on a shared network drive, have a local copy, or use a specialised separate program to coordinate this knowledge. Maybe you even have it printed out and taped to the wall!

All these methods come with their pros and cons, but besides the pricier options, most require regular manual work. We’ve got another way for you to try, and it’s free.

How Aireforge Studio can help

When using Aireforge Studio, you start by setting up all your servers in the Estate module. The list then becomes your central workspace for you to compare settings, run health checks, scripts etc.

To launch SSMS or Remote Desktop, there’s a right-click option, then the relevant address details are pre-populated. No more moving between documents or copy and paste! You can even give servers friendly names to make your workspace faster to navigate.

For teams, there’s an alternative to a centralised document: share a secure, password protected Aireforge profile. That way, you’re only inputting this data once and everyone is always getting the recent information.

Download your free tools today at aireforge.com.

Visit our Knowledge Base to learn how to set it up.

remotedesktop

Why snapshots should be on your festive checklist

Are you taking some time off over the holiday period? Do you have a change freeze scheduled over the next few weeks?

If so, taking a snapshot of your servers’ configuration is a helpful way of making your work less stressful when you return. That way, when you get back after your time off, you can compare the state of your servers post-holiday with how you left them. You wouldn’t leave your house for the break without properly securing it, so why should your servers be any different?

Comparing snapshots is easy in Aireforge Studio. In the application, take a snapshot of your servers this week. Then when you get back, it’s only a few clicks to compare it against the same servers. You get a clear list of the differences between them, so you’ll immediately be able to see any changes anyone has made. No more hidden surprises, and it makes it so much simpler to revert things if you need to.

Watch our video or read the support page to see how. Then, relax and enjoy your time off, knowing you’ll be prepared for your return.