PowerShell Commands to Administer Virtual Machines on Amazon AWS - Part 2
Learn about various PowerShell commands that can be used to administer virtual machines on Amazon AWS.
2023-12-04
AWS
SQL Athena Introduction - How it works, Use Cases and Advantages
Learn about Amazon Athena, how it works, why you would use it, and some of the advantages of Athena over traditional relational databases.
2023-10-09
New Amazon X2iedn High-Memory Instances
Amazon just announced new X2iedn instance types for Amazon RDS SQL Server. They’re a sweet deal for people who want a high-performance managed database, with really fast cores and more memory per core than you can get in Azure’s managed SQL offerings.
2023-10-04
Upserts in Amazon Redshift
This article discusses different approaches of Upserts (update+inserts) in Amazon Redshift
2023-08-09
30,413 reads
A Overview of Amazon Redshift
This article gives an overview of Amazon Redshift, the cloud data warehouse in AWS.
2023-07-24
25,631 reads
Demystifying Best Practices and Enhancing RDS security with Amazon GuardDuty
This article looks at four security best practices for protecting databases in AWS along with how GuardDuty can be used to provide additional security.
2023-05-17
1,430 reads
AWS Lambdas with C#
In this article, I will take you through the development process of building an API on the serverless cloud with C#. This API will be built to serve pizzas, with two endpoints, one for making pizza and the other for tasting fresh pizzas. I expect some general familiarity with AWS and serverless computing. Any previous experience with building APIs in .NET will also come in handy.
2023-03-08
Amazon EC2 | Creating a Connection to an Amazon RDS Instance
In a previous article, we showed how to expose an Amazon RDS instance to the public internet securely for direct access to the database. In this article we shall configure an Amazon EC2 instance for network access to an existing Amazon RDS instance. The purpose of this would be to make sure that if we deploy an application to this EC2 instance, communication from the client to the RDS instance would be smooth.
2022-12-05
2,372 reads
Steps to Quickly Configure an AWS RDS SQL Server instance
Learn how to configure and deploy a new Amazon AWS RDS SQL Server instance with this step-by-step article.
2022-10-14
Custom SQL Server on RDS
SQL Server on RDS has a more configurable option that allows you to meet the specific requirements of your application in a similar was as you would on-premises, while still being a managed service.
2022-09-21
206 reads
Blogs
A New Chapter: Why I Made the Move from Dayforce to ESO
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
Lean Six Sigma – Brief
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
T-SQL Tuesday #200: Bad Query signals
NO AI was used to generate this content. Grammarly was used to check and...
Forums
Reading Parquet using openrowset
Hi, We are looking out to read parquet file directly from on premise shared...
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers