In an earlier blog I talked about the difference in mentality between the typical developer and the typical DBA. One of the characteristics of the DBA is the distrust of the Microsoft Wizards. “Give ...

One of the dreaded error codes we get in the SQL log is the “1205”. It represents the infamous deadlock where two transactions are locking each other out. No way ...

When you make calls to the database, profiler will tell you what the command was (if you're using stored procs, it will tell you what procs were called). The combination of extra opens and the sql ...

Open source software vendor Talend announced that it has added big data profiling for Apache Hadoop and support for NoSQL databases in the upcoming release of its integration platform, Talend v5.2.

Ready to make a real impact in South Africa’s financial landscape? Our client, a leading and forward-thinking player in the Financial Services sector, is searching for a skilled and passionate SQL ...

CA has announced a new release of its ERwin Data Modeling Suite, with updated data modeling capabilities, integrated data profiling, and new reporting features. The CA ERwin Data Modeling Suite is an ...