shiranGinige

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE ROUTINE_DEFINITION LIKE '%search text%' 
    AND ROUTINE_TYPE='PROCEDURE'

shiranGinige

# Create a new Git Repository under the VSTS project you are working on (e.g. YourTeamProjectName below)
# Make sure you have chcolatey installed

# Install Git-TFS 
> cinst Git-TF

# Init a git repo and apply TFS changesets 
> git-tf clone https://your-tenant-name.visualstudio.com/ $/YourTeamProjectName/TFSBranchName --deep

# Add the remote 

shiranGinige

Azure Media Services  ( with no live encoding) H264:360p  : 640x360 - 30+ seconds 
YouTube - 720p30x264 1.75 Mbps  - 13 seconds 

shiranGinige

import RPi.GPIO as GPIO
import time

def blink(pin):
        GPIO.output(pin,GPIO.HIGH)
        time.sleep(1)
        GPIO.output(pin,GPIO.LOW)
        time.sleep(1)
        return
GPIO.setmode(GPIO.BOARD)

shiranGinige

#set the value of this to your own db config
$myConnectionString = "Data Source=.;Initial Catalog=<<yourdatabase>>;Integrated Security=True";

$scriptDir = Split-Path -Path $MyInvocation.MyCommand.Definition -Parent


$webConfig = $scriptDir +  '\PeopleStreme.Api\Web.config'
$dbUpConfig = $scriptDir + '\PeopleStreme.Database\App.config'
$unitTestConfig = $scriptDir + '\Config\App.config'

shiranGinige

#set the value of this to your own db config
$myConnectionString = "Data Source=.;Initial Catalog=<Database>;Integrated Security=True";

$webConfig = '.\Api\Web.config'
$dbUpConfig = '.\Database\App.config'
$unitTestConfig = '.\Test\App.config'

Function updateConfig($config) 
{ 

shiranGinige

select top 25

    (total_logical_reads/execution_count) as avg_logical_reads,

    (total_logical_writes/execution_count) as avg_logical_writes,

    (total_physical_reads/execution_count) as avg_phys_reads,

     Execution_count,

shiranGinige

If rake preview fails with below error 

Errno::ENOENT: No Such File or Directory - Jekyll ~  

It is likely that with EI Capitan update changed the ruby version and rake command is no longer able to find it 

I followed following steps 

Install latest version 
$ rvm install 2.2.3 

shiranGinige

1. create the EBS volume /snapshot from the console and attach it with the instance 

$ sudo mkfs -t ext3 /dev/sdf
$ sudo mkdir /mnt/data-store
$ sudo mount /dev/sdf /mount/data-store

2. to map a drive from a snapshot 

- make the snapshot a volume from the console and attach it with the instance 

shiranGinige

1. Create the Ec2 instance 
2. Connect to the server 
    ssh -i testpair.pem [email protected]
3. Update all packages 
    sudo yum update 
4. Install php 
    sudo yum install php 
5. edit the index.php file 
    cd var/www/html
    vim index.php