After serveral years of development I’ve finally released the first non-beta version of DTLoggedExec! I’m now very confident that the product is stable and solid and has all the feature that are important to have (at least for me). DTLoggedExec 1.0 http://dtloggedexec.codeplex.com/releases/view/44689 Here’s the release notes: FIRST ...

I’ve just created a new project on CodePlex anmed SYS2DMVS, where I’ll put all my sys2 scripts so that they can be found and accessed more easily. Also it will more easy for me to maintain them, just a Check-In with SVN and that’s it :-). http://sys2dmvs.codeplex.com/ The scripts are growing in number, they are now 9, so I though that they ...

I’ve updated my “sys2” scripts with three 3 new scripts: sys2.objects_dependencies A wrapper around sys.sql_expression_dependencies that shows also related informations taken from sys.object table, like object name, object type and schema name of the referencing entity. sys2.objects_partition_ranges Shows information on partitioned ...

After a discussion with a friend of mine, I’ve opened a suggestion on Connect to request to have Extended Properties visible in the main Object Explorer Details window. This will be especially useful for creating self-documenting database, since that window can easily provide additional information about, for example, column in a table or in a ...

Ok, maybe this post contains information that anyone already knows, but since I just discovered the SQL Server 2008 Object Explorer Details’ features today, maybe other people are in the same situation. In older version of SQL Server the Object Explorer Details window was simply not useful at all since it just replicate what you can see in the ...