Enterprise Data Integration strategies and solutions

At the core of most IT integration projects is data integration. Despite that does not mean this should always be a starting point of your integration projects, I would focus exactly on the data integration topic later in this article. However, before that I’d like to mention different levels of integration that have different levels of semantics. Read more »

Oracle SQL Developer – software review

I remember testing the Project Raptor software about 5 years ago, Oracle’s new graphical tool for creating and browsing database objects. With a few clicks you could easily create and debug stored procedures, test SQL statements and view optimizer plans. Raptor was small, fast, and fun, and perhaps best of all, it was FREE! Later, the SQL Developer production version 1.0 was released in 2006.

Right from the beginning the tool was supported by Oracle Support for any customer with a current Oracle Database support contract. I admit I did not use SQL Developer right from the beginning. With more features coming into the new releases I started slowly accommodating them in my DBA toolset. So what’s now? Is it still small, fast and fun? Read below my short software review of the current SQL Developer version 2.1.1.64. Read more »

Protect your data and database against social engineering

According to security experts, it is much easier for attackers to gain access to confidential company data or IT system by manipulating employees, rather than using cracking techniques. This act is known as social engineering.

In computer security, social engineering is a term that describes a non-technical kind of intrusion that relies heavily on human interaction and often involves tricking other people to break normal security procedures. Consequently, not only DBAs or IT personnel but all the company employees should be aware of common methods used by the so-called “social engineers” in order to protect their data and databases from such attacks. Read more »

Data protection rules for a DBA

Below I’d like to touch on the European Union’s data protection rules in order to encourage database administrators (DBAs) to be careful with sensitive company and individual’s information that you work with.

The data protection rules established by the European Union help give people control of their personal data. They set high standards for businesses that collect and use this data – especially sensitive data like health information, sexual preference, religious, political or ideological views or prior criminal offences. Read more »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email