How do I Change SQL Database from Single_User to Multi_User Mode: Sometimes, we have the need to set the database in Single User Mode to do some upgrades or blocking all the access to the Database. Set the Database to Single User Mode : ALTER …
Nissan Murano 2010 Rack and Pinion Cost
Dealership VS Non-Delarship Price I have NISSAN Murano 2010 AWD and I started noticing the Stiffness in power steering. I went to the NISSAN Dealer to Diagnose the problem and they found the Rack and Pinion was leaking. Obviously, the next question from me was …
SQL Server – Generic Error Handling I use
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 ( [email protected] ) ** 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 = [email protected] [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 …