Thursday, August 18, 2005 - Posts

Foreign Key to column on table that allows NULLs

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Foreign Key to column on table that allows NULLs
The new RSS feed is here

Someone  asked on the SQLServerfaq.com how to have a table that allows nulls but the remaining values are unique and then have another table reference this column as a foreign key. I initially was going to say no way not possible, but then got thinking.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Foreign Key to column on table that allows NULLs

posted Thursday, August 18, 2005 7:57 PM by SimonSabin with 0 Comments

Interested in how SQL Server 2005 indexes XML data

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Interested in how SQL Server 2005 indexes XML data
The new RSS feed is here

In SQL server 2005 there are a number of extra restrictions imposed on the size of keys in tables when using XML indexes.

John has a good post on what they are and why. He also does some interesting stuff with the new system tables so whow you waht has been created when you index an XML column

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Interested in how SQL Server 2005 indexes XML data

posted Thursday, August 18, 2005 5:55 PM by SimonSabin with 0 Comments

Team System working with SQL Server Analysis Services 2005

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 System working with SQL Server Analysis Services 2005
The new RSS feed is here

I haven't looked into Team system, or analysis services either really, but this blog entry on how team system is using analysis services to provide analysis capabilities on the data in team system is still interesting.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Team System working with SQL Server Analysis Services 2005

posted Thursday, August 18, 2005 5:05 PM by SimonSabin with 0 Comments

Reporting services report pack suggestions

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

So a number of report packs have been released one for IIS, one for sharepoint (i think). What packs would you like in the future. Mat Stephen (IT Pro Evangelist) is looking for request to put in the pot. Go to his blog for info .....

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Reporting services report pack suggestions

posted Thursday, August 18, 2005 4:50 PM by SimonSabin with 0 Comments

Windows Server 2003 SP1 Service Permission problem

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Windows Server 2003 SP1 Service Permission problem
The new RSS feed is here

Do you have applications that monitor the status of services on your servers. If those applications are running as non-administrator users then if you apply SP3 it is likely they won't work any more. (i.e. if doing things properly using non-admin users you may be stuffed)

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Windows Server 2003 SP1 Service Permission problem

posted Thursday, August 18, 2005 12:07 PM by SimonSabin with 0 Comments