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 are trying to add 2 calculated field in custom SQL dataset which is given below but values not showing in dataset
----------------------------------------
1st is - **AsilePrice**
sumOver
(
...
Hi Team,
Can you please share T-SQL to verify the backup details using headeronly option in restore.
Has anyone connected an Azure Web API to an AWS SQL Server?
I'm trying to determine why my Azure Web API isn't able to communicate with my new AWS SQL Server database. I previously was connected...
I am working on SQL server to Aurora postgres migration and wondering if there is a way to automate this process?
I am able to generate script after setting up source and target DB, but when I...
Hi Team,
I am migrating the data on-prem to AWS cloud, using AWS DMS service, while migrating the data i am facing the below issue.
Source : MSSQL Server (On-Prem)
Target : AWS MySQL RDS
```
Last...
Hello folks,
I´m getting troubles with my DataBase SQL Server, I´m using a t2.micro and a basic query with inner join between 2 tables is taking 25sec for 250 rows. No WHERE clause is being used and I...
What metrics or information is necessary to collect in order for the CloudWatch Agent to publish metrics to CloudWatch for an EBS volume partitioned into two Instance Stores for tempdb's with SQL...
Hi AWS, I was trying to deploy a CI/CD pipeline for MS SQL 2022 using GitHub Actions on Amazon RDS. Here is the code repo: https://github.com/arjungoel/sql-cicd-poc. Having said that I was trying to...
I have successfully restored an RDS snapshot, and AWS has generated the instance in my RDS list. However, I am encountering difficulties connecting to the database from SQL Server Management Studio as...
Hi AWS, I have to build the CI/CD pipeline for the database schema running on Amazon Hosted RDS SQL Server 2022. I have a couple of questions for the same:
1. The cluster is not publicly accessible,...
Hi All,
We have allocated 100 GB storage to RDS, and max storage size is 150 GB. do we change to 100 GB or 150 GB?
Hello, We have around 10 databases and planning to migrate to RDS SQL Server(2 RDS). currently we have 4 CPU and 16 GB RAM. How to decide the right sizing for RDS instance . do we have any queries to...