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 an RDS instance, with MS SQL Server database.
I need to grant permissions to a user in my application to execute some important procedures.
However, even connected to the RDS instance with the...
1
answers
0
votes
560
views
asked a year agolg...
We should upgrade the standard Microsoft sql server instance from 2017 version to 2019 version.
What is the best procedure to follow in order not to lose data
1
answers
0
votes
245
views
asked a year agolg...
I have an AWS RDS Mssql and On-premise Mssql, Both servers have 4 CPUs and 16 Memory. Both servers have the same data in the table about 700k records.
When the exec query selects 1000 records...
3
answers
0
votes
504
views
asked a year agolg...
I am trying to use DMS to capture change logs from the SQL server and write them to S3. I have set up a long polling period of 6 hours on MSSQL CDC Capture job. (AWS recommends > 1 hour). DMS fails...
2
answers
0
votes
1505
views
asked a year agolg...
Hi,
May I please know if I deploy a SQL Server Enterprise Edition on my AWS Account, how may licenses will I need?
***Is the number of license required same as vCPUs of the EC2 instance?***
For eg....
3
answers
0
votes
452
views
asked a year agolg...
I am trying to migrate data from an on prem SQL Server DB to Postgres Aurora using AWS DMS. The data migrates just fine, but for tables that have a boolean column in the primary key, during validation...
0
answers
0
votes
91
views
asked a year agolg...
I am running a large pandas merge join operation on a `jupyter` notebook running on `SageMaker` notebook instance `ml.t3.large` i.e `8 gb` of memory.
```
import pandas as pd
df1 =...
1
answers
0
votes
1035
views
asked a year agolg...
We are using SQL Server RDS and looking to implement full-text search. We need to search on a variety of file types but mainly on pdf. My understanding for pdf there is an Adobe iFilter plugin that...
1
answers
0
votes
551
views
asked a year agolg...
We are using windows server. On that windows server we have SQL server installed. We are planning to upgrade that to SQL 2022. Now I want to know the feasibility to move databases to S3 bucket. Is it...
2
answers
0
votes
641
views
asked a year agolg...
Hi,
I have an old SQL Server Web Edition (14.00.3381.3.v1) in storage-full state. What would be the best way to resolve this situation?
I have tried to follow e.g. guides:
* [How do I resolve...
1
answers
0
votes
462
views
asked a year agolg...
A customer has a RDS database and Windows Forms client application. He want to create a new client app. What is the best solution?
Client->REST API Lambda ->(Cognito)->RDS
or may be
Client->REST API...
1
answers
0
votes
401
views
asked a year agolg...
I have a Flask Application running locally and there is using `pymysql` to query a `MySQL` DB hosted on AWS RDS. After the application has been idle for a few minutes (>5), I get an error: ` Lost...
1
answers
0
votes
3691
views
asked a year agolg...