fbpx

SQL Server Azure walk-through and basics

When starting your journey to the Microsoft cloud, understand features, strategies and pricing models first. Below we have a number of resources our clients find useful when first building their road maps.

Videos

Migrating Databases to Azure recorded at Austing SQL Saturday in 2018.

Executing your Migration to Azure

Congrats, you’re ready to start migrating! There are a number of different ways you can move data from your on-premises application to Azure. Picking the right strategy and project plan will secure your data and reduce (or completely eliminate) downtime.

Here are a few articles we love to share to get you familiar with the paths we find most successful.

Tuning for Performance and Availability

More modern versions of SQL Server makes automating and tuning easier and more intuitive, but you’ll still need to review your TSQL for many things. Below we give you tips and tricks for tuning in Azure.

After Your Migration

With a migration project complete, you can focus on monitoring and maintenance. This of course depends on how much work you did before moving your data. Below are resources our clients found incredibly helpful with building their maintenance timeline plans.

Additional Resources

Learn from Microsoft’s Data CAT

Tools and Services

Data Migration Assistance is used to test and help migrate your databases.

Load test your applications with Visual Studio. This allows you to stress performance tiers with your own code.  You can also use this interesting tool to Test a production workload against Azure SQL Database.

Azure DTU Calculator is a helpful starting tool for finding the sweet spot for finding your initial performance tier.

Database Migration Service will allow Microsoft to help you move your data.

Contact us if you need Cloud Migration support

Get started