August 2005 - Posts

VB.Net to c# converter and vica versa

Just found a great converter of code from vb.net to c# and vica versa on www.developerfusion.co.uk

http://www.developerfusion.co.uk/utilities/convertvbtocsharp.aspx

and

http://www.developerfusion.co.uk/utilities/convertcsharptovb.aspx

posted Wednesday, August 24, 2005 7:14 PM by SimonSabin with 4 Comments

UK Developers going to the Microsoft PDC 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/UK Developers going to the Microsoft PDC 2005
The new RSS feed is here

 If your going to the PDC let use know post your details below as a comment

Will try and get a wiki set up at some point.

Mike Tauly has setup a wiki for this see his post http://mtaulty.com/blog/archive/2005/08/26/8860.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/UK Developers going to the Microsoft PDC 2005

posted Wednesday, August 24, 2005 6:58 PM by SimonSabin with 0 Comments

Usergroup presentation an express train of SSIS packages

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Usergroup presentation an express train of SSIS packages
The new RSS feed is here

So I did my presentation in the swimming pool at MS in Soho tonight and judging by the feedback it went well.

I covered a lot of stuff and so had to go pretty quick and the pub was waiting,but I was happy with what I covered. Someone mentioned that it was quite impressive to build a package in 40 minutes, I realised that I actually built 2, quite complex packages in this time an explained a load of stuff about SSIS, this is all possible due to the flexibility and ease of use of SSIS.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Usergroup presentation an express train of SSIS packages

posted Wednesday, August 24, 2005 5:54 PM by SimonSabin with 4 Comments

Using the Foreach Loop with files in SSIS

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Using the Foreach Loop with files in SSIS
The new RSS feed is here

The Foreach Loop in SSIS is not the most intuitive of editors in the SSIS suite. There is a nice article on SQLIS.com, with pictures, explaining how to use it and how to use variables to set connection strings etc.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Using the Foreach Loop with files in SSIS

posted Tuesday, August 23, 2005 6:35 PM by SimonSabin with 0 Comments

Insert, Update and Deleting in a View in SSMS

Erland is looking for support on the ability to be able to insert, update and delete rows in a view when there is an instead of trigger on the view.

http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx?FeedbackId=ab8e717d-8087-4337-9c27-1b4aa12a47f5

I think this is a usability issue and I find it out that MS say they won't fix it. Bottom line is anything is possible and this is just not nice behaviour in a user friendly product.

posted Tuesday, August 23, 2005 5:41 PM by SimonSabin with 0 Comments

SSIS presentation at the UK Usergroup

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS presentation at the UK Usergroup
The new RSS feed is here

I will be doing a presentation on SSIS at the UK SQL Server Usergroup tomorrow evening.

http://www.sqlserverfaq.com/

I will be doing a brief overview of SSIS and a fes of the components in SSIS. Trying to convey is power and flexibility.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS presentation at the UK Usergroup

posted Tuesday, August 23, 2005 5:12 PM by SimonSabin with 0 Comments

Script task to find column lengths

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

' Microsoft SQL Server Integration Services user script component

' This is your new script component in Microsoft Visual Basic .NET

' ScriptMain is the entrypoint class for script components

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Script task to find column lengths

posted Sunday, August 21, 2005 6:42 PM by SimonSabin with 0 Comments

Finding objects with a certain name

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Finding objects with a certain name
The new RSS feed is here

Jamie has talked about finding objects reference in SPs and a bit of SQL for this http://blogs.conchango.com/jamiethomson/archive/2005/08/17/2031.aspx. I find that I put these in an procedure prefixed sp and put in master I can then use the shortcut features in Query analyser and SQL Server management studio to execute the sp against some highlighted text.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Finding objects with a certain name

posted Friday, August 19, 2005 1:05 PM by SimonSabin with 0 Comments

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