Bryant Likes's Blog

A very good point made for all the software professionals ... A break once in a while can keep you healthy ...

SqlXml.org Home Page

Sam Gentile's Blog

Welcome anytime ... :) ...

Your blog makes it even more interesting ...

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

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.

Good work wrt PDC notes ... Was hoping to get more from you when I read the thread subject ... :) ...

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.

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.

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.

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.

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>

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

The daily list of stuff I found interesting while blogreading.

Good luck with new job. I look forward to your comments on Sharepoint.

Moving FOR XML EXPLICIT to the new PATH mode (part II)

Take Outs: The Digital Doggy Bag of Blog Bits for 24 February 2004

I ran into the same issue. JetBrains folks are looking at it.

Take Outs: The Digital Doggy Bag of Blog Bits for 26 February 2004

ReSharper 69 addresses this issue.

Cool. I will take another look at ReSharper...

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

Thanks for this, If you want it let me know.

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.

I should have mentioned the company is Intellimerce Inc, http://www.intellimerce.com and the product is Snowflake.net.

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

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.

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

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.

Thanks for the suggestion. The reinstall seemed to fix the problem.

Difference made by .Net in Yukon? Unfortunately, very little.

I had some of the same problems.

http://www.lazycoder.com/weblog/index.php?p=45

Thanks for the article! It really helped alot me in my project...

I was wondering if you would like to share this webpart?

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.

Take Outs for 2 April 2004

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.

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

BTW: Sorry for misspelling your name.

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.

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.

that would be great

my first biztalk experience. thanks a bunch!

Thanks for this - very interesting ... and i look forward to the next installment as this is a very useful topic you are addressing. Mark

Thanks for this - very interesting ... and i look forward to the next installment as this is a very useful topic you are addressing. Mark

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

Take Outs for 27 April 2004

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

I'm still digesting it, but it looks like a great writeup on getting started with this.

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

THANKS A BUNCH MAN.

Take Outs for 9 May 2004

Is it possible to do it by creating a Orchestation

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.

Try looking at www.dsppanel.com

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

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.

>>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)

Hello Bryant,

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

-Jim

can you show me example of the connection string ?

Thanks for the help on the first error about setting it to Activate. That had me stumped!

Sure will! Sorry I missed your blog!

I've now shared them!

http://blogs.sqlxml.org/bryantlikes/archive/2004/05/27/629.aspx

RsWebParts Workspace

Reporting Services Web ???(SharePoint)

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

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

You will need to email Tom Rizzo (see email address above) as I don't have access to the code.

GOOD

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

PLS SEND POST THE SAMPLES
REGARDS

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?

Linked

Linked

Linked

I got this baby to work! Many thanks for putting it together.

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];

Grate! We are looking forward to use this solutions sone.