Category: Database Migration

Once you have migrated your data from SQL Server to Amazon SQL Server Relational Database Services as described in Migrate your SQL Server database to Amazon RDS in 3 easy steps, you need to compare your source and destination database and make sure that all the data is identical. There are two ways to do… Continue reading Validate your SQL Server Amazon RDS migration

With the proliferation of virtual machines and powerful multi-core servers, it is no surprise that Microsoft has introduced a per-core licensing model with SQL Server 2012. I hope to make the various ways of licensing SQL Server 2012 a little easier to understand. First, lets discuss the SQL Editions that will be available. SQL Express,… Continue reading Licensing Microsoft SQL Server 2012

When running your databases on an Amazon server instances, the disks on which your databases run are what Amazon calls “Elastic Block Storage” (EBS) volumes. EBS volumes are networked attached (NAS) disks. This means that data moved to and from the disks goes through the network interface card along with all the network traffic. This… Continue reading SQL Server IO performance on Amazon Web Services