MoreHavoc
Of Oracle, Camping and Flying
TFS – How to remove a workspace for another user/computer
Mar 5th
We recently had a computer die at work. After getting the application back up to speed we attempted to checkin to TFS and we were met with an issue. We could check in, but all of the pending changes could never go in, because some of the new files were locked on the computer that died! So we had to figure out how to remove the workspace of that user. Open a Visual Studio Command Prompt and get started:
First, get all the current workspaces for a specific user:
tf workspaces /owner:DOMAIN\UserWithStuckWorkspace /computer:*
You will get a list of workspaces, you can then delete one of those workspaces (by computer) using the following command:
tf workspace /delete COMPUTER;DOMAIN\UserWithStuckWorkspace
For us this cleared up the locks and we were able to fix our projects and check everything into TFS!
I found this information, and much more on TFS and how to delete workspaces etc. on the following blog:
http://www.mikebevers.be/blog/2009/07/tfs-undo-checkout-or-lock-by-another-user/
How to compile all packages in an Oracle Schema?
Feb 13th
Every now and again I run into an issue where I need to recompile all of the packages, procedures and triggers in an oracle schema. This query will create a list of commands that can be run in a separate window, or run from a .sql file. This also makes it so that I can generate this script, and deliver the results to a client. Please not that this only works within the schema that the query is executed for. If you want to generate it for a different schema, try the “all_objects” view and add an owner to the where clause.
selectcase object_typewhen ‘PACKAGE’ THEN ‘ALTER ‘||OBJECT_TYPE||’ ‘||OBJECT_NAME||’ COMPILE; ALTER ‘||OBJECT_TYPE||’ ‘||OBJECT_NAME||’ COMPILE BODY;’else ‘ALTER ‘||OBJECT_TYPE||’ ‘||OBJECT_NAME||’ COMPILE;’end sql_commandfrom user_objects twhere object_type in (‘PROCEDURE’,'TRIGGER’,'FUNCTION’,'PACKAGE’)order by object_name, object_type
Girlfriend on a diet? Easy and Healthy home-made Valentine’s Day Dinner!
Feb 11th
Sometimes it is hard to come up with a meal that is both special and healthy, especially when your gf is on a diet! But this dish is pretty easy to make, and is very healthy! I did not come up with this, but got the idea from a local place Freddy’s Cafe.
Chicken with Cucumber-Slaw over Pita and Hummus.
Chicken with Cucumber-Slaw over hummus and pita.
Ingredients (makes two servings):
- Whole-wheat or Honey-wheat pita bread
- Hummus (In my case, home-made humus from our Vita-Mix Professional 500)
- One Pealed Medium Cucumber
- Two heaping Tablespoons of chopped red onion
- 1/3 red bell peper, chopped
- 1/3 Jalapeño pepper
- 1 teaspoon cilantro
- 2 Tablespoons Olive oil
- 1/2 Tablespoon balsamic vinegar
- Two medium tomatoes
- Garlic Powder
- Sea Salt
- Black Pepper
- Cajun Seasoning
- Cayenne Pepper
- One large chicken breast
- Feta Cheese
First, in a large bowl make the cucumber-slaw. Peal and chop the cucumber, slice it long-ways into quarters, and then chop into bite-size pieces. Chop the red onion, and put two heaping tablespoons into the bowl. Be carful with the red onion, since it will not be cooked too much can be overpowering! Chop the Bell peper into small pieces and place in the bowl. Place the chopped 1/3 Jalapeño pepper into the bowl as well. Mix in one Tablespoon of Olive oil, and 1/2 Tablespoon balsamic vinegar. Add garlic powder, Cayenne pepper, and sea salt to taste. Mix well, cover and place in the refrigerator.
Slice the tomato into small pieces, and season with 1 tablespoon of Olive oil and black pepper.
Season the chicken breast with the Cajun seasoning, and grill until 165 degrees fahrenheit. Slice the cooked chicken into bite-sized pieces.
Toast the pita, and spread a thick layer of hummus over it. Scope about half of the cucumber-slaw onto each layer of hummus. Be sure to drain the extra liquid from each scope before you place it on the hummus. Scope the tomatoes over the layer of slaw. Place half of the chicken breast over each pile of slaw and tomatoes. Sprinkle feta over the top.
Enjoy!
Bake an Egg in an Avocado for a Fast and Healthy Breakfast Treat
Feb 5th
I saw this in lifehacker this week, and could not resist giving it a try this weekend. The hardest part was getting the Avocado apart. I elected to use a not-so-ripe one, and it proved very difficult in getting apart.
Once apart, it was pretty easy to do the rest. I like my eggs solid, so it took a good 15 minutes to cook once everything was in the oven!
Enjoy!
http://lifehacker.com/5881942/bake-an-egg-in-an-avocado-for-a-fast-and-healthy-breakfast-treat
The Terminal Server has Exceeded the Maximum Number of Allowed Connections
Feb 4th
How many times have we all seen this one before? Well, as it turns out there are a couple of ways to fix this, or to at least see who is using the machine. The first way is to use remote desktop in console mode:
mstsc /console
This command will allow you to connect to the console of the server, as if you plugged a monitor and keyboard into the computer in the server room. I recommend using this method only to kick other people off, then logout, that way you can always use the console connection and it does not get stuck. But sometimes this does not work either, it could be in use, or someone else could have already used this trick.
Another way is to use a pair of commands qwinsta, rwinsta these commands query and reset the windows station. To query a server use the following:
qwinsta /server:cayuga
You should get something like this:
As you can see, each connection to the server, who is connected, and its state is displayed. Now that you have established this list, you can remotely disconnect a user by using the rwinsta command. This will disconnect a user from the server. To disconnect the row with ID 3, use the following command:
rwinsta /server:cayuga 3
The user will receive a notice that they were remotely disconnected from the server by an administrator, and now you can use remote desktop to get on the server!
How To: Run a .Net 4.0 WCF REST Service in IIS6
Feb 1st
Running a .Net 4.0 WCF REST web service in IIS7 is easy, you just publish to it, or copy the files. The case is a little more difficult in IIS6. If you have not looked into the .Net 4.0 changes, then I suggest you do, WCF, the changes to entity framework and LINQ make building secure useful web services quick and easy. There is no more building complicated .svc files, there is simple adding code to configure the routing path, but I will post more about that later!
For now, lets stick to getting them to run in IIS6.
- Download and install .Net 4.0 from Microsoft, if it is not already installed. The install should register .Net with IIS.
- Create a new Worker pool. Although technically possible it is not a good idea to use two .Net frameworks with the same worker pool. Either make your pools per application (for heavy workloads on larger servers) or per Framework.
- Copy your files and create your directory or virtual directory
- Right click on your virtual directory and select properties
- On the main properties page (“Directory” tab), select the Create Button. This will convert it from a virtual directory to an application.
- Select the appropriate worker pool on the main properties page as well.
- Change to the ASP.Net tab, and change the framework to 4.0 (or whatever version the application should run as).
- Back on the Directory tab, click on the Configuration button
- Add a new Wildcard application map pointed to “C:\Windows\Microsoft.Net\Framework\v4.0.30319\aspnet_isapi.dll”
- Uncheck “Verify that file exists”
- Press all of the “OK” and “Apply” buttons on the way out
- Restart IIS
GWT: “Error: ‘undefined’ is null or not an object
Jan 31st
For those of you out there using the Google Web Tookit (GWT), it is a great application but sometimes things go wrong, really, really wrong!
This time I was trying to debug an application in IE7, remote style. So I had my web services on the server, and I had copied my files to the server, and everything worked great when I was debuging on the local web server. Then when I pointed it to the remote web server, bang!
Undefined GWT Error
Well, after much head banging and google searching, I found the anser here.
It turns out that you can not name a div tag in your html page the same name as your project. So if your GWT project is called “HelpMe” then your div tag better be something like “HelpMePlaceHolder” if you want it to work. When you use RootPanel.get, you can get the div tag, but you can’t add anything to it once it is compiled, it only works in browsers other than IE. I tested this issue in IE 6, 7, Firefox 3.0 and Google Chrome, and it only seems to happen in IE.
So happy hunting!
AR.Drone
Oct 7th
The coolest toy I have seen in a long time!
Also see the ArsTechnica Article!
Mine is on the way, I will post information once it arrives, and once I start development!
