Archive for August, 2008
For as many places as I’ve been where they use VPNs, I’ve yet to find one that is set up correctly. I suppose there is a good reason for this, but I consider the problem to be mostly Microsoft’s fault.
I mean, wouldn’t you assume that if it were possible to use your regular connection for all of the network traffic EXCEPT for the traffic that needs to go through the VPN, that is what you would want? But no. Microsoft sets it up so that ALL of your traffic goes through the VPN connection.
What this means is that getting a connection to a search engine in order to look for a solution to a problem will take about twice as long as it should since your traffic first has to go to the VPN server and then out to the search engine.
Here’s how you fix it:
The last main feature of module development that we need to discuss is the implementation of IPortable.
If you’ve ever worked with other content management systems in a corporate environment, you’ll appreciate the implementation of this interface since the number one issue most organizations have is getting data from a staging area to a production area. Occasionally we’d like to get the content from production back to test or even into development. Many times we deal with this issue by just copying the database and the web application files from one area to another.
That works. But what if you want to move your content from one module on a page to another installation rather than the entire application?
That’s what IPortable does for us, as well as allowing us to move the entire site from one installation to another without having to move any files or the database.
A couple of weeks ago, I was working on a project that required me to unzip a file. There is only one text file in the zip, so using a full-blown library like SharpZipLib (OpenSource) or some commercial product just didn’t seem right. From my experience with Java, I knew zip routines were available as part of the Java libraries in .NET (JSharp). It seemed like my best bet would be to use what was already available rather than having yet another DLL on my system.
I thought it would be appropriate as we embark on the SQL for Programmers series to start at the beginning. And while most of our production databases are already created for us, the programmer is the one who is responsible (or should be responsible) for creating databases for testing purposes. Anyhow, at some point you will need to know how to programmatically create and delete a database and you’ll be glad you saw this information.