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.
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).
Sometimes you want to have a copy of an existing database on […]
I originally wrote this article in December 2019 for my old blog. […]