Sql

When migrating server instances to Google Cloud it can be required to change licensing for the sofware that is running within the instance. This can be to use pay-as-you-go (PAYG) licensing for products such as SQL Server or adding additional support packages for Linux derivatives.

Today I needed to create a test database for one of the products I’m working on. In the backend it uses LINQ to SQL against a SQL Azure Database. Exporting the production database and cleaning it up with millions of records in it turned out to be not the most efficient way of creating an empty test database.