Data

  • SQL image

How to Write a Good SQL Query

2020-08-03T19:15:27+00:00May 22nd, 2019|

You’ve been coding feverishly for ten minutes. You’ve got twenty table joins lined up, and you’re ready to execute your newest monster SQL query. A single bead of sweat rolls down your forehead as you timidly press the button to execute. You watch the SQL engine spin as it starts to process your query. One second ticks by. You think, “No syntax errors!” Three more seconds. Now you’re starting to get nervous. At the ten-second mark, nervousness gives way to panic. Now you think, “Where’s my data?” At twenty-two seconds, two records finally come back from your query. “That’s the data I’m looking for, but why did it take so long?” you ask yourself. Even the best query writers have been here. So, how do you write better SQL queries to improve your execution? Be Linear Map out a linear path from table to table to table – to get

  • signing papers

The ABA Endorsement Process and What it Means for Banks

2020-08-03T19:15:44+00:00May 24th, 2019|

Bankers enjoy a dizzying array of opportunities to leverage new partnerships to cut costs, boost profits, improve technology, enhance the customer experience – and sometimes – all of the above. That’s the good news. The not-so-good news is sifting through an increasingly complex landscape of new entrants and established vendors and vetting potential partners takes time, energy, expertise and money– often more than any one bank can easily manage. This is where a national trade association is uniquely positioned to add value. It can spread research costs across a diverse membership base while evaluating best-in-class providers offering a broad range of products and services. THE ABA ENDORSEMENT PROCESS The concept behind the American Bankers Association’s due diligence process is as simple as it is successful. Its process identifies proven, reliable vendors while saving banks time and money – and uncovering areas of information that could otherwise be difficult to obtain.