Kenneth Fisher avoids overloading:
In SQL Server both the set and equality functions are handled by the equals sign (=).
[…]
However, in some other languages that’s not how it works. In PowerShell for example the equals sign is always a set operation.
Click through to learn the difference, as well as what Powershell uses for equality operations. I think my favorite language for this is Scala, where I jokingly say = means “is equal to,” == means “is really equal to,” and === means “is equal to and I totally mean it.”