In addition to working on my database sharding presentation I’ve been working on upgrading an ETL framework. In learning this new framework I dug into the business logic as to what the framework was trying to load, looked into all the auditing that was currently captured, and I looked for gaps when packages didn’t perform…
Read More PowerShell Management for Your SSIS PackagesNow that you’ve completed analyzing your current database, and worked through that list of items that won’t work with Windows Azure SQL Database (WASD), it’s time to begin testing your new solution. Testing begins with setting up your test instance of WASD, and loading your test data, then you point your application to that new…
Read More Migration to Windows Azure SQL Database:Step 4 and 5Last time I walked you through how to see if your database will work with Windows Azure SQL Database (WASD) using the Migration Wizard on Codeplex. It’s an easy tool to learn to use, and it answers the question what won’t work if I migrate to SQL Azure. It will even help you perform the…
Read More Migration to Windows Azure SQL Database: Step 3b