Bartosz Kowalski's Q&A profile

• SQL Server memory

  Hi, can anyone point me in the direction of any articles or whitepapers that give some ideas on memory requirements for running SQL Server 2005 analysis services. Say we have 250 concurrent users, can anyone tell how much memory I would require. I know this will also depend on cube sizes and number of dimensions, in our case we have approximately 20 AS databases with an estimated 300 cubes in total. Some of the dimensions get up to 100,000 members. Thinking that 3gb (32bit mode) isn't going to cut it and we will need to run in 64 bit mode for the additional memory availability. Need some help with concret figures, and how I can prove that we need to run in the 64bit mode. Any assistance much appreciated. Thanks Mick ...Show All

• Commerce Server CommerceProfileSystemException: Failed to retrieve profile.

  We are receiveing this message on a new site we deployed in our production environment. We packaged this site in our development environment and unpackaged the site on our production server without errors. All permissions are set correctly and all 4 Web Services run accordingly. However the website throws this error. I have not been able to find any information or anyone that has run into this problem before. Any one have any idea why this is happening The only issue that may be related is the fact that i had some trouble getting the ProfileKeyManager tool to work correctly. Per documentation instructions, i tried to generate a new key and write it to a file to then encrypt it and write it to registry. Whn trying to use ...Show All

• Community Chat Kyro KidSafe Browser (alpha)

  Hello all, I am making a "KidSafe" browser for kids. Please download my program and post any noticed bugs,etc.  It takes only minutes to set up.  I am 10 years old, so who can make a browser for kids better than a kid Progress:  Final will be started in January Thanks you everyone for your contributions  and encouragement.  *Has 3 tabs for browsing. *Has a "My Websites" button with up to ten of your programmed websites in it. Beta Features: *Has 3 tabs for browsing. *Has a "My Websites" button with up to ten of your programmed websites in it. *Talking Help guide *A new install program Updates in final version: *Button text replaced with graphics. *A game room with games, and fun KidSafe software (suc ...Show All

• Visual Studio Tools for Office F5 -> "File already exists"

  Hi, I'm new with VSTO development and been experiencing this really annoying issue. Everytime I hit F5, it launches the Excel document associated with the project. However once Excel launched, it often (not all the time but quite often) gives me the "File already exists" error message. I then must open the Excel file manually from File -> Open. Everything works then. Strange that it doesn't do this all the time, just occasionally. Any ideas Cheers, Victor Yes, for both Word Doc & Excel. Once loaded 'properly' they're working just fine though, so no drama there, but still really really annoying that I have to keep clicking OK and re-open the Office doc. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Tile Engine Tutorial Part 4!!! - Map Editor!

  We have just posted part 4 of our Tile Engine Tutorial by our own Kurt Jaegers! This installment replaces the current map array declarations with a simple map editor that will allow us to visually design and save a map using our tile sets. Part 4 also introduces to mouse input and control along with some basic text rendering... by the time you finish this tutorial you should be able to create your very own tile based map and save it... and reload it the next time you are in the application! http://www.xnaresources.com Rob, Thats true but right now we are really just looking for ways to use/learn/teach XNA/GSE... The map editor presents us a chance to do some things that you might not get to if we were to use an editor from ...Show All

• SQL Server Masking Password text in SQL Reporting Services

  I have designed a form and created two parameter fields to accept username and password from the user. Based on the values entered above, I am validating inside a stored procedure. I am unable to mask the text the user enters in the password field. I could not locate any mask property. Anybody can help me I strongly suggest you find a different way to get the user's credentials -- parameter values get passed around in clear text and are logged in the execution log, so you are endangering the credentials by harvesting them with report parameters. Also, there is no way to mask to entries in a parameter field. ...Show All

• Visual C# assembly file

  Hi everyone, I have again some doubts about assemblies. Suppose that w ecreate a class and then use some classes from different packages in this class. So, when I examine the references section about my project, I see that the all packages that I use is added into it. My question is that when I execute my program in the same class(in other words , my main method is located in the class that I use), do the assembly file, which is createn at the compile time, consist of the reference section and my own class Menawhile, I know that assembly file also contain metada and manifest but I refer to the IL part. Thanks Thanks for your clarifications. Now I think I kept the idea. References are different concept from Assemblies. They are like ...Show All

• SQL Server SQL 2005 and ELEMENTS XSINIL

  I don't know if the following behavior is because of my query, or is it normal. In the last case, please someone tell me if is there any way to remove it, as I'd like to keep the XML as small as possible. I am executing a SELECT statement with the "FOR XML, PATH" directive, obtaining the following result: <configuration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <celcos> <celco xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" id="1"> <contentTypes xsi:nil="true" /> </celco> <celco xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" id="2"> <contentTypes xsi:nil="true" /> </ce ...Show All

• SQL Server Excel Pivot Table for AS2005

  I try to use the Excel Pivot Table to retrieve the data from AS2005 cube data. I have install the Microsoft OLE DB Provider for Analsysis Services 9.0", but I get the following error message: Insitialzaiton of the data source failed. However, when I use the SQL Server Management Studio, I can browse the cube data. As a result, I know I have permission the access the cube data. Why the Excel Pivot Table is not working for me This schenario is pretty common and should be working. There got to be something wrong with components installed. Try applying the latest version of AS OLEDB provider from http://www.microsoft.com/downloads/details.aspx FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en Edward ...Show All

• Visual Basic Windows Service Monitoring Problem On Vista

  I've built a small utility to monitor the status of SQL Server Express and start/stop it and it works nicely on Windows XP SP2 and fuctioning great but when I've tested it on windows vista it monitors the service ok but I can't start/stop the service any more unless I use the Run as administrator command to start my tool I've used the folowing code to test my rights on windows My .User.IsInRole(Microsoft.VisualBasic.ApplicationServices.BuiltInRole.Administrator) but it gives me false - note that I've logged as an administrator to windows - is there is any way programtically make the program have administrator rights on windows so I can use all functionality of my little tool Thank You Alot ...Show All

• Smart Device Development Power off/on with EXE on SD Card

  If you run an EXE that resides on an SD card, then while it is running, you turn off, wait a few seconds/minutes then turn back on, will the app continue to work correctly or will it crash because the PPC had to remount the card and reassign file handles I developed an app, runs fine in main memory and runs fine on the SD card. However, when I power off, then on, the app will crash when it is on the SD card, but run fine it in main memory. Any docs, PDFs, URLs that go into detail about this issue Thanks, Hilton Ilya, To test if it was related to the EXE or accessing the data files, I copied the EXE into its own temp directory on the card with no data files. The app is intelligent enough to handle missing ...Show All

• Visual Studio Express Editions Running a program in conjunction with a batch file

  Hi All, This is a tricky situation... I wrote an application that filters through a input text file to remove any " and add new headings etc. It contains 2 inout text boxes for the 2 inout text files and 2 output files... After specifying the location of both an clicking on the filter button it filters and saves the files. My question if if you can run this program form a dos batch file to automate the process. i.e. normally what would happen is you could do something like c:\filter.exe -title -filename1 -filename2 -output1 - output2 But how do you encorporate this into the program Thanks This is the code for converting the files: Me .Cursor = Cursors.WaitCursor tspDate.Text = "Converting..." Dim tl ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Sprite Assets

  I havn't gotten around to trying xna yet as im still learning c# in my spare time. I was just wondering how people create there sprite assets, ie say your creating a space game do you use any specific software to create the ship then save it as an image file. Im pretty good with photoshop but drawing small sprites could be tricky is there any good apps designed to aid creating sprites Also is there a package which helps animate small sprites , say you want to create something exploding, I take it you would need different sprites for each part of the animation   Glenn Wilson wrote:   There are lots of different methods that you can use. One method that I use is to render my 3d obje ...Show All

• Visual C# Threading with semaphores

  Hi, I'm studying threads and i have a little problem with semaphores. I wrote a code using Mutex, and now I'm trying to replace with semaphores. But my semaphore doesn't work, I'm writing an example application, the threads are all locked in if statement... Here os the code: static void Main( string [] args) { Semaphore theSemaphore = new Semaphore (0,3, "semaphore" ); // Thread [] threads = new Thread [5]; for ( int i = 0; i < 5; i++) { threads = new Thread ( new ParameterizedThreadStart (Start)); threads .Start(theSemaphore); } Console .Read(); } public static void Start( object sem) { Semaphore semaphore = ( Semaphore )sem; ...Show All

• SQL Server Reporting Services and Sharepoint Integration - Sharepoint Alternate Access Mappings (Zones)

  I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone: System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. Is this a limitation of the SQLRS-WSS3 integration or is there a workaround Many thanks to anyone who can help! ...Show All