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,553 reads
Learn how to use the UPDATE statement, along with a few things to be aware of when changing data.
2025-04-11
1,553 reads
See a walkthrough of setting up a maintenance plan in SQL Server.
2025-02-21
1,591 reads
See a first look at Azure Data Studio from Kenneth Igiri and read about his impressions.
2023-11-13
4,062 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,254 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,377 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)
868 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,321 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,085 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)
363 reads
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-21
3,030 reads
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
By Kamil
🔍 The Challenge: DevOps for Microsoft Fabric In the world of Microsoft Fabric, DevOps...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
We are in the process of upgrading to SQL Server 2022 and would like...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers