I’ve decided to invest more time in writing blog posts in English…I’ve blogged intensively in Italian so far, but I did only seldom post in English.
I decided to start from scratch and to be more constant in it, and as all new started I needed a new blog, that I decided to open here:
Read more →
With the latest release of DTLoggedExec, I’ve also added a nice functionality to make package runtime configuration a little easier, introducing the concept of “Package Parameters”.
I’ve now updated the documentation adding details on how to use this new feature (is *really* easy, but is *really* useful) and, as usual, you can find it on DTLoggedExec wiki:
Read more →
In these days I discovered that DTLoggedExec is now officially mentioned in the SQL Server Books Online documentation:
Implementing Logging in Packages http://msdn.microsoft.com/en-us/library/ms138020.aspx
I’m really proud of that! It give me even more will and determination to make this tool more and more powerful and useful.
Read more →
In these last days I've released the latest version of DTLoggedExec. Now it has reached version 0.2.2.0.
I planned the release to be done in May, but I added a l lot of stuff and then I realized that logging so much information without being able to automatically import it into SQL Server for further analsys has no clue.
Read more →
When I’m at office or at home I’m used to use my desktop pc and my laptop. The problem with this configuration is that I have two monitors, one per computer, and that’s fine, but two mouses and two keyboards.
Read more →
For all those who came at SQL Bits, and also for all those who didn’t manage to came, and would like to have slides and demos to play with my DTLoggedExec tool, everything can be found here:
Read more →
This year I’ll also speak at PASS Europe 2009. Here I’ll deliver a session dedicated to help developers to maximize performance with their SQL Queries, using a set-based approach, insteand of the simpler but usually less scalable and efficient row-by-row solution:
Read more →
On the next 28th of March will take place one of the biggest SQL Server conference in Europe, the SQLBits conference, now arrived at the fourth edition! It’s completely free and it’s held on saturday so that you don’t have any working execuses for not participating :-)
Read more →
Finally the “Smart Business Intelligence Solutions with SQL Server 2008” is now available to worldwide stores!
ISBN: 0735625808 ISBN-13: 9780735625808 Format: Paperback, 624pp Publisher: Microsoft Press Pub.
Read more →
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?
Read more →
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.
Read more →
It's been a long time since I've been able to work consistenly on my DTLoggedExec tool. Fortunately in these last days I've been able to spare some free time to continue the work, and now, within a few days in September 2008 I should be able realease a new version of it.
Read more →
SQL Server 2008 has a strong integration with PowerShell but actually it also provide a custom shell, SQLPS, which is somehow limited for me. Well actually is limited more in general speaking, since it is called "minishell".
Read more →
In the last days Frank McBath send me an interesting email regarding a free workshop that will be delivered in Zurich on the 10 and 11 of July.
The workshop is really intersting, as you may see by yourself:
Read more →
After a while I've realeased a new version of DTLoggedExec, the DTExec replacement:
Compiled to support 32bit and 64bit platforms (32bit and 64bit executables are available in the zipped file) Updated the ConsoleLogProvider to add a more detailed logging of OnError events.
Read more →
At this address
http://www.davidemauri.it/SqlScripts.aspx
i've released four scripts that simplify the usage of SQL Server 2005 DMVs to discover, analyze and understand indexes usage and health.
They are nothing exceptional, juts a shortcut to common (but long to write) queries.
Read more →
Finally I've realeased a new version of my DTLoggedExec tool.
A lots of improvement from the first public version:
-Switched to a fully pluggable architecture to support 3rd party plugins -Added "LogEvent" command line switch to choose which events should be logged -Added support for Expression logging -Added "Package Name" and "Container ID" values in the console log
Read more →
Today I worked again on DTLoggedExec. I've been able to add the ability to log properties with DTS Expressions associated. This allows the log to show and report properties values in additions to the already present ablity to log variables values.
Read more →
I've created a dedicated page for my DTLoggedExec tool.
http://www.davidemauri.it/dtloggedexec.aspx
By the end of the month (June) i'll put online the full source code. The code and the application are licensed under Creative Commons Attribution-NonCommercial-NoDerivs 2.
Read more →
I've been able to work a little on my DTLoggedExec project in this last week. You can find a log execution result here: http://www.davidemauri.it/files/DTLoggedExec_test_output.txt
DTLoggedExec now supports some of the original DTExec options and is able to log even variables values, as you may see from the link above.
Read more →