(Peter Vogel) The IComparable interface lets you create objects that know how to sort themselves correctly. This interface also provides an example of a high-level strategy for building and extending your classes.
Author: SSWUG Research
Thread-Safe Queues with ConcurrentQueue
(Richard Carr) The standard .NET queue classes are not thread-safe so require additional locking to avoid errors when used in multithreaded or parallel scenarios. This additional complexity is not required with the generic ConcurrentQueue class.
Analytic functions within Pivot statements
(Scott Wesley) Today I found that SQL analytics go hand in hand with PIVOT statements.
Using CROSS APPLY instead of a calculated variable
(Kenneth Fisher) Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working on a series of audit queries for the last couple of weeks and got thrown a bit of a curve today. The original specs included several comparisons against a date. Basically the followin
How to: Configure SQL Server 2012 AlwaysOn – Part 6 of 7
(Derik Hammer) In this part of the blog series we will go over the various methods of manually failing over an Availability Group. Naturally if you are using automatic fail-over then there are no steps required for this to happen in an emergency but you might find a reason to conduct a planned manua
Deploying Application Express on the Command Line
(Jeff Kemp) I love the Apex UI, it makes development so much easier and more convenient – and makes it easy to impress clients when I can quickly fix issues right there and then, using nothing but their computer and their browser, no additional software tools needed.
V$CELL_THREAD_HISTORY – ‘ASH’ for Exadata Storage Cells
(Tanel Poder) Did you know that there’s something like Active Session History also in the Exadata storage cells? 😉
Surveying semantic web tools
(Mark Watson) I have been helping a customer with a semantic web project. He likes the Virtuoso platform because it is well documented and widely used and he wants to learn Clojure so there are no technology decisions to be made: we have a thin Clojure library for hitting SPARQL endpoints (which I w
Tighter Integration Coming in the Performance Management Solution
(hollyann) One of the issues that users have raised to me is the impedance mismatch between our web-based tools and our eclipse-based tools, in particular, between InfoSphere Optim Performance Manager (Performance Manager) and InfoSphere Optim Query Workload Tuner (Query Tuner).
DB2 Locking Part 7: Lock Avoidance, Related Issues, and Stuff
(Craig S. Mullins) In today’s blog entry, part 7 in our on-going series on DB2 locking, we will take a look at lock avoidance… as well as some other related things.