Questions tagged with Microsoft 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.
AWS SCT for SQL RDSlg...
Hi Team,
I have done some Assessment reports for SQL server to RDS SQL Server and in reports everything is green but when iam connected to Target and applied the database to RDS SQL server, i am...
1
answers
0
votes
397
views
asked a year agolg...
Hello,
We are looking at using one of the AWS supplied AMI's with SQL Server 2022 Standard included. We also have a need to install older versions of SQL Server to extract data and possibly install...
1
answers
0
votes
549
views
asked a year agolg...
We recently upgraded SQL Server from 2016 to 2022 and we had DMS tasks with CDC that was using SQL Server as a source. These tasks are now failing and if I point the endpoint to the SQL Server 2016,...
3
answers
3
votes
783
views
asked a year agolg...
I have two DMS tasks which load to the same table (both source and target are SQL Server 2017) with different filters - the task that succeeds has this filter:
```
"filters": [
...
1
answers
0
votes
950
views
asked a year agolg...
I have created a new SQL user on an RDS (Not custom) database with :
`USE master;
GO
CREATE LOGIN my_user WITH PASSWORD = 'my_password';
GO`
And now I want to assign roles to them (dbcreator,...
2
answers
0
votes
1572
views
asked a year agolg...
Hi,
We have one Windows instance with AWS cloud and our SQL Server is installed on this windows instance.
We want to connect to the SQL Server on AWS Windows instance from our work computers but...
2
answers
0
votes
523
views
asked a year agolg...
We have been able to connect to a Microsoft SQL Server DB using both Glue's DynamicFrame and Spark's own JDBC write option due to the Glue connection option.
However, we want to move this workload to...
1
answers
0
votes
695
views
asked a year agolg...
I need to create an RDS SQL Instance with a time zone that is tolerant of UK daylight savings changes. From the RDS documentation, I can see there is a time zone called "GMT Standard Time" that is...
1
answers
0
votes
439
views
asked a year agolg...
**• Can I query the region from within the SQL Server itself?**
Anything like rdsadmin.dbo.rds_show_configuration that include instance specs?
I have an SP that is clearing all backup tables from...
1
answers
0
votes
361
views
asked a year agolg...
I have set up the DMS fleet advisor and ran the recommendations for the SQL server. It gave me Target recommendations. but I have confused about target recommendations.
1. Initially I ran the...
1
answers
0
votes
303
views
asked a year agolg...
Do we have any clue about when it will drop?
From what I can see Microsoft released 2019 early November 2019 and then AWS announced RDS support late August 2020 so almost 10 months delay.
I can't...
Accepted AnswerMicrosoft SQL Server
8
answers
1
votes
1698
views
asked a year agolg...
I have tried various options of Disaster Recovery options for SQL Server. There are two parts to This
FULL BACKUPS and then On-going Replication
1. Back Up and Restore - Took Automated backups...
1
answers
0
votes
947
views
asked a year agolg...