Admin Pack for Azure Data Studio

I have been using Azure Data Studio for a while now (since end of 2019, perhaps? Too lazy to check). It was love at first sight for me. Because I had used the Visual Studio Code before (I still use it sporadically), I felt at home with ADS immediately. The look, the intellisense, the dark mode, the cross-platform, the extensions, almost everything.

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).