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.
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
1464
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
485
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
653
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
398
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
327
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
280
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
1654
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
892
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
229
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
1582
views
asked a year agolg...
I have hosted an AWS Managed MS Active Directory and joined to AWS RDS SQL Server to the AD Domain.
Option -1 : Create a SQL login for each user and ask the user to login to the SQL server with new...
1
answers
0
votes
261
views
asked a year agolg...
The SQL Server instance on an EC2 server was pre-installed by AWS, but when attempting to patch the installation, the process fails due to an attempt to download Python and R from third-party sites,...
1
answers
0
votes
276
views
asked a year agolg...