Volta and Services

Today i read a nice article about Volta. In a very short sentence: Volta is a technolgy which will arrange tier splitting (Client-Server) for you. If you want to know more about Volta you should go to there site. One thing i liked very much is there opion about making request to a webservice. When you invoke a webservice from the client you use the XMLHTTPRequest object and when requesting it from the server you use System.Web.HTTPRequest object. A question mentioned on there site: Why should code that accesses services depend on where the code is running? aaaaaaah yeah. Never thought about it :(. Well they decided when you are building a Volta Application there is only one way to do it. It doens’t matter where the code runs. Pretty nice. Check the post out. Scroll down to the last paragraph “Invoking Services”.

Advertisements

SSIS: Using stored procedure or function in OLE DB source

Hi all, 

Right now I am doing a project with SSIS 2005 where we are building pretty cool stuff. Well I am not a very experienced SSIS developer so I ran into a very nice problem. I have to transport data from a SQL 2000 database to a SQL 2005 database. The dba created a stored procedure which gives me the incremental data from the SQL 2000 database. So I decided to use this stored procedure as the source of my SSIS package. At the end of the stored procedure there is a select * from #temptable. When I execute this stored procedure in the Query analyzer i see a lot of data divided into multiple columns. When I use this stored procedure as the source in my package and connect this component to the next component I receive a message. Something like do you want to proceed when you don’t have any input columns. Hmm a bit strange because the stored procedure does give me output columns. Well I found a very nice post who clarifies this problem. Check it out:

http://blogs.conchango.com/jamiethomson/archive/2006/12/20/SSIS_3A00_-Using-stored-procedures-inside-an-OLE-DB-Source-component.aspx

Because I was also working with SQL 2000 and wanted to check the metadata of the stored procedure I had to change the check query a bit, but this post was very helpful

SQL2000

select o.[name], c.* from syscolumns c
inner join sysobjects o on c.id = o.id
where o.[name] = ‘dbo.usp_COPArbeidsrelatieIncrementeel’

instead of: (SQL2005)

select o.[name], c.* from sys.columns c
inner join sys.objects o on c.object_id = o.object_id
where o.[name] = ‘dbo.usp_COPArbeidsrelatieIncrementeel’

VS 2008 Javascript debugging

Like all developers i read the blog of Scott Guthrie and saw more interesting stuff about VS 2008. We already knew that there will be Javascript intellisense available in VS 2008, but Scott shows some more details about it. There are a couple of cool feautres and two of them i am very excited about Script document navigation in the solution explorer and breakpoints in embedded javascript. In VS 2005 you are able to use the script explorer this is another pane that isn’t standaard visible in VS 2005. This explorer show all the scripts that have be loaded into you webpage. In VS 2008 this will be standard available and integrated in the solution explorer. Very cool!!

In VS 2005 we can’t set breakpoints in the JavaScript that is embedded in your HTML, only if you have JavaScipt in another file you are able to set a breakpoint. When it is embedded you have to work with keywords like ‘debugger’ or ‘Sys.Debug.fail(‘FAIL’)’. In VS 2008 it is possible to add breakpoints to embedded Javascript. So working with Javascript will be more and more like working with C# in VS 2008. Check the blog of Scott Guthrie

Visual studio Orcas Javascript intellisense

The last few weeks i saw some posts about Visual Studio Orcas, everything looks great but i was to busy to really look at it. Well when i read the post of Scott Guthrie and saw a video at asp.netpodcast i was very enthousiastic about the Javascript intellisense that will be available in Visual Studio Orcas. This will make live easier when we are working with scriptlibraries of MS Ajax and our own javascipt files. You have take a look at the video and the post of Scott. Today i downloaded Visual Studio Orcas Beta 1 and i will take a look at it!! (can’t wait)

Unittest why?

These weeks when i have some time i’am reading the book Introducing Visual Studio 2005 Team System by Richard Hundhausen. Well right now i’am at the chapter where the Test edition of the Team Suite is discussed. I think that Richard has a very good example why every project should make unittests. I’am a developer who is a proponent for unittests, but i also know some developers that are complaining that the creation of these tests is time consuming. Well if you have to persuade other developers use Richards example. He makes a comparison between a project with unittests and a car with brakes. Do brakes make you drive slower? NO they make you drive faster because you are confident that there is a way to stop. Well this is the same situation with unittest. Unittests can make you feel more confident to make changes to existing code. When you run the test and everything is still working well it means that you didn’t break anything. So developers use unittests 🙂

Intoduction

Hi all,

I would like to welcome you to my first webblog. The reason why i started this webblog is that i want to share the knowlegde that i have and that i will get in the future with you. Right now i’am focussing on a few categories that i’am interested in: MS Ajax, Visual Studio Team System and .NET2.0. Well i will try to write some interesting posts and hope you will enjoy it!!

Regards,

Dennis van de Laar