January 2009 Blog Posts
SQL Server Performance Workshop: Siebel, JD Edwards, PeopleSoft

If you’re using SQL Server as the database for on of the well-known enterprise applications like Siebel, JD Edwards or Peoplesoft you may be very interested in the workshops that Frank McBath, a well known expert in the integration between Microsoft and Oracle field (btw did you know that a Microsoft Oracle Center of Excellence exists?) with a strong knowledge of SQL Server.

The workshop will focus on this topics:

  • Top Reasons for SQL Server 2005/2008
  • Query Repro: Reproducing Problem Queries Outside of the Application and Tools to Fix Them
  • Performance Tuning Methodology: A Repeatable Process
  • Hands on Performance Tuning Lab
  • Databases & Disk Drives: Architecting a Scalable Solution
  • SQL Server Settings
  • Case Study Handouts
  • Architecting for RSCI
  • SQL Server Compression
  • Hyper-V and Virtualization

and will be available for free in these cities:

Zurich January 21 & 22
Estonia January 26 & 27
Stockholm January 29 & 30
New York City February 4 & 5
Los Angeles February 17 & 18
San Francisco February 25 & 26

I hope to be able to attend to the Zurich or Tallin workshop. And I strongly suggest not to miss this opportunity!

If you’re interested in can find all the information you need here:

posted @ Thursday, January 08, 2009 6:45 PM | Feedback (0)
DTLoggedExec Relased: profile your dataflow!

With the help of these last Holydays, I've been able to release the latest version of DTLoggedExec, the DTExec replacement tool I've been developing from 2006.

Beside the usual deep logging of Control Flow, this new version brings a very important and powerful feature: the ability to log and thus profile the Dataflow. This means that is it possible to deeply monitor the performance of ETL through time, also verifying how every change we do impact on it. Here's some examples that I've used on a customer:

Quality-Of-Service DataFlow-Performance-Overall-Processed-Rows Package-DataFlow-Performance-Over-Time


But where's the news here? Creating a Dataflow using RowCount transformations allows you to do that already! Yeah - I know - but here's the trick: you don't need to develop your packages using any specific transformation or technique in order to have such logging and profiling! Just run the package using DTLoggedExec with the option for profiling and that's it! Logging and profiling out-of-the-box served freshly!

DTLoggedExec is compatible with SQL Server 2005 and SQL Server 2008, and with any processor architecture.

To help people to start to use it, I've created a specific website you can refer to:

For any question don't hesitate to check the FAQ website section or contact me directly!

Executable and source code is hoste on CodePlex, under a Creative Common license:

posted @ Sunday, January 04, 2009 2:03 PM | Feedback (0)