Amazon RDS - Configuring a Connection to a SQL Server Instance
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-23 (first published: 2022-11-21)
38 reads
Kenneth Igiri
- Interests: Creative Writing, Small Business, Apologetics
- Skills: Database Management, Data Management, Leadership, Management, Design Thinking
- Website: https://kennethigiri.com
Amazon RDS - Configuring a Connection to a SQL Server Instance
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-21
1,838 reads
10 Considerations for a Database Migration to AWS RDS
This article includes 10 things that you should consider when migrating to the cloud, with an example using RDS that explains how these are applied to an actual database being created.
2022-10-26
2,781 reads
PerfMon: Using SQL Server Performance Counters
Learn how you can use Windows Performance Monitor and the PAL to gather metrics from your SQL Server instances.
2022-07-20
4,578 reads
Dealing with Transaction Log Growth
Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reliably. The typical DML command used in SQL are INSERT, UPDATE and DELETE. When INSERT introduces new […]
2022-06-13 (first published: 2022-06-10)
4,311 reads
7 DB Forge SQL Studio Features Discovered in Less Than 2 Hours
dbForge SQL Studio gives you a few advantages over SSMS. See what Kenneth discovered during his first use of the tool.
2022-04-27
4,252 reads
Cloud Computing Basics - Achieving High Availability
Learn about high availability in the cloud at a conceptual level.
2022-03-28
1,316 reads
Cloud Computing Basics - Achieving High Availability
Learn about high availability in the cloud at a conceptual level.
2022-03-28
291 reads
SQL Server on Amazon RDS vs SQL Server on Amazon EC2
Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.
2020-09-18 (first published: 2018-04-12)
16,106 reads
Database Snapshot Use Case: Service Migration
In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.
2020-08-28 (first published: 2018-12-11)
2,325 reads
Blogs
Automatically Take Missed Backups with Ola Hallengren’s Scripts
I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance...
SQL Server 2022 is GA!
By James Serra
The big announcement at the PASS Data Community Summit 2022 was that SQL Server...
Tell My Story of Public Speaking
This month the fine folks behind New Stars of Data and the DataGrillen Newcomer...
Forums
Backup progress
We have started the full backup job that uses Veritas netbackup. The server has...
Join query with many tables
Hi guys, I hope everyone's ok I have a query in MySql (I'm using...
Mass update on Clustered Columnstore indexes
Hi, we have a FACT table with 35 billion rows, partitioned on daily level....
Ask SSC