November 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

CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user
The new RSS feed is here

If you encounter this

Could not obtain information about Windows NT group/user <MyDomain>/<MyName>, error code 0x5.

When you try and CREATE an ASSEMBLY, you might think well I'm not connected as that user. The user it sqawks about is the database owner.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user

posted Tuesday, November 28, 2006 11:18 AM by SimonSabin with 0 Comments

dmvs and CROSS APPLY

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/dmvs and CROSS APPLY
The new RSS feed is here

In SQL 2005 there is a new feature by which you can extend a result set with the results of another resultset. You might think thats nothing new because thats exactly what a join is, and with the combination of derived tables you have full control, and you can use table valued functions.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/dmvs and CROSS APPLY

posted Tuesday, November 28, 2006 10:26 AM by SimonSabin with 0 Comments

Taskpad view version2

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Taskpad view version2
The new RSS feed is here

This is a pure plagurism of Jaspers taskpad report. I have reformated the report to look like the taskpad in EM as close as possible.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Taskpad view version2

posted Thursday, November 23, 2006 9:28 PM by SimonSabin with 0 Comments

Developer Day 4

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Developer Day 4
The new RSS feed is here

If you've never been to a developer day then your missing a great day.

The day is split into a number of tracks with 5 sessions in each track. All the sessions are given by non-microsoft people and are generally based on real life experience, which makes the content great.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Developer Day 4

posted Thursday, November 23, 2006 11:49 AM by SimonSabin with 0 Comments

Role based Permissions view in Managent Studio

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Role based Permissions view in Managent Studio
The new RSS feed is here

Do you want the permission view that is avialble in Enterprise Manager for roles well you need to download Jaspers custom report which can be obtained from Jaspers blog custom-ssms-reports-in-sp2-database-permissions.aspx  You might also be interested in Enterprise manager task pad view and you can find a report that is similar to the task pad pane in EM here

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Role based Permissions view in Managent Studio

posted Thursday, November 23, 2006 12:51 AM by SimonSabin with 0 Comments

Taskpad view in SQL2005

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Taskpad view in SQL2005
The new RSS feed is here

Do you want the taskpad view in Management Studio then you need to download Jaspers custom report which can be obtained from Jaspers blog Enterprise manager task pad view and you can find a report that is similar to the permission pane in EM here custom-ssms-reports-in-sp2-database-permissions.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Taskpad view in SQL2005

posted Thursday, November 23, 2006 12:41 AM by SimonSabin with 0 Comments

The DBA is blogging

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/The DBA is blogging
The new RSS feed is here

On of the many things on discussion at pass was why Jasper aka SQLDBATips wasn't blogging.

Well it seems peer presure has won over Jasper is now blogging on sqlblogcast.com

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/The DBA is blogging

posted Thursday, November 23, 2006 12:29 AM by SimonSabin with 0 Comments

PASS 2006

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/PASS 2006
The new RSS feed is here

Thanks to all at PASS for making this years event a great success.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/PASS 2006

posted Sunday, November 19, 2006 3:12 PM by SimonSabin with 0 Comments

SQL Server documentation sucks

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server documentation sucks
The new RSS feed is here

If you think that SQL Server Documentation is lacking then make sure you provide feedback using the links at the bottom of the page. There is a big push to make sure the content of books online is what users want. There are regular releases of BOL which means that any suggestions you make you can be incorporates and available very soon.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server documentation sucks

posted Friday, November 17, 2006 11:05 AM by SimonSabin with 3 Comments