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,595 reads
Learn how to use the UPDATE statement, along with a few things to be aware of when changing data.
2025-04-11
1,595 reads
See a walkthrough of setting up a maintenance plan in SQL Server.
2025-02-21
2,312 reads
See a first look at Azure Data Studio from Kenneth Igiri and read about his impressions.
2023-11-13
4,079 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,274 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,395 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)
878 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,333 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,130 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)
380 reads
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-21
3,052 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Hi, our peer who owns a remote mysql server from which we extract warehouse...
What is returned as a result set when I run this command without a new seed value?
See possible answers