Yelnik's Q&A profile

• SQL Server Upgrade to SQL Server 2005 - Downtime needed?

  Hi We want to upgrade the Clustered SQL Server 2000 in our production environment to SQL Server 2005 (Clustered). Are there any complexities we need to take care of Do we need a downtime during the period when the SQL server is being upgraded Thanks Priyanka You'll need some downtime, and you'll want to carefully read the instructions in setup help. Run setup.exe and click the help button - there's information critical to clustered setup that isn't in BOL, so take your time and prepare. (I blogged about my experiences here: http://sqljunkies.com/WebLog/marathonsqlguy/archive/2006/04/19/20473.aspx ) It took me about an hour or so for each server in the cluster, and you can only upgrade one at a time, but once you've ...Show All

• Visual C++ GUI development using the win32 SDK

  I'd like to write some cool digital signal processing demonstration applications for students (I'm a DSP professor), and need some advice from VC experts like you. I know DSP and ANSI C++, but know very little about GUI programming in the windows environment. I think that .NET is not an option...it has very little sound support, and I need direct access to a double-buffered audio stream with, say, 20ms latency at 22kHz sampling speed. I want the programs I write to run on a plain-vanilla Windows XP machine with no special drivers installed (ie no special managed DirectX drivers) and I don't want to require the user to install the .NET framework if it does not come as a standard install on WinXP (and I don't think it does)...in fact, I d ...Show All

• SQL Server Upgrade scripts for SQL Server Mobile Databases

  I am looking for a tool that can generate upgrade scripts for all deployed versions of my db application. Does anyone know of such a tool Not sure if there is one that deals with .sdf files. This might work with .sdf file... http://www.red-gate.com/products/SQL_Compare/index.htm gclid=CJSQruT-z4cCFRRtQwodsA4-QA ( you can get a free trial) ...Show All

• .NET Development using statement on SqlDataReader

  Hi all, if I am to use the 'using' statement on a SqlDataReader where the resultset then gets passed outside of the method in which it was executed, will the 'using' statement still clean up the resources (close, dispose etc) although the SqlDataReader ResultSet gets passed out of the method What I currently have is below, but am not sure whether making use of the 'using' statement on the SqlDataReader will actually clean up its used resources. public static SqlCeDataReader ExecuteQueryGetDatReader(SqlCeConnection objSqlCeConnection, string strQuery) { SqlCeDataReader objSqlCeDataReader; try { using (SqlCeCommand objSqlCeCommand = new SqlCeCommand(strQuery, objSqlCeConnection)) { objSqlCeCommand.CommandType = Comma ...Show All

• Visual Studio Team System Solution in same folder as web project

  Hi, Added a file based web project, saved the solution file in the same folder as the web project then added to team server. (NOTE: Team server was quite happy about this and it works fine with no problems on my machine) When another user opens from source control, they pick a folder on their local machine but then visual studio "Remaps" the location of the project and creates another subfolder inside the existing folder and moves the web site into it. Is this becuase its not supported to have a solution file inside the web projects folders If so why did it let me add one like this NOTE: Using Final relase of visual studio and beta3 refresh team server. Thanks, MikeG Yes I just ...Show All

• Visual Studio Team System Does TFS support pure Kerberos environments?

  We are setting up a single-server deployment of Team Foundation Server (TFS), let's call that machine OURDOMAIN\TFSSERVER. Clients run Visual Stuido Team System (VSTS) and the client machines belong to the same AD domain. LAN authentication level has been configured with gpedit for all machines, clients and servers, to "Send NTLMv2 response only\refuse LM & NTLM". Further, Minimum session security for NTLM has been set to require "message integrity", "message confidentiality", "NTLMv2 session security" and "128-bit encryption". Unix servers manage Kerberos. 1) Is the above configuration supported by TFS (i.e. running TFS in a pure Kerberos ne ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Controlling Aspect Ratio

  So I was playing around with my XNA Control (1) for windows forms last night and got some sprites rendering based on some UI input (ie. press the "Add Sprite" button, file dialog comes up, and you pick a texture to add). I've got the control in a split container in the right pane. When I stretch the window, the sprites stretch right along with the window. The ideal behavior would be that stretching the window would simply give you more screen real estate. I'm imagining the way to figure this out will also apply to dealing with 4:3 vs 16:9 aspect ratios (2). Just need a few pointers on how to properly handle this :-) Thanks! (1)http://codecube.net/item.asp cc_itemid=314&searchstring=xna%20control (2)http://forums.microsoft ...Show All

• Visual Studio 2008 (Pre-release) Format of ActivityId

  Hi all, I am trying to handcraft messages to send to a WCF service (for a JS client sending JSON messages to a WCF endpoint that has a custom JSONEncoder on it) and I am looking to generate the Message headers. I see that MessageID and ActivityID are essentially GUIDs, and are added automatically by WCF. MessageID is from the Addressing namespace, and w3 define it as any URI (which seems to be done by prepending "urn:uuid:" to the generated GUID). So I am assuming that any unique identifier within that field will do. However, on investigating the ActivityID I see that it is a pure GUID in the SOAP, and this is confirmed by using reflector on System.ServiceModel.Diagnostics.ActivityIDHeader. Is this an essential header What is i ...Show All

• Windows Forms How to total up a column in datagridview?

  Hi, I have a datagridviewComboBox which specify the ProductName and after user choose the product, the Qty as well as Unit Price, the LineTotal will reflect the total amount for that row. I need to add up all the rows od LineTotal and put the total amount into a textbox. How can I go about doing this Thanks Hi, Thanks. It works. But now I am trying to figure out where to put this code so that the textbox will reflect the total amount itself once there is any amount in the LineTotal. Here is my code: Imports System.Data.SqlClient Public Class Quotation Dim dgvCombo As New DataGridViewComboBoxColumn Dim dgvCombo1 As New DataGridViewComboBoxColumn Dim dgvCombo2 As New DataGridViewComboBoxColumn Dim dt As New DataTable ...Show All

• SQL Server Query the results of another query

  I'm new to the database world - I know what I want to do, but not sure if or how to do it... Is there a way to run a query and then build on it to query the results of that query My example is as follows: Query the number of distinct machines by ID in Week 1 = Results Query the distinct number of machines by ID in Week 2 minus the Results from Week 1 - NOT EXISTS SELECT pub_name FROM publishers WHERE NOT EXISTS (SELECT * FROM titles WHERE pub_id = publishers.pub_id AND type = 'business') - Use NOT IN SELECT pub_name FROM publishers WHERE pub_id NOT IN (SELECT pub_id FROM titles WHERE type = 'business') - Perform a LEFT OUTER JOIN and check for a NULL condition SELECT pub_nam ...Show All

• Visual Studio 2008 (Pre-release) Binding RichTextBox Content

  Is it possible to set the text of a RichTextBox via binding I have been trying things like this: <RichTextBox x:Name="RTB" Text="{Binding ElementName=SomeElement, Path=SomePath}/> Obviously this doesn't work because a RichTextBox doesn't have a TextProperty. Is there a similar Dependency Property that I should be using, or is there a way to do it at all Thanks I was afraid of that, I need to be able to apply text styles, so I figured a RichTextBox would be best. Is there a way to style text in a TextBox ...Show All

• Visual C# 1 second delay

  how can i add 1 second delay like: // i have some code here // my code // is here i want to add 1 second delay here // rest of // my code how can i do that please help me.. Put this where you need delay. Thread.Sleep(1000); // Accepts miliseconds Note: Put this in a single Threaded application will cause UI to halt for that amount of time that is passed as a parameter. So you must know what to do. Cheers ;-) ...Show All

• Smart Device Development regarding the issues in smartphone development

  hi , i have been involved in smartphone game development . i had found out the following issues , for which i couldnt able to find the solution ., since i am new to Windows mobile . 1. regarding the usage of threads in application : i didnt find any methods to stop the thread .. since suspend is not supported in .Net Comppact Framework2 ... 2 . my application is running properly in the emulator i had even tried with WM5.0 emulator . it s working . but when i open the .EXE file inside the bin folder ., its showing OUT of memory Exception .. i have used 14 images , its total capacity is 14.5kb , and its size on disk is 72 kb . help me in reolving the above issues . these are very critical one , without solving dis i cannot proceed . thanxs ...Show All

• Visual Studio Team System Not able to connect to MS Team Foundation Server

  I had installed MS Team Explorer Standard edition in my system and tried to connect to the Team Foundation Server. But I was facing an error TF310003. Then I was advised to uninstall the Team Explorer and install a 180 day trial version of a Team suite through the link http://www.microsoft.com/downloads/details.aspx FamilyId=5677DDC4-5035-401F-95C3-CC6F46F6D8F7&displaylang=en and install Team Explorer again. But when I installed this suite and tried to run it, I faced the error "The Beta period is over". Please let me know what could the problem be, what could this be related to. I would also like to know what are all the list of softwares I need to have installed to connect successfully to the TFS. Please provide a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Joysticks with XNA

  Before I start I already know that XNA has no joystick input support - but I'm using an xbox 360 styled joystick input with force feedback (so its exactly like the xbox 360 control) this is it: http://www.powerwave.com.au/index.php evnF=productImage&format=&title=Powerwave%20360%20Shape%20Controller%20-%20Carbon&id=2.195326&acode=APCPW2C3C And I want to know if anyone can help me get it working so when I debug a game in XNA I can use this controller I've bought instead of my keyboard. Or at least if anyone knows any software I can use that converts joystick input to keyboard so I can map the triggers on the controller to the keys that XNA uses. Thankyou for your time. ...Show All