Case study database
ABSA case study database lot of money very quickly.
A wholly-owned subsidiary of the Barclays Africa Group, ABSA Bank offers a range of retail, business, corporate, and investment banking, as well as wealth management products and services, primarily in South Africa and Namibia. A team of 40 developers supports the bank’s payment processing systems and handles 3,000 high-value transactions per day. The aim is for development teams to have end-to-end responsibility for the solution they are developing, without handovers, complex review processes, or spending too much time on non-value add activities. The overall goal is to improve accuracy and therefore minimize risk, at the sametime as reducing the time to release. Our manual database deployment process typically took 2-3 hours per developer per week.
The study teams at ABSA have been using Redgate’ SQL Compare, SQL Data Compare and SQL Prompt for many years. The bank has seen increased productivity as well as improved case satisfaction, a major contributor to employee retention and a key element database establishing high-performing IT teams. Database deployments, however, were still holding the teams back. The process was a manual one where teams made changes, compiled deployment scripts, saved them to a directory, and handed them over to operations for review and deployment.
Interesting case studies
How to construct a business plan,Legal case studies,Work essays,
All of which took a lot of time and occasionally caused problems with deployments. We did a bit of reading and asked Redgate some questions, but generally it was very straightforward to start using the SQL Toolbelt,» says Rynhardt van Rensburg. Having run a successful proof of concept with SQL Toolbelt, ABSA have been able to implement a one-step process from development through to production. This frees up the equivalent of an extra developer by removing the manual steps and provide an immediate return on investment. That’s not even taking into account the faster time to market and reduced downtime. With the SQL Toolbelt, the bank also has confidence that deployments are less risky, because less human intervention is needed.
All database changes are now checked into version control alongside application code changes. The check-in triggers the CI process, which builds the changes to test everything is working as it should. If the changes aren’t fit for deployment, the CI process automatically causes the build to fail and sends it back to development with quick feedback on what went wrong. It doesn’t need a human to spot what is sometimes impossible to spot, and any errors are caught early in the process in a systematic, repeatable way. Not only is our development team more productive, we are also seeing substantially faster delivery times and, most importantly, more accuracy. The team previously used an in-house tool, but it was fairly limited in scope and primarily covered long-running transactions.
Beyond the alerts, SQL Monitor provides detailed information on performance issues, presented in an easily accessible way, and much more flexibility in terms of the metrics that can be looked at. As a direct consequence, it’s easier and quicker to get to the root cause of performance issues. We’re very pleased with the solution Redgate has provided, and it’s a big plus for us to get everything we need from a single vendor. Our products are used by 804,000 IT professionals, in more than 100,000 companies.
- Most cited books on ap lit exam essays
- Work essays
- Easy research papers
- How to construct a business plan
- Legal case studies