SEP Blog

We’re curious people by nature. And we love to teach others what we’ve learned. So explore our blog to gain fresh insights from our expertise in areas ranging from culture to AI.

SEP Named a Winning Company in the 2022 Powderkeg Unvalley Awards

I have a relative that frequently has medical problems. This despite the fact that he’s a healthy young man. His problem is that he has too many names. He’s James-Robert, but depending on whom you ask, you’ll hear him…
Read More

Record Deduplication

I have a relative that frequently has medical problems. This despite the fact that he’s a healthy young man. His problem is that he has too many names. He’s James-Robert, but depending on whom you ask, you’ll hear him called: Jim Bob Robert James Jim-Bob He has five names at least, and that’s before considering […]
Read More

A minor shift in mindset that improved my SQL

I am currently working on a project that involves writing stored functions in PostgreSQL. Typically the goal is one SQL query that returns all the data needed by a particular web page. At first I approached this from an Object Oriented perspective with a focus on minimizing redundant data. This led me down the path […]
Read More

Why consider a Data Warehouse?

The need to collect, store and analyze large amounts of data continues to increase in importance for businesses across all industries. Marketing agencies have led the pack in processing large amounts of data in order to gain consumers attention in a crowded space. However, virtually every other area is beginning to see the value in […]
Read More

Oracle Wallets and You … No, Not You, Behind You. Yeah, You.

Oracle databases are a complex system of interconnected parts. The toolset is comprehensive and robust. And so is the documentation. Possibly too robust, even. I have spent the last couple of days researching how to do One Specific Thing, while the documentation has delighted in telling me All the Things That Can Be Done. And […]
Read More