How to get calling.
I’ve been using Vonage for about 6 months. For $25/month the service is pretty good. Nice features with voice mail being saved to WAV files for download and automatic email.
However, today I tried out Skype’s (SkypeOut) where you can from your PC call any other phone.
The sound quality is great and the latency is short. With this kind of capability, I’m now rethinking what I need vonage for.
An article I wrote a couple weeks back has been posted to www.Sqljunkies.com
Accessing Application Configuration Settings from SQL CLR
Recently, one of my peers asked a question regarding the ability of SQL CLR classes to read configuration data from an Application Configuration file. After doing some quick Google searches on the topic, I came up with a couple of links that indicated the potential, but no concrete HOWTO on getting it all wired up.
Now, I don’t want to debate whether this makes good architectural sense to store static settings in the file system when you’re already working inside a database management system that could just as easily save these settings to a table. A scenario that you might leverage this capability is to re-use an existing Application Configuration file, specifically, the <appSettings> element from an already built and working assembly from another application.
This article also uncoves a bug in the SQL CLR implementation that if you don’t know about it you will have issues reading the settings.
Continue at source…
Have Data Will Travel : Where does Service Broker Fit?.
This is a good “perspective” post on where Service Broker, MSMQ, BizTalk, and WCF fit in architectures.
I was at an MGB (Microsoft Global Briefing)* about 2 years back. So, the presentation I’m sitting in is on Service Broker. So, another MSFT guy in the audience asks a question regarding product positioning with BizTalk.
Well, that exchange turned into a great nasty fight between the 2 MSFT folks with applause coming from the audience when the person asking the question had some nice comments. The presenter handled it so poorly and was quite nasty about it.
Frankly, the whole Service Broker existence is troubling with something like BizTalk available. Frankly there’s alot of crap I can get done with Service Broker running on SQL Express to the point who Needs BizTalk.
I really think they should be pushing down the availability of BizTalk to more mass market pricing. Apparently they are (or will be) as I’ve heard there will be aggressive pricing in the $2K range.
* Note these MGB conferences were open only to Microsoft employees; however, Avanade had a special place under Microsoft (we’re about 20% owned by MSFT) we had opportunities to attend.
SimpleTech STI-HD2.5/USB2 External Enclosure - OEM at Newegg.com.
This so far is the best external USB 2.0 Drive Enclosure that I’ve used. Great design with a short USB cable that folds away. Wish they had 2 other things: Way to get a longer USB cord and power switch. CORRECTION: They give you a longer USB, I was thinking the built-in USB if it could extend a bit more would be nice.
But, this think looks cool, connects easily and I don’t have to drag around one of those long USB cables to connect it to my notebook or desktop. And, for power it has a DC connection if you need it (5V/1amp) but fortunately my current Toshiba M3 has enough power on it’s USB bus I dont’ need it. My older crappy Dell C640 couldn’t handle it.
Comes with nice software called StorageSync that does backups. Unfortunately won’t do a disk clone/copy so I can move from my 60G internal to a 100G drive by first connecting the 100G via USB — probably need Norton Ghost for that.
If you're developing WinForm applications, generally at some point in the project you develop an Exception Dialog box that provides a user friendly interface for error messages. Usually, it's a generic box that displays parts of the exception stack and perhaps a way to log or allow users to initiate some other action such as proceeding, ignoring, or even reporting the error. Usually the solution hooks in as the Application or AppDomain unhandled exception handler at startup. Thing is, I don't see much re-use between projects with what should be a re-usable component.
Microsoft Exception Message Box
The other day I was working with some of the downloads included in the Feature Pack for Microsoft SQL Server 2005 - April 2006 and I noticed in that pack an item called Microsoft Exception Message Box. Here's the text for that download from the Feature Pack page:
The exception message box is a programmatic interface that you can use in your applications for any tasks for which MessageBox may be used. The exception message box is a supported managed assembly designed to elegantly handle managed code exceptions. It provides significantly more control over the messaging experience and gives your users the options to save error message content for later reference and to get help on messages.
More investigation, on the Microsoft MSDN website under Deploying an Exception Message Box Application the following statement appears:
The exception message box is installed by Microsoft SQL Server 2005 and is supported for use in your custom Windows applications to improve exception handling. In SQL Server 2005 SP1 and later releases, the exception message box is also provided as a redistributable installation program that you can distribute and deploy with your application.
It goes on to state:
- You must include the exception message box redistributable package (SQLServer2005_EMB.msi) in your application setup.
- Exception message box resources are installed in the global assembly cache (GAC).
- The redistributable package is available in all supported SQL Server 2005 languages.
- The exception message box installation does not appear in Add or Remove Programs. You should plan to uninstall the exception message box when your application is uninstalled.
What does this mean? Well, Microsoft has granted us a license to use and redistribute this Assembly with our own applications as long as we follow the installation rules in the list above.
Sample Solution Files
Sample Solution
So, what does this thing do?
Before we proceed, some background on using the Assembly (Microsoft.ExceptionMessageBox.dll) in your solution. First you'll need to establish a reference to the assembly. Although it's installed in the GAC, if you attempt to add a reference in Visual Studio 2005 (this thing is .NET 2.0 Only), it doesn't show up in the Visual Studio .NET Reference Tab[1]. So, you just need to click the Browse Tab and navigate over to the C:\Program Files\Microsoft SQL Server\90\SDK directory.
Once you got the reference set, then you have access to the Namespace types in Microsoft.SqlServer.MessageBox. There's a good set of steps located on MSDN How to: Program Exception Message Box.
The following set of examples are taken right from MSDN, but there's also shots of the actual MessageBox UI, which is absent on MSDN. So, let's take a look at some of the basic features.
The sample application with this article is located here: Sample Solution. And a screen shot of the UI is shown below:
Simple OK
The basic ExceptionMessageBox is fairly basic dialog. Additionally, the code is straightforward.
try
{
// Do something that may generate an exception.
throw new ApplicationException("An error has occurred");
}
catch (ApplicationException ex)
{
// Define a new top-level error message.
string str = "The action failed.";
// Add the new top-level message to the handled exception.
ApplicationException exTop = new ApplicationException(str, ex);
exTop.Source = this.Text;
// Show an exception message box with an OK button (the default).
ExceptionMessageBox box = new ExceptionMessageBox(exTop);
box.Show(this);
} |
What that provides is a simple dialog, but as you'll see there's some additional features, even in the basic ExceptionMessageBox that are quite useful. Here's the initial Dialog:
What you should notice is the two icons in the lower left. The first allows copying of the contents of the message box to the user clipboard. May seem novel, but some background - any windows message box if you do a Ctrl+C you can capture the text of the message box to the clipboard. What the ExceptionMessageBox does is make the capability explicit and clickable.
The second icon is a Advanced details button. If you click that, you get the following:
Hopefully you can see that there's room for additional information that's potentially usable to anyone doing troubleshooting on your application. As you'll see soon, you can expand this information even further by leveraging a new feature in .NET 2.0's System.Exception class.
Yes / No
This example provides a simple way of replacing a Dialog box and trapping the DialogResult for conditional processing.
// Define the message and caption to display.
string str = "Are you sure you want to delete file 'c:\\somefile.txt'?";
string caption = "Confirm File Deletion";
// Show the exception message box with Yes and No buttons.
ExceptionMessageBox box = new ExceptionMessageBox(str,
caption, ExceptionMessageBoxButtons.YesNo,
ExceptionMessageBoxSymbol.Question,
ExceptionMessageBoxDefaultButton.Button2);
if (DialogResult.Yes == box.Show(this))
{
// Delete the file.
} |
Here the Yes / No option produces the following giving you conditional based processing:
Custom Buttons
Custom Buttons allow you to control the text on up to 5 buttons (Button1 - Button5) in addition to a None option. Again, useful for conditional processing and providing text beyond the normal Abort, Retry, Ignore options.
try
{
// Do something that may cause an exception.
throw new ApplicationException("An error has occured");
}
catch (ApplicationException ex)
{
string str = "Action failed. What do you want to do?";
ApplicationException exTop = new ApplicationException(str, ex);
exTop.Source = this.Text;
// Show the exception message box with three custom buttons.
ExceptionMessageBox box = new ExceptionMessageBox(exTop);
// Set the names of the three custom buttons.
box.SetButtonText("Skip", "Retry", "Stop Processing");
// Set the Retry button as the default.
box.DefaultButton = ExceptionMessageBoxDefaultButton.Button2;
box.Symbol = ExceptionMessageBoxSymbol.Question;
box.Buttons = ExceptionMessageBoxButtons.Custom;
box.Show(this);
// Do something, depending on the button that the user clicks.
switch (box.CustomDialogResult)
{
case ExceptionMessageBoxDialogResult.Button1:
// Skip action
break;
case ExceptionMessageBoxDialogResult.Button2:
// Retry action
break;
case ExceptionMessageBoxDialogResult.Button3:
// Stop processing action
break;
}
} |
This is the UI with Custom Buttons
Exception Additional Data
.NET 2.0 added a new member to the System.Exception base class. This member is a collection that implements IDictionairy - giving you a collection of key / value pairs that you can add additional state and condition information to an Exception that might be useful for Exception handlers or in our situation additional diagnostic information for the ExceptionMessageBox.
In the following code, again taken direct from MSDN, the ApplicationException's Data member is populated with 3 additional bits of information.
try
{
// Do something that you don't expect to generate an exception.
throw new ApplicationException("Failed to connect to the server.");
}
catch (ApplicationException ex)
{
string str = "An unexpected error occurred. Please call Helpdesk.";
ApplicationException exTop = new ApplicationException(str, ex);
exTop.Source = this.Text;
// Information in the Data property of an exception that has a name
// beginning with "HelpLink.Advanced" is shown when the user
// clicks the Advanced Information button of the exception message
// box dialog box.
exTop.Data.Add("AdvancedInformation.FileName", "application.dll");
exTop.Data.Add("AdvancedInformation.FilePosition", "line 355");
exTop.Data.Add("AdvancedInformation.UserContext", "single user mode");
// Show the exception message box with additional information that
// is helpful when a user calls technical support.
ExceptionMessageBox box = new ExceptionMessageBox(exTop);
box.Show(this);
} |
This results in additional information if you click on the Advanced Details button.
Here, in the red circle, you can see the additional strings added to the Data collection for the Exception type. The ExceptionMessageBox has enumerated through the collection and displayed the ToString() for each item.
Summary
While many teams will develop their own Exception Message box and handling process, one thing to consider is whether the one provided here can meet the needs and save you a little time. Certainly there are limitations to what you can do with this Assembly. This article has only scratched the surface of what's possible.
Some features not shown here allow trapping of events such as OnCopyToClipboard along with additional property level control over the appearance and behavior.
So, I recommend that you take a look at what Microsoft has to offer here before coding up your own Exception Message box. Least you can do is abstract and wrap today, and replace as needed in the future.
About
Shawn Cicoria is a Consultant with Avanade (www.Avanade.com) the leading Systems Integration Consultancy focused on the Microsoft Platform. Shawn is also a MCT training instructor with SetFocus (www.Setfocus.com) located in Parsippany NJ. Focused on distributed technologies such as COM[+], J2EE, and for the past 5 years .NET, SOAP, BizTalk, and Database technologies -- and now WinFX..
[1] The registry key HKLM\SOFTWARE\Microsoft\.NETFramework\AssemblyFolders controls what .NET Assemblies show up in the Visual Studio 2005 Add Reference .NET Tab.
Virtual Appliances: VMTN Appliances.
VMWare has done a great job of leveraging the community to build ready-to-go Virtual Machines build on Linux core and other open source software.
These are download and start machines that do all sorts of things. So, if you want to ramp up on some technology this is one way.
Now, for Microsoft, the biggest struggle is the OS licensing cost. Is really a shame but if Microsoft could get product in trial form out the door and download-able in VM form it would be ideal. The fact is, they do this already if you’re an MCT (Microsoft Certified Trainer). I have access to all the learning content as I’m an MCT, but the licensing is always a struggle. They give us a key, but many MCT’s still have problems.
I think over time the OS license issue will diminish or MSFT needs to find out a way to get pre-built VM’s based on VPC or VS of course out there and usable by those that want to “experiment”.
CORRECTION: thanks to Matt – He points out a CRM 3.0 VM in his post: http://www.simpleviews.net/archives/101
Only issue is, it expires 12/31/06…
Avanade, NPower NY and Microsoft invite local nonprofits to apply for an “Xtreme Techover” organizational makeover, to help transform their community technology centers and administrative systems to better serve their communities. Organizations can apply online by May 26, 2006 at www.avanadeadvisor.com/xtremetechover.
One nonprofit will receive the grand prize, consisting of:
- Consulting services worth $150,000 – including two consultants for 4-6 weeks – from Avanade, the leading global integrator specializing in the Microsoft enterprise platform
- $50,000 in software licenses and $50,000 for physical improvements to a technology center or training from Microsoft
- Server and storage value of $150,000 from Network Appliances
Second and third place winners will receive an online Microsoft certification course and access to an online library of the latest technical and business books.
All applicants will receive a free one-year membership or auto-renewal to NPower NY, which includes access to discounted or free volunteer resources, software, hardware, workshops and Webinars. Winners will be announced at a June 20th breakfast for all applicants.
Deadline: May 26, 2006
Who’s Eligible: New York/New Jersey metro region nonprofit organizations that are registered as a 501(c)(3), have between 20 and 50 technology users, not affiliated with any school or hospital organization, and currently have an on-site community technology center delivering technology access to its constituents.