ORACLE:PL/SQL script to rebuild Table(s) and it’s corresponding indexes. Note : Please implement in lower environments before proceeding to Production. Pre requisites : Please download and check below file for pre-requisites. Table creation scripts The below script will be used for 1.Rebuild table(s) 2.Rebuild… Read More
Cloning a Standalone database using RMAN Backup pieces I am making this article to create copy of current PROD database in another server using RMAN backup pieces for testing and development purposes. i have used a simple method to perform clone database. Server details :… Read More
Hi Dears, In this article,we will see Create Web Server On IIS Windows EC2 Instance. Steps to Follow : Logging to AWS Account. Launch Windows Server. Connect to Windows Server through Remote Desktop Connection. Configure IIS Web Server through Server Manager. Take Public DNS (IPv4)… Read More
Dear Readers, In this article, we will discuss Roles (L1,L2,L3) in SQL Server DBA. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a SQL Server Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/roles L1 Roles: ➼Check to… Read More
Dear Readers, In this article, we will discuss Tools for Administering the SQL Server. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a SQL Server Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/sqlserver SQL Server Supported Platforms… Read More
Dear Readers, In this article, we will see the Level of work. L1 Level Jobs Installation Postgres software as per standard document. Space monitoring for Table space, File system on Postgres db system etc. Logs monitoring for Backup, Index rebuilding and other maintenance jobs. Checking… Read More
Dear Readers, In this article, we will discuss Tools for Administering the Cassandra. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a Cassandra Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/cassandra Cassandra Flavors : Open source Apache… Read More
Shell script to rebuild indexes for index fragmentation Dear Readers, In this article , we wrote a automation job for rebuild indexes for index fragmentation. Note : 1) Please test the Shell script in Non-Prod before implementing it in Production. 2) Make sure you implement… Read More
Dear Readers, In this article, we will discuss Tools for Administering the mangoDB. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a Cassandra Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/mongodb mongoDB Flavors: mongoDB community version mongoDB… Read More
QUERY LOGGING Dear Readers, In this article, we will discuss QUERY LOGGING What is query logging in teradata database and how it is implemented? Database Query Logging (DBQL) is a feature in Teradata that logs data in the predefined tables created under … Read More
DIFFERENT SPACE ERRORS Dear Readers, In this article, we will discuss DIFFERENT SPACE ERRORS There are various Errorcodes that can be returned due to insufficient space. Some of them are 2507 2646 2644 Every errorcode has a different meaning and so is their cause and… Read More
Dear Readers, In this article, we will discuss Tools for Administering the MySQL Database Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a Cassandra Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/mysql MySQL Flavours Oracle Mysql MariaDB… Read More
SAMPLE FUNCTION Dear Readers, In this article, we will discuss SAMPLE FUNCTION As the name suggests, SAMPLE function will an idea on the data stored in the table/view by returning few numbers of rows specified either as a list of fractions of the total number… Read More
Dear Readers, In this article, we will discuss Tools for Administering the Oracle Database Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a Cassandra Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/oracledba Monitoring Tools OEM Nagios EM… Read More
ABBREVIATIONS IN TERADATA Dear Readers, In this article, we will discuss ABBREVIATIONS IN TERADATA AccessRight Column Value Description AE ALTER EXTERNAL PROCEDURE AF ALTER FUNCTION AP ALTER PROCEDURE AS ABORT SESSION CA CREATE AUTHORIZATION CD CREATE DATABASE CE CREATE EXTERNAL PROCEDURE CF CREATE FUNCTION CG… Read More
GIT INTERVIEW QUESTIONS PART 3 Dear Readers, In this article, we will discuss GIT INTERVIEW QUESTIONS PART 3 1. What is Git fork and difference between fork, branch and clone? A fork is a remote, server-side copy of a repository, distinct from the original. A… Read More
SQL SERVER –Transparent Data Encryption (TDE) Dear Readers, In this article, we will learn about SQL SERVER –Transparent Data Encryption (TDE) Transparent Data Encryption (TDE) performs real-time I/O encryption and decryption of the data and log files, thereby, protecting data at rest. When SQL Server 2008… Read More
TDWM Throttle Statistics In this article you will get to know the TDWM Throttle Statistics This section describes about a Teradata Dynamic Workload Management SQL interface that is used to manage the workload and update the stored components (such as, WDs and related data) in the… Read More
INITCAP FUNCTION IN TERADATA Dear Readers, In this article, we will learn about INITCAP FUNCTION IN TERADATA Purpose Modifies a string argument and returns the string with the first character in each word in uppercase and all other characters in lowercase. Words are delimited by white… Read More
INSTR FUNCTION IN TERADATA Dear Readers, In this article, we will learn about INSTR FUNCTION IN TERADATA Purpose Searches the source_string argument for occurrences of search_string. Syntax TD_SYSFNLIB : the name of the database where the function is located. source_string: a character string or string… Read More
