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 ...

With the move to the cloud, the amount of data that companies are able to manage has grown exponentially. This is why Capital One created Data Profiler, the open-source Python library that utilizes ...

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 ...