Software Development

Write a SQL query to find all duplicate emails in a table named Person. +----+---------+ | Id | Email | +----+---------+ | 1 | a@b.com | | 2 | c@d.com | | 3 | a@b.com | +----+---------+ For example, your query should return the following for the above table: +---------+ | Email | +---------+ | a@b.com | +---------+ Note: All ...

As code gets old, it often becomes necessary to modernise it. There are a few motivations for this: We’ve found a better way of doing itWe need to update core libraries/technologies for support/licensing or just plain best-practice reasonsWe need to run the software on more modern infrastructure In short, it’s rare for software written a few years ago to be ...

Happenstance testing is a test smell where you are asserting something more specifically than relevant to what you’re testing. For example, trying to assert the order of items in a set can lead to disappointment when your runtime changes its algorithm for arranging sets. Similarly, asserting the exact test of an error message, unless it’s the construction of the message ...

Most of us are very familiar with the famous Mark Zuckerberg declaration to “move fast and break things.” That was a very bold statement back in 2014, and, as Zuckerberg quickly realized, probably too bold. He later retracted it, stating his new desire to move fast, yet stay stable. To better address code quality (without compromising speed) many organizations are ...

It’s a common issue when trying to start up your application. Something goes wrong, there’s a load of trace on the console, and you need to try to work out what could be the problem. There’s are various cognitive biases that affects our ability to resolve these problems. We often expect the thing we last did to be the cause ...

Become the Ultimate Employee or Job Candidate with Lifetime Access to Over 600 Expert-Led Courses on PMI, ITIL, CompTIA, Microsoft & Other In-Demand Skill Sets Hey fellow geeks, This week, on our JCG Deals store, we have another extreme offer. We are offering a massive 95% off on Integrity Training: Online Workforce Courses: Lifetime Membership. Get it now with only ...

This was originally posted on LinkedIn as Life without TDD – Driving with the brakes off, or driving with no brakes? This version is updated with my current thinking around TDD and how to write! Once upon a time… Today one of our unit tests failed. Its failure stopped our automated release process in its tracks and we spent a ...

Become a Cybersecurity Superhero with 60+ Hours of Training from Ethical Hacking Professionals Hey fellow geeks, This week, on our JCG Deals store, we have another extreme offer.We are offering a massive 96% off on The 2020 Premium Ethical Hacking Certification Bundle. Get it now with only $59,99 instead of the original price of $1,600. Complete Ethical Hacking & Cyber ...

God, I hate enum in Java. (Well, I don’t, but it got your attention didn’t it!?) Here’s a simple chain of events, leading to an odd conclusion: We have a component that can do processing based on configurationWe decide to put the different operations it could do into an enum so that we control the valid valuesThe code that correlates ...