awssecurity tip_of_the_day, iam

AWS is a very critical service for businesses and enabling a 2nd factor authentication would be very helpful to increase security.

Step 0: Install Google Authenticator or a similar OTP generator tool on your mobile device.

Step 1: Logon to your account and select Security Credentials from the menu on the upper right corner. Then click on Activate MFA button. AWS MFA Step 1

Here you have two options. You can choose to use a hardware device if you choose to purchase one from Amazon. At the time of this writing the price on Amazon was $12.99 so it’s also an affordable option. I decided to use Google Authenticator because it was already installed and active on my phone and I didn’t want to manage another piece of hardware.

Step 2: It will display a QR code which you can scan using Google Authenticator. Once the scan is completed you will need to enter 2 consecutive numbers the device generates. Once the device is synchronized it will be ready to use. You can verify it by checking its status:

AWS MFA Step 2

Step 3: Log out and log back in to see the results. After the password screen you should see an additional screen asking for the authentication code.

AWS MFA Step 3

Resources

aws tip_of_the_day, s3

If you are working with large files, transferring them to S3 correctly might be an issue. To ensure data integrity you can send the MD5 hash of the file in Content-MD5 header.

After the transfer S3 compares the MD5 value of the transferred file with the value you provided. If they don’t match it returns an error. This is an easy and great way to ensure the file has been uploaded safe and sound.

Resources

dev tip_of_the_day, sql_server, ssms

The feature exists but a bit buried away. To create insert statements for table(s):

  1. Right click on the database and go to Tasks -> Generate Scripts
  2. Select the tables that you want to generate the script
  3. In “Set scripting options” page click on the Advanced button
  4. Under the General category, locate “Types of data to script”. It contains 3 options: Data Only, Schema and Data, and Schema Only. Default is Schema only,if you select an option with data in it you can get the data with the insert statements.

Generating Insert Scripts With SSMS