Not sure why this hasn’t been covered yet on the blogosphere, but yesterday at Microsoft 2008 Launch Event, Tom Brokaw gave a ~15 minute monologue about technology to introduce Steve Ballmer , the plight of our planet, and how technology (and those who deploy it) should be used for the greater good.
Tom Brokaw! That’s right – TB; to introduce Visual Studio 2008 and other products. Relevance? I wonder if he’s a C# guy, or perhaps more of an IT Pro. LMAO. It was a cool experience, and quite different from the usual (a la Christopher Lloyd as Doc Brown in a De Lorean), which set the stage for this *unique* event.
I’ve been to my share of launches and airlifts – and the most bizarre part about this one was – surprisingly not Brokaw – but the spandex-wearing “living art” performers that graced the walkway from the Nokia Live Theatre to the LA Convention Center. It was something from an episode of The State.
What did you think about the event? Hyper-V does look awesome, and of course Visual Studio 2008 is bliss (we’ve been using it since RTM last November!) Cheers.
Does working on projects for a movie studio sound exciting to you? Do you want to parlay your consulting job into an acting career? Do you have a garage band and want to drop your demo tape at your record label client's desk? If you answered 'yes' to any of these questions, please read on! (All in jest, of course)
We're currently looking for highly-skilled Microsoft Solution Developers to work on projects at our entertainment clients throughout Southern California. Specifically, we're looking for go-getters with the following skillsets:
- Solutions Developers (all levels) – C#, WinForms, ASP.NET, Web Service, WCF, SCSF (CAB), EntLib
- Database Developers (all levels) – SQL Server 2005 Integration Service (SSIS), Reporting Service (SSRS)
If you are interested, please send your resume ASAP to svanvliet[at]gmail[dot]com. I will follow-up with a full job description and more details on our firm (one of the largest technology consulting and outsourcing companies in the world!) Local candidates only, please.
I look forward to hearing from you!
So I've boarded my flight to DFW (en route to Orlando.) Having been upgraded to First Class, (thank you elite status) I started getting comfortable in my bulk head isle seat (my favorite, of course.) Just as I'm about to buckle-up, a gentleman asks if I'm too attached to my seat to move so that he and his buddy can sit together. Now, I'm very cognizant of people who are jerks and can't move so that families and friends can sit together (I'll post on my recent Amsterdam to Los Angeles flight with wife and kids in tow later.) Thus, I acquiesced and offered my seat to this gentleman.
With a gracious "thank you," the guys proceeded to take their seats. It was at this time that I noticed their shirts and bags, which donned the "BlizzCon" logo. This brought me back to earlier, as I waited to board, when I heard some fellas talking about "the Horde" as if it were real life. Knowing a little about World of Warcraft (WoW,) I quipped, "Just take it easy on me in WoW." This is where it started.
"You play?!" responded the gent. "A little," I responded, which evoked, "What faction? Alliance or Horde"
"Uh, Alliance, I think?"
"AAAAAAHHHHH… Take your seat back!" was the response from the two men, as the laughed out loud.
Now, I'm a geek – no doubt. But this was just crazy! Nevertheless, I quickly put on my headphones and closed my eyes to escape the conversation I was not interested in having.
About 5 minutes later, the man was rubber-necking to try and get my attention.
"What server do you play on? I'd like to give you some Gold for your seat."
Holy shit… I couldn't believe that I was being offered FAKE money as a gift for my kindness!
"Uh, I don't know."
I had only signed up for a 14-day trial to WoW, and don't really have time to play any games these days. But it just goes to show how gaming is widely becoming part of everyday life, and in some cases bleeding the edge of reality.
If you've used hashing to store passwords for your application, you may want to double-check you code to ensure it works on Vista.
Thanks to information found in Shawn Steele's post from almost a year ago, it seems Microsoft made changes in the .NET Framework for Vista to comply with the Unicode 5.0 specification, which requires invalid characters previously omitted in earlier versions of the .NET Framework for Windows XP, Server 2003, etc. As such, hashes computed on previous versions of Windows may not match hashes created on Vista.
For example, if you hash the string 'Password' on Windows XP using MD5CryptoServiceProvider, the hashed UTF8 string result would be 'd~^g◄U7R↑!+9d'. Now, hashing the same value on Vista (without the fore mentioned solution) would result in '�d~�^g_�U7R_!+9d' as the UTF8 string output. Note the addition of the Unicode Replacement Character (\xFFFD) interspersed in the latter output. This is due to the fact that the Unicode 5.0 specification requires this character be provided rather than omitted, as allowed in Unicode 4.1 (implemented in the aforementioned previous versions of the .NET Framework for Windows.)
Now, as noted in Shawn's post, you can yield the same results on Vista as previous versions of Windows using EncoderFallback derived classes. These will allow you to specify non-default characters to use in place of the Unicode Replacement Character. For example, consider the following setup:
Encoding encoding = Encoding.UTF8.Clone() as Encoding;
encoding.EncoderFallback = new EncoderReplacementFallback(string.Empty);
encoding.DecoderFallback = new DecoderReplacementFallback(string.Empty);
Based on the snippet above, the encoding will use an empty string for encoding/decoding; thus, the result would be the same as that from Windows XP in the previous example (which simply omitted by default.)
While this solution will work (had to make things work in an existing codebase,) I would recommend using Base64-encoding strings to store hashes, as they would not suffer from the same issues of invalid UTF8 characters. The same string, 'Password', hashed using bytes obtained from Encoding.UTF8.GetBytes(byte[]) with or without the fallbacks yields '3GR+tl5nEeFVN1IYISs5ZA==' using Convert.ToBase64String(byte[]).
So I realize it seems like I'm posting a bunch of stuff on Oracle and little on .NET, but it's all related to a large Smart Client application we're developing for our client, using Oracle 10g; thus, it's relative J
In a geographically-diverse team structure, it can be quite difficult to manage the development environment used by each team member (especially when you have little control over the workstation configuration of your offshore team.) Thus, for many of our engagements we heavily leverage virtualization – specifically Virtual PC 2007 – to help minimize the cost of environment setup and configuration.
One of the challenges we've faced with leveraging Virtual PC, specifically a shared image, is the unique naming of virtual machines. Now, in many cases it is acceptable to keep the virtual machine name the same across developer environments; however, for our purposes, unique machine names are required based on the following:
- TFS Workspace names rely on machine name for unique naming (in combination with username)
- Using our host VPN connection and Internet Connection Sharing (ICS), we provide our guest VPN access; although through NAT, the machine name (NetBIOS) still passes through when accessing corporate network resources, thus causing issues with the same
- When using local network access directly on the guest, name conflicts occur; furthermore, two guest machines have issues accessing each other due to similar NetBIOS naming issues as outlined above (we often communicate guest-to-guest from different developer environments)
For all intents and purposes, this is a trivial matter. However, when dealing with Oracle, reliance on the installation-time hostname – at least from my experience and research – is critical. Thus, changing the hostname can cause problems.
Consequently, we've learned to deal with this process by following the steps outlined below.
Step 1 – Create Hosts Entry for Old Hostname
Locate your hosts file, typically located at %WINDIR%\system32\drivers\etc\hosts and add an entry for the old (current) hostname.
# # HOSTS file #
win2k3r2 172.16.10.10 |
Note the IP address – this is the address of a Loopback Adapter installed on the guest machine. As outlined by the Oracle Installer, a Loopback Adapter is required on systems that do not have a static IP address (as do virtual machines using NAT, etc.)
Step 2 – Uninstall Enterprise Manager Console
Because there are configuration settings stored with Enterprise Manager Console that reference the hostname, the same must be uninstalled.
emca -deconfig dbcontrol db -repos drop |
Note, before executing this command, ensure that the Oracle instance is running – it has to be in order for Enterprise Manager Configuration Assistance to drop the repository and de-configure the Console.
Step 3 – Stop All Oracle Services
Once the uninstall of Enterprise Manage Console has completed, stop all Oracle Services on the guest machine.
- iSQL*Plus Service – typically named Oracle<OracleHomeName>iSQL*Plus
- Oracle Listener Service – typically named Oracle<OracleHomeName>TNSListener
- Oracle Database Instance Service – typically named OracleServer<SID>
Step 4 – Update listener.ora and tnsnames.ora
Once all the Oracle services have stopped, update the listener.ora and tnsnames.ora files, located in %ORACLE_HOME%\network\admin to reflect the desired (new) hostname.
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = win2k3r2)(PORT = 1521)) ) ) |
DEVBOX = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = win2k3r2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = devbox) ) ) |
Step 5 – Rename Host and Restart
Now, rename the computer and restart the guest machine.
Step 6 – Ensure Oracle Instance is Running
Once the guest machine has started up, log in and ensure the Oracle instance is running using the following command line (typically required, unless the instance, not the Windows Service, is configured to auto-start.)
oradim -startup –sid devbox |
Step 7 – Reinstall Enterprise Manager Console
After ensuring the Oracle instance is running, reinstall Enterprise Manager Console using the following command line:
emca -config dbcontrol db -repos create |
Step 8 – Validate Enterprise Manager Console Installation
Lastly, after the successful installation of Enterprise Manager Console, validate the installation by navigating to the logon page – typically http://<hostname>:1158/em/.
At this point, you should be crankin' away with your Oracle instance running as it should! We spent a lot of time working on this issue, so hopefully this post helps you out in some way – I wished there was an article like this when I was scouring OTN with no results!
Thanks to Mike Huffine for the initial pointers.
This is my first time visiting Japan, and it's already been an incredible experience. Dinner tonight was an interesting blend of Japanese fare, most of which tasted completely unfamiliar. And the long ride from Narita to the Westin Tokyo allowed me to view some of the city's multifaceted beauty.
Tokyo is the start of my mini World Tour of client meetings; I'm off to Hong Kong in a couple days, then to Mumbai only a day later. Stay tuned for more interesting musings.
It's now been over 2 months since I began using Vista as my primary OS, and to-date I've experienced nothing but end-user bliss J There are so many cool features to which I'm really growing attached – it would be rather difficult to revert to XP. One of these excellent features is Additional Clocks in the Date and Time Settings. This feature allows you to add two additional clocks to the task bar, providing a view of alternate time zones in two of the following ways:
Mouse hover:

Single-click:

With team members and clients spread across the globe, this feature is greatly appreciated! Now I don't have to keep Yahoo! Widgets or Google Gadgets around for this sort of thing.
Here's a quick tip: if you need to move multiple files or folders in Team Explorer, it's not possible to select multiple and click 'Move' from the context menu. However, you can accomplish this using the TF.exe Move command with a wildcard:
Syntax:
tf.exe move <itemspec> <destination>
Example:
tf.exe move $/Itd/Deployment/Builds/R1* $/Itd/Deployment/Builds/Archive
Sweet and simple! This one saved me a lot of time – Enjoy!
As part of our configuration management process with our offshore team, we often have to recreate our database schema in Oracle by dropping the schema owner and recreating that user as part of the create/import scripts delivered with a build. However, when trying to perform this task in our onshore Development, QA or UAT environments we are faced with an issue where the user could not be dropped due to the fact that said user was currently connected:
DROP USER <user_to_drop> CASCADE
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
However, when checking the V$SESSION system table, the user was not listed as being connected or having an active session with the database. Perplexed, we looked around at some other clues, and determined that while the user did not have an active session with the database, its connection was still valid and pooled by the ASP.NET Web process. Thus, we recycled the AppPool in which the application was hosted and – viola! The drop succeeded.
We've now automated this process and recycle the AppPool programmatically. Below is the Web service used to list the available AppPools and individually recycle them.
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.DirectoryServices;
using System.Collections.Generic;
[WebService(Namespace = "http://tempuri.org")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class AppServerService : System.Web.Services.WebService
{
public AppServerService ()
{
}
private const string AppPoolDirectoryEntryPath = "IIS://localhost/W3SVC/AppPools";
[WebMethod]
public List<string> GetAppPoolNames()
{
List<string> appPoolList = new List<string>();
using (DirectoryEntry appPoolEntry =
new DirectoryEntry(AppPoolDirectoryEntryPath))
{
foreach (DirectoryEntry appPool in appPoolEntry.Children)
{
appPoolList.Add(appPool.Name);
appPool.Close();
appPool.Dispose();
}
}
return appPoolList;
}
[WebMethod]
public AppPoolRestartResponse RecycleAppPool(string appPoolName)
{
if (appPoolName == null)
{
throw new ArgumentNullException("appPoolName");
}
AppPoolRestartResponse response = new AppPoolRestartResponse();
using (DirectoryEntry appPool = new DirectoryEntry(
String.Format("{0}/{1}", AppPoolDirectoryEntryPath, appPoolName)))
{
try
{
appPool.Invoke("Recycle");
response.Successful = true;
response.Message = String.Format(
"Application Pool \"{0}\" was recycled succesfully at {1:HH:mm:ss}.",
appPool.Name, DateTime.Now);
}
catch (Exception e)
{
response.Successful = true;
response.Message = String.Format(
"Application Pool \"{0}\" failed to recycle: \"{1}\".",
appPool.Name, e.Message);
}
}
return response;
}
/// <summary>
///
/// </summary>
public class AppPoolRestartResponse
{
private bool _successful;
private string _message;
public bool Successful
{
get { return _successful; }
set { _successful = value; }
}
public string Message
{
get { return _message; }
set { _message = value; }
}
}
}
Note that in order for this Web service to work correctly, you must be authenticated to the Web service as an local administrator of the machine, or enable impersonation in Web.config for a user with the appropriate privelleges.
In early 2006, we had a difficult bridge to cross as we were about to enter the Construction phase of our current project. Having 35+ developers building interdependent functional areas of the application, we needed to ensure the autonomy of each functional area, whilst maintaining linkage between shared components. Thus, having used branches in the past (quite successfully with Subversion, might I add,) we decided to leverage TFS branches to provide support for our concurrent development efforts.
While quite sound in theory, this has proven to be quite challenging in practice. We've faced several issues, most troubling of which is error TF14087:
TF14087: Cannot undelete '$/Itd/Implementation/R2/Bvi/Framework/Security/Authorization/Principal.cs' because not all of the deletion is being undeleted.
After some research into this error, I came across this excellent explanation of what's going on. Furthermore, we found that the reason for this error occurring in our structure is due to file renaming in the trunk and branches. Thus, as the aforementioned blog post outlines, TFS cannot perform the merge as the linkage between the file is not correctly synchronized (TFS is looking to merge a "deleted" file, although it's really been renamed.)
Furthermore, we also faced issues in that some developers "merged" their branch by copying files locally in their workspace and added them to Source Control as new items. This completely breaks the linkage between the trunk and branches, which was a big headache when trying to perform the merge.
In the end, we spent more than 4 hours manually merging our two active branches – what a pain! Even though there are some workarounds posted out there (here is a fair approach,) we ended up performing the merge manually due to the fact that some defects had been fixed in one branch while other defects in the next branch. Thus, the only way to effectively manage said changes was to manually merge.
Although I'm now a little jaded with TFS Branching, I would recommend the following guidelines if you choose to use this functionality to manage concurrent development activities:
- Merge often – this is a big one, since many of our issues would have been resolved if this rule was followed by our team.
- Rename in trunk, then move to branches – we found that whenever a rename was required, performing this activity in the trunk allowed us to propagate changes to the desired branch without merge errors
- Document merge guidelines – in our situation, we have 35+ developers offshore with some architecture and development oversight resources onshore. Although some resources had used branches before, many were unfamiliar with the process, resulting in the merge-via-copy-and-paste snafu. Thus, clearly documenting the process could have saved us the headaches we've had.
- Keep shared components in single branch – we found that fewer conflicts existed in shared components. Thus, keeping these items in a single branch reduces the margin for error in merging.
In addition to these tips, it is always a good idea to effectively communicate major changes to the code base between the development teams. We're currently implementing a weekly meeting between team leads to discuss the same, and it's looking bright.
Recommended reading:
The logic and reason behind error message TF14087 (mentioned earlier)
Cheers.
More Posts
Next page »