How to Migrate SQL Servers to Azure SQL Database

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

Read More »

Microsoft SQL Server Migration Strategies to AWS

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

Read More »

Migrating Microsoft SQL Server to Amazon AWS RDS

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

Read More »

SQL Server Replication Performance Tuning

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

Read More »

Encrypt data stored inside SQL Server

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

Read More »