Pavan Srirangam

How to backup couchbase buckets and upload to S3.

This script can be configured in cron job to scheduled to run hourly and i will create one repo every

Rate this:

June 25, 2019 ARTICLES

Script to Create Trigger for each table to make read-only and block any updates or modification apart from Replication.

–Create Triggers for protection SET NOCOUNT ON ;With AllTables as (SELECT NAME, SCHEMA_NAME(t.[schema_id]) AS SchemaName FROM sys.tables AS t WHERE t.is_ms_shipped = 0 ) SELECT ‘CREATE TRIGGER tr_’ + SchemaName + ‘_’ + NAME + ‘ ON [‘ + SchemaName

Rate this:

April 16, 2018 ARTICLES

Query AWS CLI to get Instance Name and Instance Type

Remove Grep if you want to list or keep it for search and example here search by name with ‘db’

Rate this:

March 21, 2018 ARTICLES

Find the Total Size of an S3 Bucket using AWS CLI

aws s3 ls –summarize –human-readable –recursive BucketName |grep “Total Size”

Rate this:

February 22, 2018 ARTICLES

how to check if NUMA is enabled in Linux. ?

dmesg | grep -i numa

Rate this:

December 20, 2017 ARTICLES

Where do Couchbase have logs ?

All Couchbase logs are stored in this location in Linux based systems. /opt/couchbase/var/lib/couchbase/logs

Rate this:

November 10, 2017 DBA SCRIPTS

Auto Fix orphan users on all Databases

DECLARE @DB_Name varchar(100) DECLARE @Command nvarchar(2000) DECLARE database_cursor CURSOR FOR SELECT name FROM sys.databases where database_id>4 and name not like ‘%master%’ OPEN database_cursor FETCH NEXT FROM database_cursor INTO @DB_Name WHILE @@FETCH_STATUS = 0 BEGIN SELECT @Command =’ use ‘+ @DB_Name+’; declare @query varchar(1000) declare @executequery cursor set @executequery=cursor for select ” sp_change_users_login ”+CHAR(39)+”update_one”+

Rate this:

November 9, 2017 DBA SCRIPTS

Database Mirroring Failover- all databases in a instance

–Script to failover all databases in a instance. declare @mirroring table (query varchar(200)) insert into @mirroring select ‘use master;’ insert into @mirroring SELECT ‘ ALTER DATABASE ‘+quotename(db_name(database_id))+’ SET PARTNER FAILOVER ;’ FROM sys.database_mirroring WHERE mirroring_role_desc = ‘PRINCIPAL’ select * from @mirroring — Script to Remove