Questions tagged with Microsoft SQL Server

The proven, reliable, secure cloud for SQL Server

Content language: English

Select up to 5 tags to filter
Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

I already setup AWS SQLServerLambdaConnector connect with SQL Server on-premise - I access my sqlserver database on-prem and do some sql queries: create database antsomi; go use antsomi; go CREATE...
1
answers
0
votes
18
views
asked 12 hours ago
We have a DB running on normal ec2 instance but that is not sufficing our needs so we need to upgrade to web edition. Can we perform OS upgrade to web edition as this ec2 has an application as well...
1
answers
0
votes
28
views
asked 14 days ago
After installing the new rds-ca-rsa2048-g1 certificate on our RDS Server, I get the following error in Microsoft Sql Server Management Studio (version 20.2) when I try to connect with Encryption set...
2
answers
0
votes
139
views
asked 23 days ago
We are replicating specific tables from a SQL Server source to an RDS MySQL destination using AWS DMS. The DMS task is configured with a sysadmin role for the DMS database user. It was later reported...
1
answers
0
votes
147
views
asked 24 days ago
We are planning to migrate the SSAS services to RDS SQL server. What are things we need to consider before decide the target( EC2/RDS) How to migrate the SSAS services to RDS SQL Server...
1
answers
0
votes
283
views
asked a month ago
Hi, I have a question, is possible than RDS Custom for SQL with license Enterprise support Always On for high availability, because we need read replicas of this database. If the answer is not, what...
2
answers
0
votes
216
views
Manuel
asked 2 months ago
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...
1
answers
0
votes
212
views
asked 2 months ago
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...
1
answers
0
votes
253
views
tnk
asked 2 months ago
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...
1
answers
0
votes
294
views
Brent
asked 3 months ago
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....
2
answers
0
votes
448
views
asked 3 months ago
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...
1
answers
0
votes
358
views
Adit
asked 3 months ago
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...
3
answers
0
votes
552
views
Kaja
asked 4 months ago