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.
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
766
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
932
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
1534
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
514
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
684
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
427
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
351
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
297
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
1691
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
931
views
asked a year agolg...
Hi , Have a multi-subnet SQL Server FCI with Data \ Log files on FSx for Windows File Server. How do I enable Instant File Initialization ( Perform Volume task Maintenance ) in this ?
2
answers
0
votes
245
views
asked a year agolg...
I have a Windows_Server-2019-English-Full-SQL_2022_Standard-2023.03.15 running on an EC2 instance as a source for DMS to be migrated to S3 target. I am using RDP to connect to the instance and SSMS to...
1
answers
0
votes
1738
views
asked a year agolg...