(Kevin Burton) In a comment while we were discussing his Queue Engine Brian Aker mentioned his concept of “engine services” which is something I’ve been thinking of for a while now.
Other News
Product Review: Oracle PL/SQL Tuning
(Steve Callan) I like to recommend good products or finds from time to time, and the subject of this recommendation is Tim Hall’s Oracle PL/SQL Tuning Expert Secrets for High Performance Programming (published by Rampant TechPress). Books on PL/SQL, like books on other topics related to Oracle, rang
Administering the SQL Server 2005 Database Engine
(Alec Minty, Chris Amaris, Ross Mistry and Rand Morimoto) Although SQL Server 2005 is composed of numerous components, one component is often considered the foundation of the product. The Database Engine is the core service for storing, processing, and securing data for the most challenging data sys
DB2 9 Index with Expressions
(Troy Coleman) Prior to DB2 9, the create index statement only allowed you to use the column name from the table the index is being built on. The same value for each column stored on the table was copied into the index and used to quickly identify the row when searching by that column name. Now with
Converting (people) to RDF
(Jeni Tennison) As I’ve mentioned before, I’ve been a RDF sceptic for a long time. Perhaps it’s precisely because of my knowledge engineering background: in my experience, the field is about equal parts academic optimism, sales-related exaggeration and plain old information management. In other (un-
Introduction to Domain-Specific Development with Visual Studio DSL Tools (Sample Chapter)
(Alan Cameron Wills, Steve Cook, Gareth Jones and Stuart Kent) This book describes the Microsoft Domain-Specific Language Tools (the DSL Tools). The DSL Tools are part of the Visual Studio SDK, and may be downloaded from http://msdn.microsoft.com/vstudio/DSLTools/. The DSL Tools extend Microsoft Vis
Create MySQL 5.1 Storage Engine Plugins Under Win32
(Ludwig Ertl) A MySQL Storage engine requires functions that MySQL provides. Therefore, you normally need to link it into mysqld-core under Windows because mysqld.exe doesn’t export all required functions (it’s an .exe, not a .dll). So, you’re unable to import the required functions in your plugin.
Oracle BI EE 10.1.3.3/2 – Accessing Presentation, Repository and Session Variables from Presentation layer
(Venkatakrishnan J) One of the common questions that keeps coming in the forums is “How does one access the Repository and Session variables defined in the repository from BI Answers?”. Since this is again a pretty common question i thought i would blog about it since there is a documentation bug on
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 11
(Muthusamy Anantha Kumar) This installment of the series illustrates how to use PowerShell cmdlets in conjunction with the SQL Server client and output redirection to export to a text file or XML file.
Free Database Archiving Webinar
(Craig Mullins) The webinar, which I will be co-hosting with Bill Baker, will tackle the issue of skyrocketing data volumes in conjunction with increasing governmental regulations that impact the duration of data retention. These dual trends (among several others) conspire to make it difficult to en