Elements of the SQL Server Update Statement
Learn how to use the UPDATE statement, along with a few things to be aware of when changing data.
2025-04-11
1,426 reads
Learn how to use the UPDATE statement, along with a few things to be aware of when changing data.
2025-04-11
1,426 reads
See a walkthrough of setting up a maintenance plan in SQL Server.
2025-02-21
1,358 reads
See a first look at Azure Data Studio from Kenneth Igiri and read about his impressions.
2023-11-13
4,051 reads
This article will show how to use the Azure Cloud Shell and PowerShell to set up a new Azure SQL Database.
2023-07-07
1,244 reads
This article looks at security mechanisms in the cloud that can help protect your data, with specific examples in AWS.
2023-04-14
1,364 reads
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)
863 reads
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,315 reads
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
3,055 reads
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)
358 reads
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-21
2,986 reads
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
I need to update greatherthan8 (category) record to Missing (status) if the same member...
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Hi everyone I am looking at the size of my db on disk (ie...
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers