How to Migrate On-Premise SQL Servers to Azure SQL Database Azure SQL Database is a fully managed service that allow you to focus on rapid app development and accelerate your time to market, rather than allocating precious time and resources to managing virtual machines and infrastructure. Azure delivers predictable performance at multiple service levels that
Microsoft SQL Server Migration Strategies to Amazon AWS Let’s assume that you have a SQL Server workload on Premises and want to take those to the cloud. You have two options for SQL Server for migrating to Amazon AWS. The first option is a self-managed option which would be installing SQL Server on EC2
Migrating Microsoft SQL Server to Amazon AWS RDS RDS is a managed database service that will do all the heavy lifting that you normally must do if you’re managing instances and databases yourself on on-premises SQL Server. It automates common database administration tasks like: Backup and restore Scaling Patching Upgrading the server High availability Failover
SQL Server Replication Performance Tuning What can be done when SQL Server Replication is slow. A lot of SQL Server Replication users think, SQL Replication that gets created with SQL Wizard – is all you can do. But there is a ton of knobs you can turn. How do I know there is MANY people
SQL Server MASSIVE Index Tuning Example Speed improved by 41,925% We often do massive SQL index tuning change. It usually happens, when server hasn’t had tender care for a while. And its ripe for a ton of SQL indexes changes. What index changes do we make: 1. adding missing indexes. 2. dropping unused indexes. 3.
6 ways to encrypt data inside SQL Server [in 2019] We recently got a question from someone about how to encrypt large SQL Server database for compliance reasons with minimal impact on software applications. There are number of ways to approach SQL Server data encryption. For compliance or whatever the purpose. Conclusion: using combination of