Data Oriented Cloud Security Mechanisms
This article looks at security mechanisms in the cloud that can help protect your data, with specific examples in AWS.
2023-04-14
775 reads
Kenneth Igiri
- Interests: Strategy, Small Business, Creative Writing
- Skills: Database Management, Data Management, Leadership, Management, Design Thinking
- Website: https://kennethigiri.com
Basic Checks on a New AWS RDS SQL Server
When you first become responsible for a new RDS instance, what do you do? Kenneth Igiri gives you a few queries to get you started.
2022-12-14 (first published: 2022-11-30)
555 reads
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
1,748 reads
Basic Checks on a New AWS RDS SQL Server
When you first become responsible for a new RDS instance, what do you do? Kenneth Igiri gives you a few queries to get you started.
2022-11-30
2,259 reads
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)
150 reads
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
2,399 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
3,138 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
8,838 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,892 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,366 reads
Blogs
Migrating from EverNote to Joplin
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Forums
Database copy issue through - COPY DB WIZARD
I have a production server with SQL server 2016 version (13.0.5026.0) and a database...
Help with a SQL Unpivot
I am trying to use unpivot to extract some data, however, the results are...
how to de escalte a isolation level, and are there any implications.
hi, I have one nested transaction and want to deescalate to outer transaction's isolation/...
Ask SSC