One very useful usage of Extended Events is the ability to trap SQL Server error without the need to have a server trace running (which, btw, is deprecated), with the additional feature of being able to query the data as soon as it comes in. This means that we a solution to monitor and trap errors as soon as they happen can be easily created, in ...

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 ...