Author: Vikas Babu Gali

SQL Server professionals manage critical database systems that power enterprise applications, from financial platforms to ecommerce systems. Their responsibilities include optimizing query performance, managing schemas, ensuring high availability, and troubleshooting complex issues. With the advancement of Artificial Intelligence (AI), businesses are redesigning their workflows, enabling AI to independently complete tasks and achieve business goals. Customers […]

AWS has helped hundreds of thousands of customers transition their SQL Server workloads to the cloud since 2008, longer than any other cloud provider. Running business-critical applications often requires Microsoft SQL Server databases to be highly available. Customers choosing to use SQL Server for their mission-critical workloads can achieve high availability by deploying SQL Server […]

In this blog post, we will guide you through the process on performing a snapshot backup using native T-SQL based backup abilities and snapshot technology of Amazon FSx for NetApp ONTAP (FSxN). This method provide near-instant, consistent backups with negligible I/O, storage and compute capacity impact unlike traditional Microsoft SQL Server backups. Introduction Microsoft SQL […]

In this blog post, we will extend the analysis of the Optimize CPUs feature provided in a previous publication to other Amazon Elastic Compute Cloud (Amazon EC2) instances suitable for deployment of Microsoft SQL Server workloads on the Amazon Web Services (AWS) Cloud. Amazon EC2 now allows customers to modify an instance’s CPU options to […]

In this blog post, I will share details on the new AWS Launch Wizard application programming interface (APIs) that allow programmatic deployment for Microsoft SQL Server workloads. This new API release helps you integrate AWS Launch Wizard with existing deployment tools. Introduction The AWS Launch Wizard service guides customers through the sizing, configuration, and deployment […]

In this blog post, we will show you how to configure AWS Migration Hub Orchestrator using the recently-launched support for transactional log backups to reduce downtime during Microsoft SQL Server database migrations to Amazon Web Services (AWS). Customers worldwide trust AWS to run their mission-critical SQL Server databases. For SQL Server databases that are still […]

Always Encrypted with secure enclaves is an encryption technology available in SQL Server 2019, which allows rich computations on encrypted data. With increased focus on data protection, this feature helps customers to protect sensitive data, such as credit card numbers or national identification numbers (for example, U.S. social security numbers) stored in SQL Server databases. […]