http://www.blackwasp.co.uk/New articles, tips and tricks at the BlackWasp web site.en-us Tue 03 Nov 2009 00:00:00 GMT Tue 03 Nov 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/jJbPo61MYEU/SQLTrigFunctions.aspxThe forty-first part of the SQL Server Programming Fundamentals tutorial continues the examination of Transact-SQL (T-SQL) mathematical functions. This article considers the trigonometric functions that allow SQL Server to work with angular data.http://www.blackwasp.co.uk/SQLTrigFunctions.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/9wppZ2_CV-8/CharacterTesting.aspxWhen developing software that may be deployed in many countries, it is important to be able to determine the type of a character according to the rules of the local culture and language. The Char structure provides methods to simplify this process.http://www.blackwasp.co.uk/CharacterTesting.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/3T1SKN-NMKw/EnvironmentNewLine.aspxWhen working with strings that contain multiple lines of text, each line is separated with a line break. Line breaks are often added by inserting carriage return and line feed escape characters. This can cause cross-platform compatibility problems.http://www.blackwasp.co.uk/EnvironmentNewLine.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/mT8G5fspRcc/StringBuilder.aspxCreating strings with the use of multiple concatenation operations can lead to low performance and wasteful memory usage. The StringBuilder class allows strings to be created and updated without the problems caused by the immutability of the String class.http://www.blackwasp.co.uk/StringBuilder.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/kew5Lv22ODY/SQLRoundingFunctions.aspxThe fortieth part of the SQL Server Programming Fundamentals tutorial continues the discussion of mathematical functions provided by Transact-SQL (T-SQL). This article describes three functions that can be used to round floating and fixed-point numbers.http://www.blackwasp.co.uk/SQLRoundingFunctions.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/gpQDgAJbPj8/VSIncrementalSearch.aspxVisual Studio provides several tools to allow you to quickly locate text within a file, project or solution. This article describes the Incremental Search feature, which permits fast searching of a file with no interaction with dialog boxes required.http://www.blackwasp.co.uk/VSIncrementalSearch.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/v6Ufug80fQc/SQLBasicMathsFunctions.aspxThe thirty-ninth part of the SQL Server Programming Fundamentals tutorial begins an examination of mathematical functions provided by Transact-SQL (T-SQL). This article describes five basic functions. Future articles will look at more advanced functions.http://www.blackwasp.co.uk/SQLBasicMathsFunctions.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/sA41C-6nsSo/GetTimeZoneInfo.aspxWhen creating applications that will be used internationally, particularly with a shared database that holds date and time data, it is important to be able to obtain information about time zones. This can be achieved with .NET 3.5's TimeZoneInfo class.http://www.blackwasp.co.uk/GetTimeZoneInfo.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/hEyblYbXb64/SQLCastConvert.aspxThe thirty-eighth part of the SQL Server Programming Fundamentals tutorial discusses the cast and convert functions provided by Transact-SQL (T-SQL). These two standard functions allow values to be explicitly converted from one data type to another.http://www.blackwasp.co.uk/SQLCastConvert.aspx http://feedproxy.google.com/~r/BlackwaspLatestAdditions/~3/VXNJ3H5-Dew/ReadPerformanceCounters.aspxMicrosoft Windows provides a large number of categorised performance counters that can be used to monitor the utilisation of hardware, services, software applications and drivers. Usually viewed with Performance Monitor, they can also be read using C#.http://www.blackwasp.co.uk/ReadPerformanceCounters.aspx