Tuesday, July 21, 2026

script to find out DB size in Snowflake database

›
  SELECT     USAGE_DATE,     DATABASE_NAME,     ROUND(AVERAGE_DATABASE_BYTES / POWER(1024, 3), 2) AS DATABASE_GB,     ROUND(AVERAGE_FAILSAFE...
1 comment:

can we create the 2 object with same name in the Snowflake?

›
 we can create the same name table in Snowflake database. we create permanent table, temporary table in same  database, But when we query th...
Friday, May 22, 2026

pg_cron setup in PostgreSQL

›
pg_cron is a PostgreSQL extension that lets you run scheduled jobs (like Linux cron) directly inside PostgreSQL. 1.RHEL / CentOS / Rocky Lin...
Wednesday, January 7, 2026

MySQL DB administration scripts/commands

›
 -- List all users present in mysql mysql> select user,host,account_locked,password_expired from mysql.user; Create user in mysql: mysql...
Wednesday, December 24, 2025

step by step Reading MSSQL DB data from Oracle 19c database using DB link & ODBC Drivers :

›
 Reading MSSQL DB data from Oracle 19c  database using DB link & ODBC Drivers  : *******************************************************...
Tuesday, December 23, 2025

step by step to read oracle DB data from MSSQL server using linked server in MSSQL database

›
 Linked Server in MS SQL Server ----------------------------------- Source : MS SQL 2019 EE on Windows 22 Target : Oracle 19c R2 EE on Linux...
Thursday, December 18, 2025

SQL script to push the grants to a group in AWS Redshift DB for Read and write access

›
 1.select 'grant usage on schema ' ||nspname||' to <new_group_name>;' from pg_catalog.pg_namespace  where nspname not ...

SQL script to change the ownership of schema, table ,procedure in AWS Redshift Database

›
  SQL script to change the ownership of schema, table ,procedure in AWS Redshift Database 1.change the ownership of schema select 'alt...

AWS Redshift SQL scripts to find out session and Audit information

›
 What is the best way to assess tables that need to be vacuumed or analyzed? This query returns tables where greater than 20% of rows are un...
Tuesday, December 16, 2025

Shell script to check and record the database size in Redshift Database

›
Here is the custom script used to check the Redshift DB size and record it every month .This  will  be useful to get the know the DB growth....