Month: September 2014

How do I Change SQL Database from Single_User to Multi_User Mode

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

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

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.

Common Error Handling Stored Procedure

Tagged with: ,

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.

SQL Script Header Footer I use

SQL Script Header Footer I use :

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

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

Git Cheat Sheet

Git Quick Reference Adding the ShortCut:

Getting help:

Repository creation:

File operations:

Working tree:

Examining History:

Remote repositories – remotes:

Branches:

Exporting and importing:

Tags:

File status flags: M modified

Tagged with:

MySQL and phpMyAdmin Setup

MySQL and phpMyAdmin Setup

Errors: # tail -f error.log 2014/03/06 20:11:05 [error] 2833#0: *1 directory index of “/usr/share/phpMyAdmin/” is forbidden, client: 216.251.112.134, server: localhost, request: “GET / HTTP/1.1”, host: “ec2-54-244-152-140.us-west-2.compute.amazonaws.com” Make sure you have given correct chmod permissions are

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.

No REPO is available for S3CMD.

RUN WGET Command 

Then run your yum install

 

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.

SSH into your Machine:

Update your

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,

Tagged with: ,

NGINX – SSL Certificate Setup

Create the Server Key and Certificate Signing Request Start off by creating the 1024 rsa private key.

Remove the Passphrase

Sign your SSL Certificate

Set Up the Certificate

Command History :

xp_cmdshell command to Add User

Add user to Admin Group through SQL Server Its absolutely bad practice to turn on xp_cmdshell without comprehensive security audit and security testing. By default this feature is turned off. If you end up having the permission to execute xp_cmdshell,

Connect to SQL Server When SA or Service Account Credentials not Available

Connect to SQL Server When SA Account or Service Account Credentials not Available : I recently inherited the SQL Serer which was running under a user account who left the company and no one knows the password for sa account.

Move SQL Server Database to Different Location

Move SQL Server Database to Different Location : There are several way to do this but I find this option being simple.Sometimes we face the issue with Drive being full. It happens when we have Database on C Drive and

SQL Server Waits and Queues

SQL Server Waits and Queues : I watched Paul Randall Videos on Wait Types and which inspired me to write a simple post on wait types on logical way. We all have written queries, TSQL statements to perform CRUD (

Nginx Config for Perma Links

NGINX Config Change to enable Permalink changes : By default WordPress links are configured similar to ” https://ramblingsofraju.com/?p=123 “. If you need to change this URL to be something SEO friendly and other than default URL which points to the

Tagged with: , ,

SQL Join Diagram and Query

SQL Join Diagram and Query Create TableA and TableB and Populate Data

LEFT JOIN : Select records from the first (left-most) table with matching right table records.

RIGHT JOIN : Select records from the second (right-most) table with

Run SQL Scripts using PowerShell

Run SQL Scripts using PowerShell We all have the need to run SQL Scripts against Multiple Servers on Daily Basis. Sometimes, Its cumbersome to manually run the scripts against the server using Management Studio. This powershell Script comes handy to

Top