http://www.blackwasp.co.uk/New articles, tips and tricks at the BlackWasp web site.en-us Sun 5 Jul 2009 00:00:00 GMT Sun 5 Jul 2009 00:00:00 GMT 1440http://www.blackwasp.co.uk/rss/RSSLogo.gif12060http://www.blackwasp.co.uk/ Copyright (c)2006-2009 BlackWasp http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/q_XXoBs_Yyw/SQLSubqueries.aspxThe thirtieth part of the SQL Server Programming Fundamentals tutorial examines subqueries. These can be nested queries allowing complex selections that are not possible using joins. They can also be used to update rows using the contents of other tables.http://www.blackwasp.co.uk/SQLSubqueries.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/KDvr3wXWjw8/HideMousePointer.aspxSome applications require that the mouse pointer be hidden during use. Examples of such software include screen savers and graphical applications or games. Each may fundamentally change the manner of display or the general behaviour of the cursor.http://www.blackwasp.co.uk/HideMousePointer.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/NuHERFcKSKI/MoveMousePointer.aspxAlthough rare, there are some situations where you may wish to reposition the mouse pointer programatically to improve the user experience or to enhance accessibility. This can be easily achieved using standard .NET classes and properties.http://www.blackwasp.co.uk/MoveMousePointer.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/JYTZkqU6-j0/AppMemoryUsage.aspxWhen you are creating an application that can be memory-intensive, it may be useful to monitor the current memory usage. This allows you to modify the behaviour of the program as its RAM requirements increase and to predict out-of-memory exceptions.http://www.blackwasp.co.uk/AppMemoryUsage.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/DMtv01hBQHs/VSWarningsAsErrors.aspxThe compiler used by Visual Studio can produce errors when code cannot be built and warnings when it completes compilation successfully but there are areas of concern. To avoid warnings being missed or ignored, there is an option to treat them as errors.http://www.blackwasp.co.uk/VSWarningsAsErrors.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/Cjqmi58Ud50/EnumExtension.aspxExtension methods were introduced in .NET 3.5 to allow classes to be apparently extended without modifying the class' code or using inheritance. Extension methods can also be used to add extra behaviour to enumerations.http://www.blackwasp.co.uk/EnumExtension.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/MKU19bmUdg4/RegisterHotKey.aspxSome Windows applications execute in the background and are activated only as required. To enhance such a program's usability it is useful to register a system-wide hot key. This allows the software to activate when a specific key combination is pressed.http://www.blackwasp.co.uk/RegisterHotKey.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/hEQV3UsfqEw/VSLoopSnippets.aspxVisual Studio 2005 allows quick creation of boilerplate code through the use of code snippets. In this article five snippets are considered. These allow you to quickly create the common looping structures in your programs with simple shortcut phrases.http://www.blackwasp.co.uk/VSLoopSnippets.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/kONj07tWY4Q/Observer.aspxThe observer pattern is a design pattern that defines a link between objects so that when one object's state changes, all dependent objects are updated automatically. This pattern allows communication between objects in a loosely coupled manner.http://www.blackwasp.co.uk/Observer.aspx