6 Steps to Database Migration in the Cloud

I have been asked a few times on how to migrate databases in the cloud. Sometimes I’m confused and have to pause before answering this question. Not because I don’t know how, but it’s more that I’m trying to figure out what is the motivation behind the question. In short: it should not be different than migrating databases on the on-premises servers. In other words, the only difference is that, the servers on the cloud are managed by a third-party provider.

SQL Tip: String Splitting Into Column With Delimiter

I’m not sure if the title above is understandable. What I mean by that is, you have a string and you want to split it and put each string element into specific columns. The split element is separated by a delimiter.

When you see the example below, I hope you understand what I’m trying to do (spoiler alert: it has something to do with CROSS APPLY).