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
Category: 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
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’
Find the Total Size of an S3 Bucket using AWS CLI
aws s3 ls –summarize –human-readable –recursive BucketName |grep “Total Size”
how to check if NUMA is enabled in Linux. ?
dmesg | grep -i numa
Where do Couchbase have logs ?
All Couchbase logs are stored in this location in Linux based systems. /opt/couchbase/var/lib/couchbase/logs
How to Delete Millions of Rows From SQL Server Table ?
Sometimes there will be the requirement to delete million rows from a multi million table, as it is hard to
SQL server updates or service pack hung or failed to install!!
When installing sql server update or service pack, one of the reason to fail if you have
Finding top 10 large tables in each database in an instance of SQL server
It is a good practice to find and monitor your large SQL server tables, we may surprise in some cases where our
Always – ON Availability group Alerts
After setting up Always ON , we need to configure SQL server Alerts to know about the availability Group errors
