×
SQL Server

SQL Server (MSSQL) Migration to PostgreSQL Timestamp

The article describes how to track the storage records for insert and update timestamps in PostgreSQL using the Virtual columns and Trigger tracking methods.

Migrate SQL Server and SSIS Workloads with Active Directory (AD) Integration to Alibaba Cloud: Part 2

This article shares the best practice on your SQL Server and SSIS's cloud migration to Alibaba Cloud with active directory (AD) integration.

Migrate SQL Server and SSIS Workloads with Active Directory (AD) Integration to Alibaba Cloud: Part 1

This article shares the best practice on your SQL Server and SSIS's cloud migration to Alibaba Cloud.

Real-time SQL Server Migration to Alibaba Cloud ApsaraDB RDS for SQL Server

In this tutorial, we'll show you how to migrate an on-premises Microsoft SQL Server to Alibaba Cloud ApsaraDB for SQL Server with minimal downtime.

How to Install and Configure the Windows Server Failover Clustering on an ECS Instance

In this tutorial, we will show you how to prepare your remote cloud and deploy Windows Server Failover Clustering (WSFC) on an Alibaba Cloud Elastic Compute Service (ECS) Instance.

Implementing SQL Server AlwaysOn Groups on Alibaba Cloud ECS Instances

The SQL Server AlwaysOn group features a high-availability and disaster recovery solution. The Alibaba Cloud ECS allows you to load applications with .

High-Performance RDS from Alibaba ApsaraDB

Alibaba Cloud offers services from data centers in APAC, North America, the Middle East, and Europe. In this article, we introduce ApsaraDB for RDS, which is available with MySQL, SQL and PostgreSQL.

Troubleshooting RDS Performance (MySQL, SQL SERVER and MongoDB)

Alibaba Cloud ApsaraDB for RDS source code team is continually making optimizations to MySQL. Both performance and stability are higher than in the co.

RDS Best Practices — Fast and Stable Migration to RDS

There are two methods to migrate data to RDS: migrating data to RDS–MySQL by using the MySQL dump tool and migrating data to RDS–SQL Server by using the SQL Server client tool.

Hosting ASP.NET Web Data App with Microsoft SQL Server on Alibaba Cloud

In this article, we will learn how to create a Windows-based ECS server to run .NET web apps with SQL Server.

SQL Server Best Practices: Using Asymmetric Keys to Implement Column Encryption

In this article of the SQL Server best practices series, we will learn how to solve common security problems with symmetric encryption by using asymmetric keys.

Deploying Cross-AZ Windows Server Failover Clustering (WSFC) in Alibaba Cloud

In this tutorial, we will show you how to deploy Cross-Availability Zone (AZ) Windows Server Failover Clustering (WSFC) on an Alibaba Cloud Elastic Compute Service (ECS) instance.

How to Install and Configure SQL Server AlwaysOn on an ECS Instance

In this tutorial, we will set up the SQL Server AlwaysOn environment and create a SQL Server AlwaysOn availability group on an Alibaba Cloud Elastic Compute Service (ECS) instance.

Using Python to Connect Function Compute to SQL Server

This document explains how to use SQL Server databases with Alibaba Cloud Function Compute as well as configuring and verifying Function Compute based on fc-docker.

Deploying WSFC and the SQL Server Failover Cluster on Alibaba Cloud ECS

In this tutorial, we will deploy a SQL Server high availability (HA) solution with WSFC and the SQL Server Failover Cluster on an Alibaba Cloud Elastic Compute Service (ECS) Instance.

Windows and SQL Server 2008 Support Expiring in 2020: Threat or Opportunity?

Learn how you will be affected by the end of Windows and SQL Server 2008 support in 2020, and how you can future-proof your infrastructure through containerization.

Row-level Security Solutions for MSSQL

In this tutorial, you will learn how to implement data access control solutions using the new Row Level Security feature introduced by SQL Server 2016.

Mask Privacy Data Columns in MSSQL

In this tutorial, you will learn how to use the dynamic data masking feature of SQL Server 2016 to mask privacy data.

Enable SSL Encryption for an MSSQL Network Transport Layer

In this tutorial, you will learn how to enable SSL encryption for the network transport layer of your SQL Server.

Enable Always Encrypted for Your MSSQL Databases

In this tutorial, you will learn how to enable Always Encrypted to ensure that the data stored in your SQL databases on the cloud is continually encrypted.