Database Technology

Sharing DBA experience to all -- Oracle,MS SQL, DB2 , Netezza DBA,postgreSQL,AWS Redshift,MySQL,oracle SAP,Snowflake,MongoDB

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....
›
Home
View web version

Eager to Learn about DB's & Share to others

alter-database.blogspot.com
I am a Database Lead Consultant within the oracle group of company and currently I am working for an Food company in India. I have total 14+ years of IT experience on Database, MSSQL, Oracle, DB2,PostgreSQ,IBM Netezza and aws Redshift Database Administration. I worked on most of the database falavours with AIX, HP-UX, SUSE Linux as well as Windows server platform. I am Oracle certified Professional 10g,11g and certified RAC expert,Oracle Cloud architect associate.(OCI) I have been involved in different Database implementation, upgrade and support projects. I am having extensive understanding of oracle and othe RDBS solutions, in-depth knowledge and vision of SAP software, ability to adopt innovative strategies to have the best possible solution. I am a key player in my current team. I can handle any Database project single handedly. I have worked with different customers across the globe including USA,UK,middle East, Denmark, Mexico, Canada Indonesia, India, china,Singapore and Japan.
View my complete profile
Powered by Blogger.