Questions tagged with Microsoft SQL Server

We are migrating the on-premises SQL server databases to AWS RDS SQL server. The source database have table partition. I am assuming RDS SQL Server 2019/2022 standard edition supports the table...

Good day. I have a question. I have an EC2 server with SQL Server, and everything works well. However, when I try to connect using Heidi, for example, I do it like this: server name/instance name, and...

I'm using a SQL Server on-prem source for a DMS to replicate to a SQL Server RDS. Every night, at about midnight, I'm seeing a spike of ~1.6M CDC incoming changes on my DMS task, but nothing is making...

Hi Team, We are planning to migrate the SQL Server Agent jobs to AWS RDS SQL Server and while going through the Agent related roles, i get to know we don't have similar permission as MS SQL Server....

This blog post "https://aws.amazon.com/blogs/apn/how-helecloud-used-aws-secrets-manager-to-automate-credentials-rotation-of-ms-sql-on-amazon-ec2/" describes a solution for automating credential...

We recently migrated our on prem SQL server 2008 R2(8 CPU 16 GB RAM) to EC2 (r5.4xlarge - 16 CPU 128 GB RAM) 2019. The server is very slow, all the queries are slow. We can see CX_PACKET wait being...

Greetings, We have been using only MS-CDC for ongoing replication and had the ECA IgnoreMSReplication turned on. In order to determine the feasibility of using MS-REPLICATION as an alternative some...

IHAC using RDS MSSQL instances, now he is planning to install SQL Reporting Services in its application server running on EC2 (because SRS needs some customizations, cannot activate it using RDS...

Greetings, an error has been encountered that has not been seen before. I could not find anything on google so I am hoping someone here can help. This happens when we start a new DMS task. Source...

I received an email from one of our customers regarding their international locations where they are running databases on IaaS. Currently, they are storing the Transparent Data Encryption (TDE)...

Hi Everyone! We are analyzing the performance and the index needs for all tables of a RDS SQL Server instance, we are using a T-SQL script pretty similar to the one shown in...

I recently completed a migration using AWS Database Migration Service (DMS) from a source MSSQL DB on RDS to a target PostgreSQL DB on RDS. The full load process completed successfully, but I noticed...