(Pinal Dave) Concurrency is simply put capability of the machine to support two or more transactions working with the same data at the same time.
Other News
No Magic Numbers
No Magic Numbers Today I wanted to share a tip for SQL queries to make them more manageable. Recently I have been translating some SQL code into C#. One of the things that made the process more difficult is that the SQL code was written using a variable @X INT. The code takes different branches depending on the value of […]
JQuery – Browser Equalizer
JQuery – Browser Equallizer We have been considering how to handle code unique for different brands and versions of browsers for the last couple of days. Some of the things I have been looking for were testing techniques, ways to reduce the number of tests necessary, and software frameworks to reduce coding. A number of tools and techniques were submitted […]
Understanding Transactions And Database Rollbacks That Involve 3rd Party API Integration
(Ben Nadel) ColdFusion’s CFTransaction tag is pretty awesome – you just wrap up a bunch of database interactions in the CFTransaction tag and any error thrown by any of the interactions automatically rolls-back the entire set of database mutations.
Pretty-formatted index fragmentation with xtrabackup
(Baron Schwartz) The xtrabackup compiled C binary (as distinct from XtraBackup, which is the combination of the C binary and the Perl script) has support for printing out stats on InnoDB tables and indexes.
XML: IDs and the DOM
(Gabriele Romanato) In XML, IDs are treated differently from HTML. Since XML has no predefined DTD, an ID attribute has no special meaning for a user-agent that tries to access an element through the DOM.
RC of Entity Framework 4.1 (which includes EF Code First)
(Scott Guthrie) Last week the data team shipped the Release Candidate of Entity Framework 4.1. You can learn more about it and download it here.
XQuery and SQL/XML: How to convert a date that is not a date into a date?
(Matthias Nicola) Recently I received an interesting question about a date that is not a really date. Take the following XML element as an exanple:
The DB2Night Show #46: Personal DB2 Success Stories on DB2’s GOT TALENT!
(Scott Hayes) This was another great show for learning DB2 tips and techniques! Our Top 7 Finalists shared Personal DB2 Success Stories! 100% of today’s studio audience indicated that they learned something that would be helpful to their jobs!!!
Anatomy of a .NET Assembly – CLR metadata 2
(Simon Cooper) Before we look any further at the CLR metadata, we need a quick diversion to understand how the metadata is actually stored.