(Greg Robidoux) I see the use of the NOLOCK hint in existing code for my stored procedures and I am not exactly sure if this is helpful or not. It seems like this has been a practice that was put in place and now is throughout all of the code wherever there are SELECT statements. Can you explain t
Other News
Usability Test Subject Selection
New, 5-Year Anniversary Show – See how it all started… Stephen Wynkoop and producer Josh Harrison on the show today – with a look back at 5 years of SSWUG TV. Bloopers, how it was done, some funny moments and even a fact-check. This one is one not to miss! [Watch the Show] Last Show: SSWUG TV – Interview with […]
SSWUG TV – Stephen Wynkoop and producer Josh Harrison on the show today – with a look back at 5 years of SSWUG TV.
Pro-Center Video Programming for IT Professionals
Usability Testing
Usability Testing Lately I’ve been taking time to review the concept of Usability and Usability testing. Whole disciplines have been built up around the practice. Some organizations find it extremely useful while others find it to be misdirection of resources. It seems that the design of the test itself may often be a cause of failure. Like any form of […]
Infinite Replication Loop
(Frederic Descamps) Last week I helped 2 different customers with infinite replication loops. I decided to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify them… and how to fix them.
DB2 Support Video – Monitoring transaction times
(Laura) In our latest video demo our Remote DBA team show how they use Brother-Thoroughbred® from DBI Software to measure customer’s transaction times, time distributions and service level attainments.
Namespaces is for Markup and Data
(Roger L. Costello) Recently I was bitten and I’d like to share the lesson I learned.
XML Security Suite: Increasing the Security of E-Business
As more and more companies use XML to transmit structured data across the Web, the security of documents becomes increasingly important. The World Wide Web Consortium (W3C) and the Internet Engineering Task Force (IETF) are currently defining an XML vocabulary for digital signatures.
Whatever happened to XML schemas?
(Ronald Schmelzer) Early in the growth of XML as a data format, even before the widespread adoption of Web services, one of the most popular and heated debates was on how best to represent the structure and syntax of data in an XML document.
An underhand compilation
(Gary Myers) Oracle cheats. Or, more generously, it sometimes plays by different rules. Normally a DDL will do an implicit commit of any outstanding transaction. Actually it does a couple of implicit commits, one before it tries the DDL and a second if it succeeds.