IN vs NOT IN vs EXISTS vs NOT EXISTS Performance Considerations

Hi there!

I’ve often been asked about these operators in terms of performance, like “which is best?” I guess I could say “well, it depends…” as in so many cases. In this post I’ve decided to demonstrate some factors upon which it actually depends that may not be of common knowledge, so if you are one of those who is curious about this question, read on and enjoy the ride 🙂

Cell level encryption

Hi there!

Securing data has always been important but as time goes by, more and more data is available all around us, some of it is considered sensitive data and it becomes a major concern to protect it somehow, in fact in certain cases it is legally mandatory to comply with certain regulations (like GDPR). SQL Server offers a few options regarding data protection (either by means of encryption or obfuscation), cell level encryption being one of them.

In this post I’ll explain what is cell level encryption along with its use cases and I’ll use a thorough demo to show how to implement it in a database and how it works 🙂