Yearly Archives: 2020

LoadWithPartialName [reflection.assembly]::loadwithpartialname(“Microsoft.SqlServer.Smo”) | out-null pipe with out-null to avoid output. New-Object $srv = New-Object (‘Microsoft.SqlServer.Management.Smo.Server’) pipe with gm (get member) sidebar: $a = dir $a will display directory now if we do $a | gm it will have properties for directory. Like move to, Extension, Encrypted etc. $srv = New-Object […]

SQL Server SMO in PowerShell

This entry was posted in My Bits and Bytes on
Download GIT from https://git-scm.com/downloads To ensure GIT is installed on the machine type following on command prompt. It should show you version: GIT –version Set your Name and Email for GIT using following commands: git config –global user.name “YourName” git config –global user.email “youremail@somedomain.com” To verify the configuration, type git […]

Configuring GIT

This entry was posted in My Bits and Bytes on
Creating a bucket in IAM: NOTE: IAM Screen for creating a new bucket has completely changed. Old Screen: Above options are not in new IAM interface. Configure Options: Old: New: Navigate inside a bucket Created 2 folders in the bucket Upload a file inside images folder: By default only owner […]

S3 Basics

This entry was posted in My Bits and Bytes on
RDS = Relational Database Service What is a database? Non Relational Database DynamoDB (No SQL DB) Data Warehousing OLTP vs OLAP RedShift (Amazon’s OLAP) Elasticache Webservice that makes it easy to deploy, operate and scale an in-memory cache in the cloud. improves the performance of web-applications by retrieving data from […]

RDS Basics

This entry was posted in My Bits and Bytes on
EC2 = ECC = Elastic Compute Cloud A web service that provides resize able compute capacity in the Cloud. It reduces time required to obtain and boot a new server instance to minutes, allowing scale capacity up or down based on changing requirements. >> Pay for capacity you use. Unlike […]

EC2 Basics

This entry was posted in My Bits and Bytes on
Identity Access Management – IAM Controlling Users (end users), Groups (collection of users with same permissions, Roles (Can be assigned to resources), Policy (a document that define one or more permissions. Can be assigned to user, group or roles) Identity Federation (Active Directory, Facebook, LinkedIn) Multi-Factor authentication Temporary access for […]

IAM Basics

This entry was posted in My Bits and Bytes on