Data Engineering Blog

Genuine News about the Data Ecosystem.
Topics: #dataengineering #bigdata #python #opensource #etl

Migrate from Oracle to Microsoft (Views) – Part I

Sometimes you have to migrate from an Oracle database to a Microsoft SQL Server. I’m not going into the reason that could be behind. I had different projects where I had to achieve this goal. The issues that I faced is what I would like to share with you. Different functions When it comes to rewrite code from Ora-SQL to MS-SQL, in my case it were Oracle Views that had to be transfered to Microsoft Views, then the first thing you figure out is, that there’s not the same built in functions on both sides.

Need any Headphones?

They are not cheap, but they are best! This are the new technology of headphones. They do have an active noice canceling in it. So you will not hear (or almost not) the monotonous sounds of trams, train, flight or even talking from other peoples. If you are traveling a lot or working in a shared room with more than 5 people, you have to buy them, you won’t regret it!

Do you listen to music while working?

If yes, there is one best thing I used for the last time. If you listen to music while you working or study, this makes you focus on the work: https://www.focusatwill.com/ It is a music player with neuroscience based music channels, which dosen’t disturb you. Some advertising from their website: Stop the wrong music. 50% of us play background music while studying, working or inventing. But…it’s the wrong music! Mainstream music lowers comprehension and creates distraction because it is designed to connect with you intellectually and emotionally.

Annoying advertising, what you can do

Recently I was asked what I do against advertising on websites. I was a bit confused at first because I didn’t have that problem the last 2-3 years I think. This is when I started to use Adblockers on my browsers to get rid of this annoying advertising or flashing everywhere on the page what distract you from the essential on the page. So I recommend to use Adblockers as soon as possible and you will look confused as I when you hear about advertising on web pages the next time because there isn’t anymore.

ORDER BY Oracle vs. Microsoft SQL

Like you would think ORDER BY is the same in Oracle as in the Microsoft environment, it isn’t. It depends on the Collation of the database. In the following example you see, that two manually added text in Oracle and Microsoft don’t order the same. After I added the Collation for SQL_Latin1_General_CP850_BIN2, it ordered the same. ORDER BY Oracle: ORDER BY Microsoft - normal and with collation: