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 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
486
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
1431
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
439
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
89
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
981
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
539
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
625
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
450
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
391
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
3627
views
asked a year agolg...
Hi,
We are evaluating to migrate our dot net framework based application using the SQL server as data base to AWS cloud.We are evaluation the RDS for SQL server as possible option for database ,...
1
answers
0
votes
1146
views
asked a year agolg...
Is it possible to set up PrivateLink connection to SQL Server running in another AWS account's VPC?lg...
I have VPC-1 and VPC-2 in different AWS accounts. Both VPC's have private and public subnets.
VPC-1 has IIS and SQL servers running on the same EC2 Win Server in private subnet. I set up Endpoint...
1
answers
0
votes
570
views
asked a year agolg...