(Evan Lenz) With the recent Developer Community site launch, we introduced a new feature to the Search page which allows you to narrow your search results down by page category. In this post, I’m going to call out some of the MarkLogic features that enabled us to do this.
Other News
De-Confusing SSD (for Oracle Databases)
(Gwen Shapira) You never forget your first SSD.
Reading from a XML Data Type Column in SQL Server
We have covered XML capabilities in SQL Server in several posts before – you can read those here. Yesterday, while helping a client, the developer needed to read from an XML data type column and the way the code was written was to iterate over the records, fetch one record at a time, assign it to a
Working with the ADF DVT Map Component
(Shay Shmeltzer) The map component provided by the ADF Faces DVT set of components is one that we are always ending up using in key demos – simply because it is so nice looking, but also because it is quite simple to use.
CBC Latch Diagnosis & Acquisition Patterns
(Craig Shallahamer) Cache buffer chain (CBC) latch contention is a common top Oracle wait event. There are a number of interrelated causes but also a number of solutions. The trick is to properly diagnose the problem which results in a short list of solutions.
MySQL opening .frm even when table is in table definition cache
(Stewart Smith) or… “the case of Stewart recognizing parameters to the read() system call in strace output”.
DB2 Symposiums – Take a Survey to ensure World Class DB2 Education Comes to You
(Susan Visser) A DB2 Symposium is a three day training event with one day seminars presented by industry leading consultants. The DB2 Symposium fills the gap between a conference and a multi-day training. The DB2 Symposium is unique because you can join us for 1, 2 or 3 days, depending on your needs
Block Party
(Martin Hubel) OK, I will get back to indexes, but first it appears I’ve made an impact.
Geek City: Growing Rows with Snapshot Isolation
(Kalen Delaney) I just finished a wonderful week in Stockholm, teaching a class for Cornerstone Education. We had 19 SQL Server enthusiasts, all eager to find out everything they could about SQL Server Internals. One questions came up on Thursday that I wasn’t sure of the answer to. I jokingly told
New word breakers may return different results in SQL Server 2012 Full-Text Search
(Douglas Laudenschlager) If you rely on SQL Server Full-Text Search, then this is important information, even if you can’t recite the definition of word breaking and stemming.