This blog post is in response to one of the questions that we got from our reader. Here is the question: “I’d like to hear your opinions on bitmask fields. I have found a lot of flames on using bitmask fields into RDBMS and most of them look a lot like the cons of EAV models, which I do agree […]
Other News
Introduction To Linguistic Indexes – Part I
(Richard Foote) Characters are sorted by default based on numeric values defined by the default character encoding scheme (known as Binary Sorting). For us Australians, this is fine as we (generally) speak English and the English alphabet is nicely sorted in ascending order by ASCII and EBCDIC stand
Oracle BI EE 10.1.3.3/2 – iBot Results within Dashboard Sections and Auto-Refreshing Sections
(Venkatakrishnan J) We will be seeing 2 topics today which are quite interesting especially for users who send a lot reports to end-users using iBots. The first topic deals with the display of scheduled reports(what is being sent to end users) within a custom dashboard section (not from the Alerts l
More on SQL Server Service Pack Installation Practices
SQL on Call Show Available Now The latest SQL on Call show is live now and you can watch it on the site – in today’s show Chris closes out the series of top 10 SQL Server thoughts about 2007. > Watch here Also available: [Watch] SelectViews, the SQL Server Show – Keeping up with technology, Microsoft interviews and more. […]
Two-Thirds Do Not Apply Service Packs… WHAT?!
SQL on Call Show Posted The latest SQL on Call show is live now and you can watch it on the site – in today’s show Chris closes out the series of top 10 SQL Server thoughts about 2007. > Watch here Also available: [Watch] SelectViews, the SQL Server Show – Keeping up with technology, Microsoft interviews and more. Featured […]
Identities for Sequenced Web Services
Extensible Markup Language (XML) Web services deployments present unique challenges that emerge when creating an application system based on independently developed, reusable segments of business logic. Although initial adoption of Web services often begins with simple point-to-point integration of
Pull parsing XML in PHP
(Elliotte Rusty Harold) Discover the XMLReader library, which is bundled with PHP 5 and enables PHP pages to process XML documents in an efficient streaming mode.
What is the optimal thread specific buffer size?
(Ronald Bradford) So you want to know what join_buffer_size, sort_buffer_size, read_buffer_size and read_rnd_buffer_size values for your application should be? These MySQL thread specific buffers are variables I can never get right because there are insufficient metrics, instrumentation or even abst
When DB2 for z/OS Can’t Account for in-DB2 Time
(Robert Catterall) DB2 for z/OS is very good (through data provided in accounting trace classes 2 and 3) how time is spent when SQL statements are executed (this is often referred to as in-DB2 time). That said, it is often the case that one will see, in a DB2 monitor accounting report or an online m
Groovy: XML without the bloat
(Pan Pantziarka) You may find this hard to believe, but there was a time before XML hell, when the idea was that XML was going to solve just about every tricky problem in software development. From swapping data between applications or platforms, to storing complex data structures in a portable form