RAID (redundant array of independent disks; originally redundant array of inexpensive disks) is a way of storing the same data in different places (thus, redundantly) on multiple hard disks. By placing data on multiple disks, I/O operations can overlap in a balanced way, improving performance. Since multiple disks increases the mean time between failures, storing…
Create Trigger in Oracle
A database trigger is a stored procedure that automatically executes whenever an event occurs. The event may be insert-delete-update operations. For example, Oracle initiates an ‘AFTER INSERT’ trigger after an insert event has occurred or an ‘AFTER UPDATE’ trigger after an update event has occurred. You can write triggers that fire whenever one of the…
Delete Duplicate Rows Without All Records in Oracle
If you want to delete duplicate rows but not all rows in table, you can use a procedure. For example, you have 10 duplicate rows and you want to delete 9 rows, then you can use procedure to delete process. For instance, you have a table as tmp_table. tmp_table’s columns are id,name,surname,city,phone. You want to…
How to Take Export Backup in Oracle on Windows Servers
If you want to take export backup on windows servers, you can take with batch scripts and windows schedule tasks. You can create backup directory for this scripts and backups. We will use EXPORTDIR directory and below data, scripts, daily directories. You have to create three scripts file below scripts directory for this issue. Firstly,…
Microsoft Dynamics Crm Entity Customization
Microsoft Dynamics Crm has very flexible structure. You can change easily properties of CRM entities. You can find all CRM entities with this way which is Settings > Customizations > System Customization. There are all CRM entities here. Custom entities support the following functionality: You can create forms, views, and reports to expose your new…
Turkish Letter (i) Convert Problem in Oracle
When you make converting Turkish chacter (i) with upper function, the result is (I). This is a problem. Because you want to pair two word but you can not pair with using the familiar functions which are upper, lower, initcap. You can use NLS_UPPER function for the solution to solve this problem. Example SELECT NLS_UPPER(‘şampiyon’,…
Schedule Backup in SQL Server 2008 Express Edition
If you use SQL Server Express, You can take schedule backup with sql script and windows task schedule. Firstly, you have to create backup script, after you have to create batch file for task schedule. Create Backup Script BACKUP DATABASE [dbname] TO DISK = N’D:\SQLBackup\dbname.bak’ WITH NOFORMAT, NOINIT, NAME = N’dbname-Full Database Backup’, SKIP, NOREWIND,…
Start and Stop Instance in Oracle Rac System
You can demand stop one instance in Oracle Rac System. This stop process have to perform step by step. Firstly, stop instance after asm and finally stop applications. The first step is to stop the Oracle instance. When the instance (and related services) is down, then bring down the ASM instance. Finally, shut down the…
Create Fast Refresh for Materialized Views in Oracle
You can demand fast refresh for materialized views. Because refresh of tables which have large data are hard. The refresh time is long. Thus, you have to use fast refresh statement for this object. Firstly, You have to create materialized view log for table. If change a data, this changes will write this log. You…
Social Engineering Attacks
All social engineering techniques are based on specific attributes of human decision-making known as cognitive biases. These biases, sometimes called “bugs in the human hardware,” are exploited in various combinations to create attack techniques, some of which are listed here: Pretexting Pretexting is the act of creating and using an invented scenario (the pretext) to…