I'm not sure if this is the correct forum to post this in but here it goes. I'm working on designing a more robust ETL process for our Enterprise Data Warehouse. The idea is, there would be two servers set up as primary and secondary dispatchers along with (n) number of client listeners. I would like to be able to have each listener perform some SQL Query and/or a stored procedure using the resources on that specific machine in an effort to maximize both ETL process speed and resource utilization. My question is: Is this a situation where I could/should use a Parallel Data Warehouse architecture? I wouldn't really want, let's say, 20+ computers all performing rather large queries against the same SQL Server instance... that would negate any performance gains I may get from a Distributed architecture. Thank you for reading this and I appreciate any information you could provide.

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

I agree 100%. At most you could copyright a specific brand but not an idea who's origin is generic in both concept and application. Ideally this application will evolve into a much more complete plug-in for both existing and new ETL/Data Warehousing solutions. Thanks for your reply!

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

I would like to thank everyone for their feedback. A lot of people brought up ideas that I hadn't thought of before. I think my best course of action would be to finish up the application and offer it up to beta testers and see how much (if any) interest there is in the marketplace. Thanks again!

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

I would never provide either of these to a non-technical end user as a solution. Considering the maintenance and permissions required along with always having to know both the source and destination. Neither of these would be a viable solution. They also would not provide an easy "wizard like" way to apply custom filters and rules to generate separate exports. Nor would they give the users an easy way to view the results before exporting. bcp is great as long as you always know your source and destination. Both the source and destination also need to "look the same". SSIS in some situations may work if this were strictly ETL and was being used/maintained by the IS staff. However, as a non-technical end user environment. This would never work. Here again, you would need to know the source and destination. If anything were to change, it would require a change to the package. It's more of a "right tool for the job" kind of deal. The application I created allows you to easily apply rules and/or filters to data. It allows a user to create different exports from the same source data. The application does not care what the source or destination are and the size of the file is a non-issue as well. If you are a technical user, you can provide column widths and data types but it's not necessary or required. You can import from any source and export that information to any source (n) times. Thank you for the feedback.

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

What's the best way to find beta testers?

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

Well, that's a good question :) Microsoft doesn't have any tools that are really good/efficient at importing huge files (~5GB). Especially if the user using the tool is non-technical. The file I was importing had ~320 columns with ~5m rows of data. I tried using the Import wizard build into SQL Server Management Studio. Once you finally got past all the errors and crap it took almost 8 hours to import. Even if this had worked, I wouldn't be able to ask a non-technical user to use Management Studio... So, I created an application that would allow a non-technical user to do this. My application can import the full file in ~45 minutes. Plus, I was able to build in a ton of nice features that would benefit both the technical and non. I've worked with SQL Server and Visual Studio for 14 years now. Honestly, I don't know if I could market this to Microsoft. I've just worked with their software for so long. They are the company that popped in my head. thanks for your reply!

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

Hello all. I've been doing a bunch of looking around but I can't really find an answer to my question. I would like to create an application written for Windows using the .NET framework and WPF with an SQL Server backend. I've read online that creating and selling your own software can be very expensive. You will need to trademark your idea and apply for a patent in order to make sure you retain all the rights. You will also most likely need to retain a lawyer to make sure all your t's are crossed. So, considering all the above, I have 2 questions. Does anyone know of a "beginners" guide for creating and selling your own software? If I just wanted to sell it outright retaining no rights. How could I market the application to a company like Microsoft without them just taking the idea and developing it on their own? Thanks all for reading this. I appreciate any help.

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

I recently upgraded from VS 2005 to VS 2008 and found a lot of problems. The major issue i'm dealing with now is "Error Creating Control" Here is an example: HTML <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <ASP:SCRIPTMANAGER ID="ScriptManager1" runat="server" /> <div> </div> <ASP:REPEATER ID="Repeater1" RUNAT="server"> <ITEMTEMPLATE> </ITEMTEMPLATE> </ASP:REPEATER> </form> </body> </html> In the designer I get the following error message on the control: Error Creating Control - Repeater 1 Property 'ITEMTEMPLATE' does not have a property named 'MAPID'. Does anyone know how to fix this? Any help would be great! Thanks, Will

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

Having done a search both here and google I have found a ton of information about using HttpPostedFile. I have a situation where users will be uploading drawing files. Most of the time these files will not be very large, there are however those few people that continue to use Solidworks and create files that are 100Mb and up. Now I would just increase the max Http Request length but considering that I could have several people trying to upload huge files at the same time...this could get me in trouble. I am not sure what to do...I am not able to use any 3rd party plugins or activeX controls... Any ideas would be great.... Thanks, Will

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

Calculating the mean and median are a fairly easy task. Standard Deviation is a little harder. What do you need help with, exactly what don’t you understand how to do? Before you answer that, write out some pseudo code and go through the logic. Post a specific question that proves you have attempted this on your own, otherwise I don’t think you will get much help. If you need links to information for standard deviation you can find more then enough information using google. However, I will start you off. http://www.med.umkc.edu/tlwbiostats/variability.html#deviation[^] Good luck and enjoy the challenge. will

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

Yes I would like to solve the problem I have presented. Thank you for the advice. I am taking notes and will try again. I will also look into formulas for acceleration as it never occured to me to do so. Will

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

I posted this in the wrong section, but have deleted that message and moved it here. Here is a link to the definition of the Snowball effect: Here[^] -- Good morning, afternoon or night depending on what part of the world you are from. I have been spending a lot of time thinking about the snowball effect. Now it would seem relativly easy to simulate the snowball effect using some C# Kung Foo but..alas it is not. My Question: 1) I know the Size(s) of the object at it's smallest point. 2) I know the distance(d) the object will travel 3) Force of gravity on the initial object What I dont know: 1) Increase of both Mass(m) & Size(s) as the object Travels for a specific distance(d) 2) Increase of Speed(s) as the Object gains in both (m) & (s) 3) Distance(d) and Speed(s) required for the object to gain a specific Mass(m) and Size(s) I have tried to make the rate of increase(i) in mass(m)&Size(s) linear. So the object will increase(2x) the initial Size(s) for each Foot(d) traveled. But I am unable to calculate the increase of speed(s) as the object moves because of a missing component...Time(t). Can anyone think of a good way to simulate the Snowball effect? Thanks, Will

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

FOR %i IN DO FINDSTR /s ".com"* "%i">>C:\OutputFromSearch I think that will work...give it a try

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

I think I have answered my question by trying to explain what I wanted to do. Thank you for getting back to me soo soon. Will

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

Hello my fellow CPians. I have read articles on creating templates and user controls but I dont think that will solve my problem, so I figure what better place to ask then here? The best way for me to explain my problem is with an example. Lets say I have a widgit. This widgit has 3 pieces, each piece has it's own characteristics.. What I would like to do: The Page will bring up general information about the widgit it's self. Then under that a multipage strip with a tab for each piece. Click on the tab and a Page gets generated using a template page with the controls and eye candy required. These generated pages will need to interact with the server to get and update information. Is it possible to create a template page that has all the controls I need then use that page to generate new pages on the fly? I really dont want to have to keep re-writing the same code over and over again. Each page will be exactly the same. Thank you for your help, Will O'Malley

I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

SELECT name FROM master.dbo.sysdatabases Will I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

lol... I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

When you open a new window you have the ability to force execution of code on the parent. What you will need is the ability to force a post back event. Add a hidden button to your form. Click on the button and create the click event. The method that will be executed will reload the data for your datagrid. Now Add the following to your first page. function reloadInformation() { __doPostBack('btn1','Click'); } Like I said the click event will reload the data. Now on your popup page. We are going to need to execute some script once your update had run. To do that we will use the Page.RegisterClientScriptBlock event. private void btn1_Click(object sender, System.EventArgs e) { string scriptString = ""; // do work // ...... // // scriptString = "" + Environment.NewLine + "window.parent.execScript('reloadInformation()')" + Environment.NewLine + ""; Page.RegisterClientScriptBlock("clientscript",scriptString); } References: registerclientscriptblock[^] Window Object[^] Hope this points you in the right direction.. Will I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

question: Do you have to use a HyperLinkColumn or can you use a label? Here is my suggestion: You have a datagrid right? Please note: Extra spaces were added so this shows up correctly. <--- Control ---------> <-----------------------> <------- JavaScript ----> function sendMe(Item) { var windowParameter1 = Item.getAttribute("FirstValue"); var windowParameter2 = Item.getAttribute("SecondValue"); window.open("Candidatedetails.aspx?id=" + windowParameter1 + "&istatus=" + windowParameter2); } <-----------------------> Please let me know if this helps Will I hate users. Not all of them, just the ones who talk.CP member: Al Einstien

Now there more and more informtion and examples are poping up about AJAX I think it would be a good idea to create a place where we can post questions, examples...ect When can we expect an AJAX forum? Will I hate users. Not all of them, just the ones who talk.CP member: Al Einstien -- modified at 18:27 Friday 10th February, 2006