Virtual Training – SSIS, and Replication – LAST DAY TO REGISTER February 1 – 28, 2011 This is the last day to register for the 12 virtual classes on SSIS and Replication design by SQL Server MVP, Eric Johnson. I had an Email just today from a reader asking how to get up to speed on SSIS skills. This is […]
Other News
DB2 LUW Performance Analysis and Tuning Workshop at IDUG NA, Anaheim, CA
(Scott Hayes) In 2010, the “DB2 LUW Performance Analysis and Tuning Workshop” drew top attendance numbers in North America, Australia, and EMEA.
A Textual Syntax for SPARQLMotion
(Holger Knublauch) SPARQLMotion is an RDF-based scripting language that is suitable to be presented and edited graphically to form data processing pipelines.
Transaction Failure — when is the error returned ?
(Hemant K Chitale) There was a question in the orafaq forums “What happens when UNDO space is full? Transaction takes more time to ERROR?” where my response was to the effect that the user sees the error message only after the rollback is completed.
Oracle LogMiner
(Gerald Venzl) Oracle provides a powerful out of the box tool called LogMiner within the Oracle database. LogMiner enables you to query online and archived redo log files through simple SQL. The log files of the database contain all changes made to user data or to the database dictionary due to reco
Searching for null values in UCM
(kyle.hatlestad) Sometimes when searching with metadata in UCM, it’s helpful to be able to find items that have null or blank values. And while it is possible to perform these types of searches, the method to do so is a bit tricky and varies depending on your search engine.
Rotate Text in SSRS
(Jason Thomas) Sometimes we get pampered so much by modern technology that we tend to raise the bar of necessity towards the fringes of luxury. 10 years back, a mobile phone was a luxury in my native place. Today, even school children carry one along with them and most of them take it as granted.
The Case of the Missing Date/Time Stamp: Reporting Services 2008 R2 Snapshots
(Stacia Misner) This week I stumbled upon an undocumented “feature” in SQL Server 2008 R2 Reporting Services as I was preparing a demonstration on how to set up and use report snapshots.
Yet Again On Subqueries
(Ivan Zoratti) They come back, every now and then. Subqueries are far from being perfect at MySQL and they can give you some serious headaches.
DB2 Performance Maintenance – Get All the Cache
(Dave Beulke) As I said last week, within every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. This week we look into the DB2 Plan and Package settings.