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.
Use case: you have an SQL Server database table and use Identity (auto increment) for the primary key (let’s call it id). For any reason, the table content is as following:
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.
A while ago, I wrote an article here on how to restore a complete database with a different database name. That is actually restoring a database from a full backup. This time, in addition to that, I want to show you how to backup a SQL Server database and restore it, both in full and differential mode.
If you are like me, you may have heard Azure a few years ago for the first time. You may even have tested and tried to work with it. But somehow, either you’ve been turned off by the cost (it starts reasonably small, but it can have snow ball effect if you are not careful) or the demands were not really out there. So you decided to stop using the service because you’d better use your time for something else.
However, cloud computing is the thing now, and it makes sense to give it another look.
Sometimes you want to have a copy of an existing database on […]
I originally wrote this article in December 2019 for my old blog. […]