Bryant Likes's Blog

It's all about WebData

Recent Posts

Tags

News


  • Windows Live Alerts
    View Bryant Likes's profile on LinkedIn

    Me

    The posts on this weblog are provided "as is" with no warranties and confer no rights. The opinions expressed herin are the personal opinions of the individual authors and do not represent the views of Avanade in any way.

Community

Email Notifications

Archives

Posted: by

Comments

bryantlikes said:

A very good point made for all the software professionals ... A break once in a while can keep you healthy ...
# September 29, 2003 9:44 PM

TrackBack said:

SqlXml.org Home Page
# October 3, 2003 8:11 AM

TrackBack said:

Sam Gentile's Blog
# October 3, 2003 8:13 AM

bryantlikes said:

Welcome anytime ... :) ...

Your blog makes it even more interesting ...
# October 6, 2003 9:11 PM

bryantlikes said:

Hi Bryant,

I read your comments on my blog regarding meeting up tomorrow sometime. Do you mean Thursday?? If so, where do you think we can touch base??

Home Page URL:
http://www32.brinkster.com/srisamp
# October 29, 2003 2:20 PM

bryantlikes said:

I am curiouse if the "SqlXml in ADO.Net" will still need a seperate XSD schema, or will it integrate the SQL Mapping for fields, tables, and annotated relationships into the typed datasets schema.
# November 10, 2003 6:14 AM

bryantlikes said:

Good work wrt PDC notes ... Was hoping to get more from you when I read the thread subject ... :) ...
# November 17, 2003 6:51 PM

bryantlikes said:

Personally I dislike putting images into the database itself for the following reasons:

1. Small rows that could have been put on one page ( 4k ) would be now split over several pages because of the size of the image. This adversely affects performance.

2. Large images would be more appropriately stored on a single server. Having scaled out a database, it makes much more sense to just refer to a URI for the image such as:
//ImageServer/NorthwindDB/Products/ChaiZoom.jpg

3. For the most part, no processing is done on images beyond saving them to disk, retrieving them, and deleting them. The most common operation begin, of course, retrieval. Consider your average webpage, wouldn't it be easier to just put in a tag like:
<img src="//ImageServer/NorthwindDB/Products/ChaiZoom.jpg" />
than to actually read byte by byte from the db the image, and then write it out byte by byte to the webpage ?

Of course, if you do need to perform image processing, it <u>may</u> be appropriate to store it in the db. This is rare, from my experience.
# November 18, 2003 12:11 AM

bryantlikes said:

Thanks for the feedback!

I do agree, you take a performance hit by storing images in the database. However, I think it is a fair price to pay for the managability you get from storing images in this way. For instance, things like website portals or intranet sites where you have users managing images, it seems more robust to use a database.

I generally try to have a separate images table which helps (I assume) avoid some of the performance issues associated with page splits. Maybe for my next blog article I write up some performance stats to see what kind of price I'm paying.
# November 18, 2003 9:33 AM

TrackBack said:

# November 18, 2003 1:50 PM

TrackBack said:

# November 20, 2003 7:54 AM

bryantlikes said:

This ALWAYS happens to me.

I start writing a comment, it gets too long, and I write an entry on my blog instead.

You can find it here: http://udidahan.weblogs.us/archives/011400.html

I try to cover all the issues on the disk/db debate for images.

My bottom line: Disk is better.
# December 27, 2003 5:00 AM

bryantlikes said:

Hello Bryant,

I use SqlXml in a way that I've described in two posts on my blog.

http://www.alexthissen.nl/Weblog/PermaLink.aspx?guid=de819ad9-a666-4a96-9ede-e8651538cfbe
http://www.alexthissen.nl/Weblog/PermaLink.aspx?guid=83c8f964-f47d-48bd-b73c-1583e5f2fa6a

Let me know what you think of this. And, reading your Fun with deserialization, I figured I would have the same problem with binary columns. One of the shortcomings of this data layer I hadn't realized just yet.
# January 8, 2004 11:30 PM

bryantlikes said:

Hi,
I am using Bulkload to upload multiple relational tables, one table with Autoincrement PK. It worked fine. Now I need to Add a child table to it which has the Same PK field and has to be loaded from the parent.

Here I have scores table, whose Score_ID feild is autogenrated. I need to populate another TblScoreHistory table with scoreID and omr_scores fields. I tried with the relationship specifiled but didn't work. How do I define my Schema.

Thanks


MY datafile
<Score editflag="0">
<omr_score>*</omr_score>
<ScoreHistory>
<OrigScore>*</OrigScore>
</ScoreHistory>
</Score>



-------------------------

My Schema
<sql:relationship name="ScoresScoreHistory" parent="scores" parent-key="score_id" child="tblScoreHistory" child-key="ScoreID"/>

<xsd:element name="Scores" minOccurs="0" sql:is-constant="true">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Score" minOccurs="0" maxOccurs="unbounded" sql:relation="scores" sql:relationship="BookletPageScores" sql:key-fields="score_id">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="score_id" type="xsd:integer" minOccurs="0"/>
<xsd:element name="omr_score" type="xsd:string" sql:field="omr_scores"/>
<xsd:element name="ScoreHistory" minOccurs="0" sql:relation="tblScoreHistory" sql:relationship="ScoresScoreHistory" sql:key-fields="score_id">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="scoreid" type="xsd:integer" minOccurs="0" sql:field="scoreID" sql:mapped="true"/>
<xsd:element name="OrigScore" minOccurs="0" sql:field="vcscanvalue" sql:mapped="true"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
# January 16, 2004 1:19 PM

bryantlikes said:

Been a looong looong time Bryant. Nice to see you back here and at the XML newsgroups. Was wondering where you had vanished. :) And belated New year wishes and congrats on the new job.

Vinod
# February 4, 2004 6:56 PM

TrackBack said:

The daily list of stuff I found interesting while blogreading.
# February 9, 2004 7:49 PM

bryantlikes said:

Good luck with new job. I look forward to your comments on Sharepoint.
# February 12, 2004 9:17 AM

TrackBack said:

Moving FOR XML EXPLICIT to the new PATH mode (part II)
# February 19, 2004 11:36 PM

TrackBack said:

# February 20, 2004 9:27 AM

TrackBack said:

# February 21, 2004 8:20 PM

TrackBack said:

# February 21, 2004 8:20 PM

TrackBack said:

# February 24, 2004 11:32 AM

TrackBack said:

Take Outs: The Digital Doggy Bag of Blog Bits for 24 February 2004
# February 24, 2004 6:16 PM

TrackBack said:

# February 26, 2004 10:14 AM

bryantlikes said:

I ran into the same issue. JetBrains folks are looking at it.
# February 26, 2004 10:45 AM

TrackBack said:

Take Outs: The Digital Doggy Bag of Blog Bits for 26 February 2004
# February 26, 2004 11:38 PM

bryantlikes said:

ReSharper 69 addresses this issue.
# February 27, 2004 9:52 AM

bryantlikes said:

Cool. I will take another look at ReSharper...
# February 27, 2004 12:36 PM

bryantlikes said:

Hi Bryant,

Can you check help me on this specific feedback I recieved recently on the RSS.

http://blogs.sqlxml.org/VinodKumar/archive/2004/02/26/386.aspx
# February 27, 2004 11:35 PM

bryantlikes said:

Thanks for this, If you want it let me know.
# February 29, 2004 2:22 PM

bryantlikes said:

Perhaps our Snowflake.net component fits this need. It provides tons of wrapped up functionality for OLAP, however you, the developer, can choose how much of that functionality is exposed to the end-user. On the other hand the fact that the source is available with our Intellimerce source license means that there is also no dead-end in terms of implementing functionality that we might not already have. The list of functionality is too long for a post but most of OLAP front end actions are implemented and all within an MVC in asp.net with grid and charts synchronized. I hope you like it.
# March 1, 2004 4:17 PM

bryantlikes said:

I should have mentioned the company is Intellimerce Inc, http://www.intellimerce.com and the product is Snowflake.net.
# March 2, 2004 6:32 AM

bryantlikes said:

First, thanks for taking the time to post your learnings around RS and your feedback. It's appreciated by both myself and the rest of the SQL Server group. Second, thanks for being an RS customer. Keep sending feedback my way so we can keep building the product you really want and need.


Answers to your questions/comments below:

The toolbar. It would be nice if you could specify to get only certain parts of the toolbar and if you could load the toolbar by itself in another frame.
--> Great feedback. Something we can definitely look at doing in the future. Today, we can turn off the toolbar using URL commands.

It seems there is something strange with the report width and height. It seems like you always get an extra wide report even if you set it up to be narrow in the report designer.
--> We've never seen this before so you may want to raise an issue with product support.


Web Services - This is pretty straightforward, however, it doesn't work very well if you're trying to hit the web service from a another server by passing the Credentials. You end up not being able to authenticate since it is a double-hop.
--> You can use Basic Authentication to get to another machine. You can also use constrained delegation in Windows Server 2003 to allow the web server to logon as you on the other server. That's something you can try since I haven't tried it myself yet with RS.

3) Exporting to XML.

Haven't tried this yet. What would be a good reason to export this to XML?

4) Subscriptions and rendering formats.

These are also pretty easy to use. The email subscription doesn't seem to be compatible with Lotus Notes which is a real problem for us. Links do work, but they aren't as impressive as getting the full report in the email itself.

Some things I would like Reporting Services to do better:

1) Get some decent charting functionality. The way it currently works you can't even change the color of the chart items (you can only switch between pallettes).

2) Allow me to pass in the RDL to the Render function. There must be some way to do this since the report preview works in Visual Studio, but I haven't figured it out yet.

3) Provide some best practices for accessing the service via ASP.Net apps. I've heard that there are some Reporting Services Web Parts coming soon (which will solve a lot of problems for me), but how about some general guidelines on how to integrate Reporting Services into a web application.

Overall Reporting Services is a great product that we have been very happy with.



posted on Tuesday, February 24, 2004 11:55 AM

Comments
# Take Outs: The Digital Doggy Bag of Blog Bits for 24 February 2004
Enjoy Every Sandwich
Take Outs: The Digital Doggy Bag of Blog Bits for 24 February 2004
Posted @ 2/24/2004 6:16 PM

Post a comment
Title
Please enter a title
Name
Please enter your name
Url



Comments
Answers to your questions/comments below:

The toolbar. It would be nice if you could specify to get only certain parts of the toolbar and if you could load the toolbar by itself in another frame.
--> Great feedback. Something we can definitely look at doing in the future. Today, we can turn off the toolbar using URL commands.

It seems there is something strange with the report width and height. It seems like you always get an extra wide report even if you set it up to be narrow in the report designer.
--> We've never seen this before so you may want to raise an issue with product support.


Web Services - This is pretty straightforward, however, it doesn't work very well if you're trying to hit the web service from a another server by passing the Credentials. You end up not being able to authenticate since it is a double-hop.
--> You can use Basic Authentication to get to another machine. You can also use constrained delegation in Windows Server 2003 to allow the web server to logon as you on the other server. That's something you can try since I haven't tried it myself yet with RS.

Exporting to XML
--> A couple of good reasons to do it. Perhaps you want to control formatting of the report and use XSLT to transform it to HTML. Maybe you want to batch feed the report into another system that only supports XML. There are a bunch more.

Subscriptions - These are also pretty easy to use. The email subscription doesn't seem to be compatible with Lotus Notes which is a real problem for us. Links do work, but they aren't as impressive as getting the full report in the email itself.
--> We send MHTML and use SMTP. If Lotus mangles it, there's probably something that Lotus is not doing right. I've got a copy of Exchange Server I could send to you to help solve this problem :)

The do better part:
1) Something we're definitely looking at.
2) Create a temp copy of the report and then render it. Something we are also looking at for the future.
3) The Web Services API is the way to go here. The Web Parts are great for SharePoint but if you're using pure ASP .NET, the web services are your best friend.

Keep the feedback coming!

Tom








# March 17, 2004 12:11 AM

bryantlikes said:

Any luck yet? I have a similar problem (maybe exact) with one machine, but not another, so I have been developing on the good one and then moving the .rdl file and publishing with an .rss script...not ideal, but it works!

I get an reporting services install error that indicates:
Package 'VsReportDesigner Package' has failed to load properly ( GUID = {...

I've checked the registry and it seems to be pointing to the correct locations for the dll, but I cannot get reporting services to open in visual studio.
# March 19, 2004 8:54 AM

bryantlikes said:

Your "Double-hop"-problem is not about supported or not, this limitation is by design. If you use Kerberos delegation you can do multiple hops also with Reporting Services.

HTH,
Oliver
# March 19, 2004 10:05 AM

bryantlikes said:

This should fix your problem:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;837119

I had the same problem and installing this fix resolved it for me. Good luck.
# March 23, 2004 11:37 AM

bryantlikes said:

Thanks for the suggestion. The reinstall seemed to fix the problem.
# March 23, 2004 11:57 AM

TrackBack said:

# March 23, 2004 7:05 PM

TrackBack said:

# March 23, 2004 7:10 PM

bryantlikes said:

Difference made by .Net in Yukon? Unfortunately, very little.
# March 24, 2004 8:01 AM

bryantlikes said:

I had some of the same problems.

http://www.lazycoder.com/weblog/index.php?p=45
# March 24, 2004 9:55 AM

bryantlikes said:

Thanks for the article! It really helped alot me in my project...
# March 29, 2004 2:29 AM

bryantlikes said:

I was wondering if you would like to share this webpart?
# March 31, 2004 10:27 AM

TrackBack said:

# March 31, 2004 5:06 PM

bryantlikes said:

I don't think I can really share the webpart since I built it at work, but perhaps I can write an article that details how to make client side webservice calls in a webpart.
# April 1, 2004 7:25 AM

TrackBack said:

# April 2, 2004 1:43 AM

TrackBack said:

# April 2, 2004 1:45 AM

TrackBack said:

# April 2, 2004 11:34 AM

TrackBack said:

Take Outs for 2 April 2004
# April 2, 2004 9:47 PM

bryantlikes said:

I must point out that this was a beta version of Confluence, and proper handling of licensing problems was added in a subsequent beta. Dumping a stack-trace isn't really the best way to deal with things like this. :)

As for the stack-trace, it's just a big dynamically constructed chain of responsibility. .NET hackers should definitely look at things like Spring and PicoContainer from the Java world: there's nothing stopping these containers from existing in .NET except for the fact that nobody's written them yet.
# April 5, 2004 5:20 PM

bryantlikes said:

Bryan,

I've pretty much consider it a given that anything Don Box talks about is based on "future bits".

Unfortunately all the Whidbey/Longhorn talk doesn't help me get work done today.

CassiniEx will allow you to host multiple web sites (with different hostheader/port bindings) similar to IIS. In fact the new Management Console I'm finishing up looks suspiciously like the IIS 6 MMC.

However, since NTLM authentication wasn't a big priority for me (most of my web apps use Forms Authentication) I haven't implemented it yet. I did come across some other implementations of NTLM authentications, so I'll have to see how easy it will be to integrate it.

Anyway, thanks for taking the time to evaluate CassiniEx. At least for me, it meets my needs, which is the ability to develop multiple web sites on Windows XP.

Kiliman
# April 13, 2004 1:47 PM

bryantlikes said:

BTW: Sorry for misspelling your name.
# April 14, 2004 5:06 AM

bryantlikes said:

No problem. Lots of people call me Bryan :)

CassiniEx looks great. Have you thought about putting it up on GotDotNet? The Web Protocol guys liked your project. I should probably post some of the results of conversation I had with them.
# April 14, 2004 9:28 AM

bryantlikes said:

Bryant, once I get it to a "feature complete" stage, then I'll probably put it on a more public server.

I like to hear what other people are saying. I've gotten a lot of favorable comments about CassiniEx.

I think this will at least hold us over until Whidbey is officially released.

# April 14, 2004 9:40 AM

bryantlikes said:

that would be great
# April 14, 2004 8:45 PM

TrackBack said:

# April 16, 2004 10:12 AM

TrackBack said:

# April 16, 2004 10:12 AM

TrackBack said:

# April 20, 2004 10:20 AM

TrackBack said:

# April 20, 2004 10:23 AM

TrackBack said:

# April 26, 2004 9:54 AM

bryantlikes said:

my first biztalk experience. thanks a bunch!
# April 27, 2004 12:35 PM

bryantlikes said:

Thanks for this - very interesting ... and i look forward to the next installment as this is a very useful topic you are addressing. Mark
# April 27, 2004 3:28 PM

bryantlikes said:

Thanks for this - very interesting ... and i look forward to the next installment as this is a very useful topic you are addressing. Mark
# April 27, 2004 3:29 PM

TrackBack said:

SharePoint has simple 'out of the box' workflow capabilities, but there suddenly seems to be an abundance ...

# April 27, 2004 3:36 PM

TrackBack said:

Take Outs for 27 April 2004
# April 27, 2004 6:41 PM

bryantlikes said:

Bryant, just wanted to drop a note to let you know that another developer sent me a patch to add NT Authentication to CassiniEx.

I'm making some other changes and hope to get that out in the next day or two.

Hope this will make CassiniEx even more compelling for you to use.

Kiliman
# April 28, 2004 5:17 AM

bryantlikes said:

I'm still digesting it, but it looks like a great writeup on getting started with this.
# April 28, 2004 11:33 AM

bryantlikes said:

Where the heck were you about 5 hours of frustration ago!!!!

THANKS A BUNCH MAN.
# May 3, 2004 11:26 AM

TrackBack said:

Take Outs for 9 May 2004
# May 9, 2004 8:02 PM

bryantlikes said:

Is it possible to do it by creating a Orchestation
# May 12, 2004 8:07 AM

TrackBack said:

# May 12, 2004 10:19 AM

bryantlikes said:

I know it is possible to do this with XML files via Orchestration, but it is a little more complex to do it with plain text files.
# May 12, 2004 10:34 AM

bryantlikes said:

Try looking at www.dsppanel.com
# May 13, 2004 11:46 AM

TrackBack said:

# May 13, 2004 2:28 PM

TrackBack said:

# May 13, 2004 2:31 PM

bryantlikes said:

i'm place youre cod to my Global.asax file, create the table and procedure, but i have the Server Error in '/' Application. Runtime Error
# May 13, 2004 11:10 PM

bryantlikes said:

Make sure that your connection string is correct. You cannot use integrated security so you will need to set a username/password. When you do this make sure that SQL Server is setup to use mixed authentication.
# May 14, 2004 7:25 AM

bryantlikes said:

>>This is something I plan on looking at real soon

Bryant,

Will you be posting your results back to your blog? I'd love to see your findings (always looking for a faster way to bulk load data)
# May 14, 2004 9:50 AM

bryantlikes said:

Hello Bryant,

You can add my blog to the list, as well as the WSS FAQ at http://wss.collutions.com

-Jim
# May 16, 2004 9:58 PM

bryantlikes said:

can you show me example of the connection string ?
# May 23, 2004 8:56 PM

bryantlikes said:

Thanks for the help on the first error about setting it to Activate. That had me stumped!
# May 26, 2004 12:14 PM

bryantlikes said:

Sure will! Sorry I missed your blog!
# May 26, 2004 5:22 PM

TrackBack said:

# May 27, 2004 4:46 PM

TrackBack said:

# May 27, 2004 4:48 PM

bryantlikes said:

# May 27, 2004 4:56 PM

TrackBack said:

# May 27, 2004 4:58 PM

TrackBack said:

RsWebParts Workspace
# May 27, 2004 5:12 PM

TrackBack said:

# May 27, 2004 5:41 PM

TrackBack said:

# May 27, 2004 6:26 PM

TrackBack said:

# May 27, 2004 10:22 PM

TrackBack said:

Reporting Services Web ???(SharePoint)
# May 27, 2004 10:50 PM

TrackBack said:

# May 28, 2004 5:45 AM

bryantlikes said:

Hi

I was wondering if you managed to come up with a solution to your problem?
I'm sitting in the same situation as you.

People have recommended Snowflake.net however my superiors are not too keen to on purchasing the licence for a product that can be developed by a member of our team.

Please could you offer some advice on a good route to follow.

Regards
# May 31, 2004 4:09 AM

bryantlikes said:

PLease, May I have a copy of ActiveViews code? I'm a MS Regional Director. I work closely with SQL andReporting services for big companies. I aldo deal with multilingual issues.

Any help will be most appreciated.

Regards
# June 2, 2004 8:19 AM

bryantlikes said:

You will need to email Tom Rizzo (see email address above) as I don't have access to the code.
# June 2, 2004 8:59 AM

bryantlikes said:

GOOD

HELP ME IN CREATING THE MENUS IN WEBPARTS AND PASSING WEBPARTS QUIRES TO ANOTHER PAGE.

PLS SEND POST THE SAMPLES
REGARDS
# June 3, 2004 4:41 AM

TrackBack said:

# June 3, 2004 6:59 PM

bryantlikes said:

I did everything the way you described but none of the events in my global.asax get triggered. Is there anything else I should do to make SharePoint use this global.asax?
# June 4, 2004 8:44 AM

TrackBack said:

Linked
# June 4, 2004 4:57 PM

TrackBack said:

Linked
# June 4, 2004 4:59 PM

TrackBack said:

Linked
# June 4, 2004 4:59 PM

bryantlikes said:

I got this baby to work! Many thanks for putting it together.
# June 8, 2004 11:22 AM

bryantlikes said:

Mario: What kind of security do you have on the site? Also, I would try commenting out the try/catch section so that you can see if you're missing the SQL error.

Denis: Here is the format I'm using:
DATABASE=[DB Name];SERVER=[Server];UID=[User Name];Password=[Password];
# June 8, 2004 6:14 PM

bryantlikes said:

Grate! We are looking forward to use this solutions sone.
# June 9, 2004 7:54 AM

TrackBack said: