bitskull's Q&A profile

• SQL Server Benchmark of SSIS

  Hi, Has anyone seen any benchmark results for SSIS vs Informatica Thanks, David Mariner Okay, well, the one thing SSIS has going for it is its bias towards using SQL Server databases, and rightfully so. They may have Informatica there, however as of yet, SSIS is not a competitor when using other database platform destinations. So, room to grow if they want. Jamie, I hear ya though! My comments were based on years of experience with first-gen products, MS software notwithstanding. ...Show All

• Visual Studio Team System How To Generate Sales Data

  I want to generate sales data where different product will have different price in diferrent date. Let say I have a Product table to store the MinPrice and MaxPrice of each product. How do I generate the data so that the price is in the range of MinPrice and MaxPrice for each product Thanks. Jimmy Hi Jimmy, I am trying to think of the right way to do this, but I have another question. How are you currently doing this in SQL What kind of constraints do you have on the price column to enforce this Thank you, Nicole Johanson ...Show All

• Visual C++ Function try blocks result in compiler wackiness?

  I have some code that uses function try blocks, but VS C++ 2005 apparently is ill-equipped to deal with these. An older KB article, Q241706 - http://support.microsoft.com/kb/241706/ - indicates that this was a problem with some previous versions of VS C++, but further web searching leads me to believe that this was supposed to be fixed for 2005. Can we look forward to a fix for this problem soon Thanks, Barry The sample code from the KB article you cited compiles okay in VS 2005 which would seem to indicate that the problem has been addressed - at least to some extent. There may be a bug in the compiler (or a difference of opinion about how FTB should be implemented) , or there may be a problem with t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rendering Question

  first of all, I'm using d3d 9.0 C# 1.1 And now to the problem: I'm writing a little application in which i parse a dxf file (contains geomtry information) and render it. the application allows pan, tilt and zoom. big dxf files containes thousands and more entities. at the moment I'm rendering the entities to a texture and then I'm rendering the texture. the problem is when i render on a texture with a X8R8G8B8 format it acts like a bitmap - which means, when I'll zoom in the objects (for example lines) will become thicker. (I want them to stay at the same size). I saw that there's a format called VertexData but I couldn't create a texture with that format. I would like to render it staright to the device, but every cycle of ...Show All

• SQL Server Is there any way that you could search for a value in any nodes within your xml data type?

  Hi everyone, I was wondering if there is any way that you could search for a value in any nodes within your xml data type without actually knowing what nodes you have or how many there are. Please provide sample query for it if possible. Thanks. An open ended querying of xml that has some "value" isn't trivial. For example, if your xml is semi-structured and has mixed nodes, the above query might return results you didn't expect. The following query will return the element foo. That is because foo has two text() nodes and the = is the existential operator. Again, this could be what you want anyway. Also, this query doesn't find the attribute bar. select convert(xml, '<foo bar="a ...Show All

• Visual C++ Memory leaks in managed classes that use dynamically-allocated native structures

  I apologize for the textbook question but I have spent enough already looking for the answer in the "textbook" (MSDN) not finding the answer that I decided to ask here, I hope you don't mind throwing in a quick answer. I am forced to use dynamically-allocated native data structures in managed classes and I am getting memory leaks because I am not properly freeing the allocated resources. I was hoping to add a destructor to the managed class but that didn't help - the destructor was never called when the object was destroyed. After reading the article "Changes in Destructor Semantics" in the Library, I still can't figure out why (note: VC++ 2005 is my first interaction with .Net – I skipped 2002 and 2003). I know there is more than one ...Show All

• Visual Studio 2008 (Pre-release) Project Crashs Upon Open,Close and Reopen Window2

  My project Crashes at a certain sequence of user events...Press the RSSButton and Window2 Appears,Close the Window than press the RSSButton Again to ReOpen Window2..Thats when the Project Crashs completely,I did a Build of the project to check the performance of the application in the Task Manager (Mainly for Memory Usage)... So theirs a problem here and i'm not sure what is causing the program to crash when you Open,Close and ReOpen Window2.. Here is some of the Code Window1 EliteBar.Window2 eB = new EliteBar.Window2(); private void RssShowButtonClick(object sender, RoutedEventArgs e) { eB.ShowDialog(); // Also Tried eB.Show(); get the same Results } Window2 private void XbuttonClick(object send ...Show All

• Visual Basic Problem with adding new records in Database while saving changes on exisiting ones works!

  Hello, I'm developing an application which handles an Access database and I can't save a new record in any table of it though I can save changes that I do in it! I am using the following code to add a new record: Me .HUMAN_RESOURCESBindingSource.AddNew() and I'm using the following code to save my changes: Me .Validate() Me .HUMAN_RESOURCESBindingSource.EndEdit() Me .HUMAN_RESOURCESTableAdapter.Update( Me .DATADataSet.HUMAN_RESOURCES) which is exactly the same that I use to save my changes when I edit a record. While the code works perfectly on saving my changes to existing records, it doesn't work when I add a new one! I also tried to add a new record with the BindingNavigator but I get the same ...Show All

• Visual C# Compiling Java code from C#.net

  Hi, How can i compile java source code from C#.I should not use any .java file for compilation. Just i am writing java code in text area and whenever i click compile button, it need to compile from c# and if any errors it need show.Here i should not use VJ# compiler also. Please let me know the solution ASAP. Regards, Hanumanth Reddy.k Hi You wont be able to compile a .java file in VJ#, you have to create new project. VJ# uses the .net framework runtime to compile its not the same as Borland Java where you would write a java code in a txt file save as .java and compile it using cmd to create a class file staff like that. Hope this can give you ideas. ...Show All

• Visual C# strange excepstion

  I've an app that have been written in vs 2003, today I convert it to vs 2005 but when I want to run this program (in debug mode or not) this exception occurred. Ex.Message: "DragDrop registration did not succeed." What's wrong in my app that cause this exception Please do the following, 1) include the following using System.Net; using System.Threading; 2) add the [STAThread] Attribute just before ur main function and also remember to inlcude using System.Net; in ur main program, [STAThread] static void Main() 3) The steps are as follows for threading, 1. Put all the code ( for which u r getting this exception) in one function say function A. In the function B in which u are calling ur code,do the follow ...Show All

• Smart Device Development obfuscate CAB files

  Hello, I would like to obfuscate my assembly before deploying it to my PPC. Using Dotfuscator from the VS i created an obfuscated .exe. my question is how can i incorporate this .exe into the CAB setup wizard or what is the sequence for obfuscating the assembly I figure out that i can put several .exe (obfuscated or not) into one cab file. however when installing, windows mobile will treat the cab file as one programs even thu there's multiple .exe files. ...Show All

• SQL Server Ways/Suggestions for increasing the security for SQL server 2005

  Hi guys , is there any ways/suggestions for strengthen up the security for SQL server 2005 Due to several attacks from unknown places to my database's server , so I would like to get a way for increase the SQL security. Hope able to gather some info from web as well. Thx a lot guys. Best Regards, Hans Hi, that depends much on your infrastructure. You should consider -perimeter security -protocol security -Server security -Password rules -Application security -data encryption The more security you are about to implement the less possible it gets that you have a hacker / intruder on your system. But you will have to keep in mind that the more security you will implement, the more mai ...Show All

• Visual Basic Hi, Tailor POINT is a STRUCTURE with more than one property and is treated as a single item.

  Hi, I'm having trouble coming to grips with the use of arrays. This time I need to put a number of co-ordinate Points into an array. for example startPoint = 50,180 endPoint = 100,180 I've initialised my array : Dim arrowCoord(,) As Point = New Point(,) {} Then tried to input data with this. arrowCoord(0,0) = (startPoint, endPoint) I'm getting the error message that a ')' is expected at the comma between startPoint and endPoint. Would appreciate any advice. Whe I get this right I need to write the data to an Sql table, so would appreciate a little help with that also, as far as the extracting the data from the array. Thanks Tailor Hi, Here are valid and non v ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Easy question - refer to base variable from a component

  Hi, I know I'm going to kick myself when I see how to do this... but hey here goes - if I set up a public variable in my main game class, how do I view/use it from inside a component I'm using the default Component code from doing a new>GameComponent btw. I figured I'd just be able to do game.myVariable or similar, but I can't get the component to know anything about variables or methods in the class that created it. Cheers :) If you want to keep the component architecturally separated from the specific game subclass, the way to do that would be to publish the property you want to access as a service, using an interface that could potentially be implemented by any other game. That's the pattern we use ...Show All

• Visual FoxPro Printing to a Triumph-Adler

  One of my customers recently, bought a new printer, a Triumph-Adler DC2310, the printer runs fine with many applications, except with visual foxpro. It crashs VFP when I try to print. Anyone has a solution DaCosta. You may check to have the latest drivers for printer and check for CODEPAGE=<X>.X should have a value accepted by printer and vfp. You may check CODEPAGE with CPCURRENT (). You also may check fonts. ...Show All