↓ Skip to main content

Sql

Adding SQL Server PAYG licenses to VMs running in Compute Engine

·235 words·2 mins
When migrating server instances to Google Cloud or installing SQL Server on an existing instance in Google Compute Engine (GCE), you may want to use PAYG licensing. To ensure compliant billing for PAYG, the corresponding SQL Server license string must be attached to the VM’s boot disk.
Retrieving licensing strings for use with Google Compute Engine

Retrieving licensing strings for use with Google Compute Engine

·581 words·3 mins
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.
Remove data from BACPAC file

Remove data from BACPAC file

·158 words·1 min
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.