The ClevelandDotNet Blog is created to serve all .Net developers, both in Cleveland and elsewhere. Various .Net questions, events, and technical topics of interest will be posted regularly.
To learn more about ClevelandDotNet, visit http://www.ClevelandDotNet.info
How Microsoft sets up their own SQL Servers.
This is an interesting blog article from Microsoft.com Operations (http://blogs.technet.com/mscom/archive/2006/02/13/419406.aspx). It details how they setup their SQL Servers. It is interesting that they do not use clusters, preferring log shipping to keep multiple servers up to date, and perform "manual failover" from web sites by modifying connection strings. Also interesting is that they run SQL Servers behind Network Load Balancers.
String manipulation in VB2005 is fairly simple. However, things can get a little tricky with the double quote character. How do you look for it in a string? How can you insert into a string? How do you remove it from a string? These are questions that may lead to confusion if you don't know what you're looking for.
Ironically enough, in VB the double quote can also be used as an escape character when searching for it in a string. For example:
Dim strTest As String strTest = """123""" 'Displays "123" (double quotes appear in the final result) strTest = """""123""" 'Displays ""123" (double quotes appear in the final result) strTest = "test\""test" 'Displays test\"test strTest = "test""test" 'Displays test"test
In cases where you want to insert a double quote character, simply reference it unicode character designation, chr(34).…