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 ...
Do you really know your data? Profiling is the first step in uncovering weaknesses in your database so that data can be captured accurately for use in analytics, business intelligence and master data ...