I’ve did a small research about what’s the best option is for hashing (e.g. determining deltas or hashing concatenated natural keys). Up until now, the algorithm used for hashing is MD5. 512 more words
I just wanted to do this quick blog post to give you a tip about a recent problem that I had in a SSIS Project. 228 more words
Demonstrating, by example, the different types of joins using Power BI… via @SQLJason.
— by Lori Brown
We recently started using a third party software to do our in-house SQL backups so that the backup files are stored in a redundant and safe place. 378 more words
In one of my SQL Server database development I came across a situation to use IsNull() in where clause. I tried to understand how it is good in performance with other approaches. 413 more words