# Notes

This tool provides a Physical interface to click & start build on Teamcity. This is plug and play device. Checkout video here:  https://youtu.be/srnu6uvvWT0 Items required to build this tool :- 1 Arduino Uno Micro-controller board 1 USB Cable 2 LED 1 On-Off switch 1 Push button Building circuit  I used a online website to build my buffer circuit. Follow this link :- https://123d.circuits.io/circuits/1659445-teamcity-trigger Programming micro-controller  Programming micro-controller is extremely easy. It is programmed in C language using Arduino IDE. github url for project : https://github.com/luckgagan/OneclickDeploymentTool C code has to part 1st is Setup & 2nd is Loop. int InputPin = 13; void setup() {   // put your setup code here, to run once:   Serial.begin(9600);   analogReference(INTERNAL); } Setup code is initializing serial with baud 9600. This part executes once. another part is l...

Queries to rename database in SQL Server :- Step 1: Enable Single user mode on database  ALTER DATABASE database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE Step 2: Change database name  ALTER DATABASE database_name MODIFY NAME = New_database_name Step 3: enable multi user mode on database  ALTER DATABASE New_database_name SET MULTI_USER WITH ROLLBACK IMMEDIATE Its done :) 

Configuring git on ubuntu machine is extremely easy. First we would need to install git on the same machine. Step 1: Install git on the machine apt-get install -y git Step 2: In case git is already installed, check git settings git config --list Step 3: Update git config file git config --global user.email "luck.gagan@gmail.com" git config --global user.name "Gagan" Step 4:  Initialize a git repo mkdir GitSample cd GitSample git init Step 5: Add content to git repo for commit git add -A Step 6: Commit your changes git commit -m "First commit" Step 7: Add your repo to remote. (I have used github) git remote add origin https://github.com/luckgagan/gitsamplerepo.git Step 8: Push git push -u origin master ********************************You are done****************************