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 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
243
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
499
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
1474
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
450
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
1021
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
548
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
636
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
460
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
397
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
3675
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
1161
views
asked a year agolg...