Verse of the week

When they found him on the other side of the lake, they asked him, “Rabbi, when did you get here?” Jesus answered, “Very truly I tell you, you are looking for me, not because you saw the signs I performed but because you ate the loaves and had your fill. Do not work for food that spoils, but for food that endures to eternal life, which the Son of Man will give you. For on him God the Father has placed his seal of approval.” Then they asked him, “What must we do to do the works God requires?” Jesus answered, “The work of God is this: to believe in the one he has sent.” So they asked him, “What sign then will you give that we may see it and believe you? What will you do? Our ancestors ate the manna in the wilderness; as it is written: ‘He gave them bread from heaven to eat.’ ” Jesus said to them, “Very truly I tell you, it is not Moses who has given you the bread from heaven, but it is my Father who gives you the true bread from heaven. For the bread of God is the bread that comes down from heaven and gives life to the world.” “Sir,” they said, “always give us this bread.” Then Jesus declared, “I am the bread of life. Whoever comes to me will never go hungry, and whoever believes in me will never be thirsty. But as I told you, you have seen me and still you do not believe. All those the Father gives me will come to me, and whoever comes to me I will never drive away. For I have come down from heaven not to do my will but to do the will of him who sent me. And this is the will of him who sent me, that I shall lose none of all those he has given me, but raise them up at the last day. For my Father’s will is that everyone who looks to the Son and believes in him shall have eternal life, and I will raise them up at the last day.”

SubVersion Clean up Failed — Run ‘cleanup’ REALLY?!

Thanks John for this awesome workaround!

John Glisson - Geek of the Cloth

I was having a “forehead to keyboard” sort of issue with SVN at a client. Something in the repository got jacked up, so I couldn’t run a cleanup operation. The frustrating thing was that when I ran the cleanup operation, it would give me an error message telling me the clean up failed, and instructed me to run the cleanup operation! Really?! 🙂

I found this blog post, and that fixed my issue…

Somehow, svn is stuck on the previous operation. We need to remove this operation from it’s ‘work queue’.

The data is stored in the wc.db sqllite database in the offending folder.
1. Install sqllite (32 bit binary for windows) from here
2. sqlite .svn/wc.db “select * from work_queue”

The SELECT should show you your offending folder/file as part of the work queue. What you need to do is delete this item from the work queue.

View original post 41 more words

A milestone moment for Microsoft: .NET is now an open-source project

Great moment for Microsoft! Very Happy about this! One of the guys at Innovative Architects (Steve Henson) put it best… ” This .NET open source announcement today is a big deal. It signals MS acknowledges we’re living in a post-Windows world and that they intend to compete across platform with the best development tools in the business. What Apple fan-boy could ask for anything more?…Also a clear shot across Apple’s bow. Azure is huge(r).”


In what probably never would have happened under the first two CEOs to lead the historic software company, Microsoft plans to announce on Wednesday that it is open sourcing the entire .NET framework, a symbolic move by the Redmond, Washington-based legacy technology company officially recognizing that the open-source model of software development is here to stay.

As part of the open-sourced version of .NET, Microsoft is also making the framework cross platform, meaning that developers should now be able to craft .NET applications that can run on either Linux or the Mac operating system.

Even though [company]Microsoft[/company] has open sourced bits and pieces of .NET over the years and created the .Net Foundation in April, whose purpose is to oversee open-source .NET initiatives, today’s news highlights the realization by Microsoft that it needs to make a full-court press in order to attract developers who are used to working with a…

View original post 1,410 more words

Deleting Empty Rows From Excel Sheet

Many times I get Excel documents with rows that I import into tables for bug tracking, or mass updates.

I also seem to almost always get empty rows in the excel document, which is annoying to find and remove!

Here’s a simple trick to delete empty rows form excel!

After selecting the data range, continue as follows:

  • Press [F5]
  • In the resulting Go To dialog box, click Special.
  • Click the Blanks option and click OK. Doing so selects the blank cells (what you might think of as rows) in the selected range. … 
  • Now you’re ready to delete the selected cells
  • Go to Edit
  • Select Delete
  • Select Entire Row


BizTalk DevOps: How to take control of your environment – Disable Tracking Settings in BizTalk Server Environment

Sandro Pereira BizTalk Blog

Probably this will be the first post of a series about “How to take control of your environment”, especially how to take back the control of your environment from the mistakes of developers. And don’t get me wrong I am mainly a developer but I also play the role of the administrator and sometimes I also make mistakes… especially this one that I will talk about.

Who are careful to disable the tracking options for all the artifacts before publish the solution in production environment?

Well I sometimes forget to disable tracks event in orchestration: orchestration start and end, Message send and receive and Shape start and end; and sometimes we actually don’t need to track all this information, they will be there because someone forgot to disable it. Most important this information is only useful for orchestration debugger purpose when things are failing and we always can at any…

View original post 605 more words

Overcoming Data Obstacles for Integrated BI

Great artcile by Donald Farmer on how the IT organization should change the view on reporting the data collected from various software and hardware programs.  More and more in my work, I find that that the business and customers are truly looking for the “multifaceted” view of data as Donald has described in his artcile. 

He talks about the road blocks on how an organization can try to overcome them:

To break through today’s barriers requires organizational and strategic change. IT teams must take on a new role. They can no longer be data gatekeepers but need to act more like data storekeepers. They can no longer control and micromanage all our corporate data or its uses. Instead, they should make available good quality, appropriate, and timely sources and feeds for business to use when and how they need it.

For their part, users can become more active participants in the data dialogue. Explaining requirements to IT takes too long and the standard life cycle of design, deployment, and feedback is cumbersome and slow. Business users can no longer afford to act as passive consumers; they must be integral to the information supply chain by becoming resourceful contributors, bringing their own insight and intelligence to bear. 

Forward-thinking teams have changed their view of enterprise information. They push past the barriers that hindered outmoded BI and reporting practices. They know technology and data infrastructure is but one small piece in a bigger puzzle. The pieces that matter to the bottom line fall in place only when users make new and effective decisions with these resources.

Go read the full artcile here: Overcoming Data Obstacles for Integrated BI

Is SSL 3 dead in your organization? It should be!

It has been a rough year for SSL. When Entertainment Tonight starts covering your vulnerabilities, it’s obvious that people who don’t even understand Internet security lack trust.  This also means that developers and admins need to dust off that reliable code to change the security protocol sooner than later!

With the recent advisory around the POODLE vulnerability in SSL 3, I would advise developers to aggressively change security protocol to TLS.

Getting your business customers behind a security change might have been difficult a few years ago, but it should not be anymore. With all the news around data breaches, a good case can be made around spending hours and money on product security without any visible changes to the product for users.  It will pay off in the future if the data from your product and your organization is secure!  That data is the key to the success (since it’s customer information many times) of your organization and can destroy customer trust in the wrong hands.

Here’s the recommendation from Google’s security gurus:

The attack described requires an SSL 3.0 connection to be established, so disabling the SSL 3.0 protocol in the client or in the server (or both) will completely avoid it. If either side supports only SSL 3.0, then all hope is gone, and a serious update required to avoid insecure encryption. If SSL 3.0 is neither disabled nor the only possible protocol version, then the attack is possible if the client uses a downgrade dance for interoperability.

Disabling SSL 3.0 entirely right away may not be practical if it is needed occasionally to work with legacy systems. Also, similar protocol version downgrades are still a concern with newer protocol versions (although not nearly as severe as with SSL 3.0). The TLS_FALLBACK_SCSV mechanism from [draft­ietf­tls­downgrade­scsv­00] addresses the broader issue across protocol versions versions, and we consider it crucial especially for systems that maintain SSL 3.0 compatibility.

You can find the full report here:

BizTalk Message Eater Pipeline

Saw this post recently and I have been thinking if I could use a “Message Eater”.  It simply consumes a message and then discards it by returning NULL in the Execute of the pipeline. This prevents routing failures for KNOWN failures. 

Here’s the translation of Paul’s Post:

Suppose you want a message in BizTalk not forward , but you also want to prevent routing failures . You have a “Message Eater” required, which picks up messages and swallows . Below is an example where you can see a file send port is created, which uses a custom pipeline , called SndMessageEater .

I like the premise of the workaround. I am just concerned about Level 1 support setting messages to be eaten that should cause routing failures and follow up actions. I suppose, though, that training could help avoid that. 

Again, great post, and as Paul states, a very simple workaround!

You can access the post by Paul here: BizTalk MessageEater

White Paper : “The A-Y of running BizTalk Server in Microsoft Azure” now available for download from BizTalk 360 White Paper collection

Adventures inside the Message Box

I’m pleased to announce that the White Paper titled “The A-Y of running BizTalk Server in Microsoft Azure” which I have been working on for the last two months is now available to download on the BizTalk 360 White Paper collection.

Writing this White Paper has been a momentous task, especially given that Microsoft Azure is an ever-changing entity (I’m pretty certain my synopsis on D-series VMs is already a bit dated since Microsoft have recently released new information stating that they sport faster CPUs, which I was previously unaware of, in addition to having SSDs) and I owe all the reviewers a big deal of thanks for their help.

This endeavour started out as a blog post (I just deleted the draft) and it quickly became apparent that the topic was well larger than anything I could cover within a single post and required a lot more attention…

View original post 31 more words