This is generic Error Handler I use for my Adhoc Scripts as Well as functions, stored procedures,etc. — Adding the error message. USE master; GO EXEC sp_addmessage 50001, 16, N’The Record doesn”t exist. Parameter : %s , Value : %s’,@replace=’Replace’; GO — Standard Variables Declarations …
PHP Drivers for MSSQL Issues
PHP Drivers for MSSQL Issues I wanted to setup my Mac Book Pro to access the SQL Server RDS Instance on AWS.My intial thinking was just google on how to setup PHP Drivers on Mac OSX and follow the steps. So I thought it shouldn’t …
SQL Script Header Footer I use
SQL Script Header Footer I use : /****************************************************************************************************** ** Desc: This File will create the XXXXXXXXXXXXXXXXXXXXXXX . ** Auth: Raju Venkataraman ( i90runner@gmail.com ) ** Date: 09/21/2014 Created ************************** ** Change History ************************** ** CR Date Author Description ** —– ———-– ———– ———————————————————— ** 1 …
Checklist for SQL Server Installation
Feature Selection : We don’t want to install all the features. Identify the features needed and install only those features. Model Database Properties : Figure out all the Model database Properties and configure them Correctly. File Layout : Make sure Data and log files are …
Helpful Linux Commands
Helpful Linux Commands Find whats on port running on a particular port : ex port 8098 $ sudo netstat -apn | grep 8098 tcp 0 0 10.224.35.187:8098 0.0.0.0:* LISTEN 19666/beam.smp Find status of a particular process : ex status of riak $ sudo /etc/init.d/riak status …
Git Cheat Sheet
Git Quick Reference Adding the ShortCut: $ git config –global alias.add-commit ‘!git add -A && git commit’ $ git add-commit $ git config –global –edit [user] name = Raju email = i90Runner@gmail.com [gui] recentrepo = C:/Git [alias] add-comment = !git add -A && git commit …
MySQL and phpMyAdmin Setup
MySQL and phpMyAdmin Setup sudo yum install mysql sudo yum install mysql-server sudo yum install mysql-devel sudo chgrp -R mysql /var/lib/mysql sudo chmod -R 770 /var/lib/mysql sudo service mysqld start sudo yum install phpmyadmin Errors: # tail -f error.log 2014/03/06 20:11:05 [error] 2833#0: *1 directory …
Install S3CMD tools on EC2 Instance.
Install S3CMD tools on EC2 Instance. SSH Into your EC2 Box and you run the following command to install S3CMD. $ sudo yum install s3cmd Loaded plugins: priorities, update-motd, upgrade-helper Bad id for repo: datastax , byte = 8 amzn-main/latest | 2.1 kB 00:00 amzn-updates/latest …
Setup EC2 Instance with NGINX and PHP-FPM
Setup EC2 Instance with NGINX and PHP-FPM Login into AWS Console and launch default Amazon Instance. Security Group: Create your security group and download your key. Restrict the permissions on your key. sudo chmod 400 Kaizen.pem SSH into your Machine: ssh -i Kaizen.pem ec2-user@ec2-54-245-1-226.us-west-2.compute.amazonaws.com Update …
SQL Server – Interview Questions
Database Professional – Interview Questions What factors do you usually consider for your datastore selection ? Data Volume , Variety and Velocity. Whats CAP Theorem?. Consistency , Availability and Partition Tolerance and you can’t all three together. In theoretical computer science, the CAP theorem, also known …