Thursday, November 30, 2006 - Posts

SSMS Custom reports - Drill through reports

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSMS Custom reports - Drill through reports
The new RSS feed is here

If you intend using the new custom reports feature of Management Studio and develop a set of reports that you can navigate between then be aware of a  feature where by if you refresh a drill through report the some of the parameters are not maintained.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSMS Custom reports - Drill through reports

posted Thursday, November 30, 2006 11:18 PM by SimonSabin with 0 Comments

Team Foundation Server Support for Keyword Expansion

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Team Foundation Server Support for Keyword Expansion
The new RSS feed is here

I remember coming across this last year when looking at TFS and was shocked.

I thought I heard it was going to be added in an service pack but can't find anything to support it.

If you feel that Keyword expansion is needed then please vote on the suggestion at connect

"Vote here Support for TFS keyword expansion"

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Team Foundation Server Support for Keyword Expansion

posted Thursday, November 30, 2006 6:44 PM by SimonSabin with 0 Comments

Variable substitution in Data Dude Scripts

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Variable substitution in Data Dude Scripts
The new RSS feed is here

One of the great aspects of Data Dude is that it uses SQLCmd to run the scripts. This means that it can use the variable substitution. One gotcha however is that Data Dude tries to be clever and validate your code before the substiution. This means something like.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Variable substitution in Data Dude Scripts

posted Thursday, November 30, 2006 6:02 PM by SimonSabin with 0 Comments