Focus On the What, Not the How

September 23rd, 2011

OBSERVATION

More often than not, when I begin systems analysis for new custom development project clients, they have already decided on technology platforms (and in many cases already acquired them), created detailed screen designs, and created database elements before consulting a systems analyst from a software development firm.

Their intentions are well-founded–that they want to get started right away when they find a developer.

However, going through this process with a developer rather than alone has great value. Seasoned systems analysts and developers have been through projects, so they know what details will suit you best in terms of tech platforms, dev languages, hardware, and design.  Even if you yourself are strong in I.T., just beware–custom development projects are their own animal, and they can become a loss to your organization if you start off in a wrong direction.

ISSUES CAUSED BY FOCUSING ON THE HOW

Misplaced confidence in you as the manager–if you present a developer with purchased hardware, a decided systems stack, and a plan, they are likely to take it and move forward with complete confidence that you know what you’re talking about–you’re the boss.  Beware–you’ve relieved them from a huge service you should probably be demanding–consulting and advice. If you’ve truly made the wrong choices for your project’s needs, it will wind up being at your expense.

Ignoring valuable experience–you may have some strong knowledge; perhaps you’ve even worked in the area of technology before and have a good feel for it. Don’t let that lead you into thinking that you can effectively micro-manage a seasoned vendor who does custom development for a living. They likely have a more mature or proven way to solve various things you’ve been trying to design a solution for that could save cost in the long run. It may not fit the picture you had in mind or follow the same path you imagined. Remember–development peoples’ personalities tend to be such that they will only push back so much–so they will likely give in to your way, so if it’s wrong–it will cost you.

FOCUSING ON THE WHAT

In custom software development from the ground up, a development vendor is most effective when presented with a detailed and prioritized list of requirements–what is this system supposed to do?  Who will it serve, and why?  Which requirements are the most critical to the business?

A seasoned software vendor will have a process for requirements-gathering during systems analysis. Staying focused during this phase of the project, and “worrying about the what and not the how” will result in your project’s best chances for long-term success.

Systems Analysis–How It Gets Ignored

March 24th, 2011

OBSERVATION

More often than not, I observe clients wanting to jump past the systems analysis phase and move straight into development.  Meanwhile, there continues to be a perception about software development that projects are always “over budget and behind schedule.”  I think there is a connection here.

SYSTEMS ANALYSIS LOOSELY DEFINED

Systems analysis is the phase of a project where an experienced I.T. professional gathers requirements and assesses the capacity required to produce a working system.  In a way, systems analysis in creating software is similar to creating architectural documents for building a sky scraper.  The difference is that a sky scraper is never attempted without an architect, yet software projects are plunged into every day with little or no formal analysis.

Deliverables of a good analysis can include but are not limited to requirements documents defining scope, technology stack diagrams, flow charts, user stories, low-fi screen shots, budgetary estimates, project plans, timelines with dependencies, and entity relationship diagrams for databases.

Deliverables like those listed above are essential to any purchaser of a software project because they set expectations about costs, chronology, general process, and completion timeline.  Without this, customers often get blind-sided and left in the age-old scenario of feeling “behind schedule and over budget.”  In the end, the software industry is always to blame (the customer IS always right).

FOOD FOR THOUGHT

If you have a systems project–and are shopping software vendors to create a system, think twice before being turned off if a vendor tells you after your first meeting that he/she cannot produce a quote from what you have described, and that some formal billable systems analysis will be required.  Just make sure you ask what deliverables (like the ones listed above) will be produced so you can avoid an endless hourly-billable consulting situation.

If you are a newer software vendor–and a client you are quoting is trying to convince you that systems analysis is your “cost of doing business” in preparation to produce a quote, be wary.  If a project is more complex than you can understand it CLEARLY AND ENTIRELY in a 1-2 hour meeting with a client, your best practice would be to bill some formal analysis time up front before promising a quoted price that will affect your reputation (if you need help convincing them, feel free to send them to this blog post. :-) )

If you are a company, department, or corporate unit–and you are shopping for a vendor, but you went to your I.T. department first, try to remember that although your I.T. department is competent technologically, they may not be project managers who have experience managing outside vendors and software projects.  It’s very easy to take the project to them, allow them to analyze it, and jump on their shoulders to manage it the whole way through.  They are most often not qualified to do systems analysis, manage a software project, nor to manage outside vendors or a team of software developers. They are valuable to have involved, but a good software vendor should manage the project and their involvement, not the other way around.

Faculty Governance 2011, University of Arizona

February 28th, 2011

D’Mention Systems is proud to have been a part of the new Faculty Governance system at the University of Arizona.

The implementation of the University of Arizona’s new enterprise system recently created a gap in service for the Faculty Governance Voting and Election application – functionality that did not carry over from the old HR system.

On October 26, 2010, our effort to develop a new Faculty Voting application began, and on February 28th, we were proud to announce that the faculty held its first successful election using they system, see more…

Introducing CityZing.biz

October 28th, 2009

October 2009, D’Mention Systems proudly announces the launch of the newest web-based business directory, CityZing.biz.

CityZing! provides Tucson area businesses a unique opportunity to gain exposure on the internet while talking directly to consumers.

Your customers are talking… so why not have them provide an online testimonial that other consumers can watch and learn about your business. CityZing! also gives business owners a place to provide Webmercials… to highlight your products and services and talk directly to local consumers… to tell them why they should be doing business with you!

We are proud to showcase our involvement in this ground-breaking new project as both a founding force, a website and software developer and support contractor. CityZing! is a fine example of D’Mention Systems‘ commitment to local business community. 

CityZing! officially launched in early October 2009 and already has several listings and people promoting their businesses through online testimonials and webmercials filmed in-house at the video studio of our own Zing Promo Center.

For more information about CityZing! log on www.CityZing.biz and get connected. Basic business listing on CityZing! is FREE so contact CityZing! or D’Mention Systems to get started!

Holiday Special from D’Mention Systems and CityZing! Business Directory:

The holidays are just around the corner, and D’Mention Systems with CityZing! is offering new video solutions to connect businesses with their most loyal customers, vendors, colleagues and clientele. Ask about the Sales Team Sleigh Ride. Film and launch this specialized holiday themed 30 second video on CityZing! to wish everyone warm wishes this upcoming season! Only $ 29.99… includes holiday inspired background and free listing on CityZing! Call (520) 229-8730 to schedule a Sales Team Sleigh Ride at your local Zing Promo Center.

Come See Andrew’s Sessions at Desert Code Camp in Phoenix Nov 7

October 22nd, 2009

Desert Code Camp is back again this year, on Saturday Nov 7th, up in Phoenix.

I’m teaching two classes there, plus there are 44 other great events, of all flavors and interests.

This is a completely free event, hosted and taught by real people who have a genuine interest in the topics.

My sessions are:

Intro to Multithreading Patterns with .NET

Every developer will sooner or later come across a time when they need to spin up multiple threads.

For many, this is a black art, best avoided for fear of race conditions, deadlocks and difficult-to-reproduce bugs.

This session will show some of the powerful but very easy-to-use threading objects and helpers in the .NET framework, like BackgroundWorker, Timer, ThreadPool, etc.

This is not an advanced and deep topic on multi-threading, but rather an introductory topic on how easily (and safely!) you can use multi-threading in many of the common cases, without ever having to know anything about semaphores, mutexes, or locks.

In this session, we’ll do several actual live coding exercises to show some of these patterns and approaches from a practical, real-world approach.

Don’t expect to learn the nitty gritty theory of multi-threading, but rather to learn how to solve some very common and typical problems.

Develop a New Love for PHP with Objects

If you’re like many of us, and have mentally relegated PHP to the bin of old and dusty procedural languages, you may want to take a second look.

PHP is growing up, and shedding many of its older bad habits, and has powerful Object Oriented support.

In this session, we’ll explore what a modern developed-from-scratch PHP app can look like, using OO, modern IDE’s, and powerful debugging techniques.

This session will be mostly practice and actual coding, with very little theory. Don’t come expecting a primer to OO, but rather how to express yourself and your love of OO design in the last of all places you’d expect: PHP.

So far there are 41 registrations for the first (.NET multithreading) session and 21 for the second (New love for PHP).

In addition, there’s a very interesting event going on the day before, called TEDx Phoenix that I’ll be attending.  It looks fascinating, and I’m going to give it a try.

If you’ll be going up to TEDx or Desert Code Camp, definitely let me know at andrew *at* dmnsys.com, we can get the Tucson folks together for a lunch during the day.

Andrew Hollamon

Investing In Web & the Returns We Expect

September 10th, 2009

OBSERVATION

As a business development consultant, I am continually honored by the opportunity to help people invest in technology and create some kind of functional tech product for their businesses. Over time, I have observed that a high volume of people investing in websites and/or web applications have had unrealistic expectations about the return on the investment they were making–in some cases, drastically unrealistic.

TYPICAL BUSINESS WEBSITE

The following is a typical situation that I see just at the point of publishing a website:

  • Product: business website
  • Features: some attractive flash snippets, a short video/slide show
  • Cost: $3000.00
  • Balance to web developer: Paid In Full
  • Client satisfaction with look and feel: HIGH, product gleamed precise vision of business ownership at outset of development. They’d recommend this developer to anyone.
  • Budget for pay-per-click: $0.00 (reason: client heard these campaigns were a rip-off)
  • Budget for email campaign $0.00 (reason: client has staff to do this in-house, can save on cost so we’ll do it ourselves)
  • Budget for blog-writing campaign with search term optimization: $0.00 (reason: client has staff to do this, company comptroller was an English major in college, can save on cost, so we’ll do it ourselves)

The following is what commonly ensues 6-8 months after the above site was published:

  • # Blog Entries Made: 1, the one the web developer originally posted (reason: comptroller was too busy to write blogs because of some unforeseen accounting issues)
  • # Visitors to site: Unknown (reason: comptroller has since lost the password to that analytics tool the web developer set up for us to analyse it ourselves)
  • Hot leads/conversions generated by site: 0
  • Site owner’s current satisfaction with investment: LOW

In the situation above, the site owner sometimes writes off the web as a bad investment, or begins to ask tech-savvy friends for second opinions on “things we could do with our site to get more results,” which sometimes results in suggestions about meta tags, alt tags, key word content, or a suggestion that the look of the site is just not professional enough (despite the satisfaction felt after the first publishing).

Is this you? Has this been you? Have you been the web developer on the other end of this? I’ll admit, I’ve been ALL of these.

ANALYSIS

I call the situation above the Field Of Dreams Fallacy – if you build it, they will come (This of course only makes sense if you’ve seen the Kevin Costner film Field Of Dreams).

Many business people who are new to the web have common expectations about the Internet–that just building something “cool and techie” on the web will bring us some return. We don’t always start with a long-term strategy, plan, or objective, so we end up with a really cool product that we are left uncertain of what to expect from it. No matter how fresh and new the web is, some things never change–common business realities apply here.

What should the return on our money be? According to this article at expert click, it is reasonable to expect 5-10% return per year on capital invested in a business, and anything higher than that will attract competition. Having a business degree and being a business owner and developer myself, I would concur.

I think most business people would agree with the estimations in the paragraph above, yet, I can’t deny hearing the words “website will pay for itself” uttered by so many business website investors. Here’s what I’ll offer: If in a year, a savvy stock investor could expect to make back $3000.00 on a website and continue making $3000.00 per year for years thereafter, that investor would change from stocks to websites in a heartbeat.

Let’s label any expectations about a website paying for itself returns, and discuss different types of returns we might expect. We’ll discuss 2 types of returns: exposure, and conversion (we will leave the science of capitalizing on traffic for advertising revenue for another discussion).

EASY RETURN: EXPOSURE

Exposure is a benefit (and I would argue is basic “table stakes for the game”) that starts simply with someone being able to verify that you exist online. A simple return might be someone who lost your card that you gave them when you met them, all they remembered was your business name, and they were able to find your phone number online to call you for a consultation. This return might be difficult to identify or evaluate, but if you really wanted to, you probably understand your business well enough to estimate/evaluate this if you try (I wonder if calculating this would come out to 5-10% per year over time…).

Another return on exposure is image–someone might be sizing you up against a competitor, and comparing benefits of your service or price against someone else. Again–difficult to evaluate. The website owner in the example discussed above may never realize this is actually happening, because a conversion did not result directly or knowingly from the website.

I would argue that while exposure’s benefits are the hardest to quantify and measure, they are the easiest to achieve, in that just by having a reasonably designed website that is online, the benefits of exposure as discussed here will ensue almost automatically (so in this context, if you build it–they will actually come!).

HARD RETURN: CONVERSION

In an exactly opposite fashion of exposure, conversion is the easiest to measure and the hardest to achieve of the two types of website return. A conversion would be someone who called, emailed, purchased a retail good, or requested a consultation of some kind that directly resulted in business purely from visiting the company website.

This kind of return requires another lesson from the Field Of Dreams: going the distance. This type of return on investment for websites is where I believe that most investors lose touch with reality, and I believe it is what most investors want after investing in a website — CONVERSION.

To go the distance and achieve conversion, an ongoing process of marketing, investment, research, maintenance, and energy are required. It is also important to note that this type of return, depending on your industry, may not even begin until after a substantial investment in ongoing promotion of the website. The website may even need to be adjusted several times through trial and error, depending on your strategy and product, to reach certain goals (which need to be set). The following ongoing promotion tools are typically overlooked by first-time web investors:

  • Blogs/News Letters–changing relevant content for search engines to find and make available
  • Pay-per-click advertising
  • Extensive targeted email campaigns
  • Ongoing search engine optimization
  • Off-line marketing driving visitors to online point of sale
  • In-person networking combined with a strategy/promotion to drive visitors to site

Depending on your business, any one of the above may be applicable, but they all have 1 thing in common: they all require investment of ongoing resources.

CONCLUSION

The most commonly overlooked factor that makes expectations unrealistic is the assumption that building something and investing a one-time sum will simply produce returns forever. I see this across I.T., not just in websites. Some business owners operate under a similar fallacy that they’ll just have to “invest in this computer network once,” and overlook maintenance, aging computer technology, wear and tear, and continuity issues/disaster recoveries.

Realizing this up front can save whole lot of mental pain by going into projects with proper expectations. Simply having piece of mind that you’re receiving return on 24/7 exposure that is provided by a basic and professional site is satisfying, much like a nicely designed sign does that sits out in front of a store front.

If it is conversion you want, be prepared to “go the distance.” Don’t make the mistake of thinking that the Internet is any different than any other medium for marketing–it requires a plan, a budget, goals, and ongoing energy.

Stay tuned for my next discussion on expectations for return on web applications in the same context

Need to sit down and talk about some of these issues yourself? Feel free to give me a call at (520) 229-8730, or request a free consultation

Tech Startups – A place to get started

September 1st, 2009

About to launch a startup?

Did you just get funded for a tech startup, or are you creating a business plan for a new business that runs primarily on a web-application or software system?
We understand the need to allot precious capital to application development and marketing, while keeping costs down on overhead, infrastructure and back-office functionality.  That’s why we’re proud to offer business development startup services.  Here are some things you can enjoy with our service:
A lasting business relationship
We can provide this at a fraction of the cost in a start-ups in their first one to two years of operation.  This saves on budget during the trial period where you’re discovering whether you’re idea “has wings,” while allowing you to allot maximum attention and resources to the “very wings that will make your startup fly.”
We’d love to get to know you, share our experiences with you, and create a lasting relationship. Feel free to call us:  (520) 229-8730 or click here to request a free inquiry.
Other links that may interest you:

D’Mention Systems Partners with Think Out Loud

August 20th, 2009
 
D’Mention Systems has partnered with Think Out Loud LifeSuccess Coach John Fox to present the launch of Think Out Loud Masterminds. It gives people the opportunity to study the thinking of master thinkers, through a NO-cost 10-week study.

This weekly, in-depth study allows members the opportunity to join forces and mastermind with a unique group of like-minded individuals who are focused on taking the results, in every area of their life, to a new level. Together, members learn how to achieve your goals through the practices and principles of desire, faith, autosuggestion, imagination, decision, persistence, the subconscious mind and the seven basic fears.

We are a sponsor and co-founder of Think Out Loud Masterminds, and our motivation to get involved in masterminds coaching is derived from of our business development service in our business. We believe that the right mindset and proper coaching are key elements in business development. We recommend this Think Out Loud MasterMinds program because it benefits those who want to excel in their professional lives as well as their personal lives.

Our first group of mastermind meetings will begin August 26th and will be held until the week of October 1st. For table sign-ups, contact D’Mention Systems corporate office between 9 AM and 4 PM to request and invitation to a Masterminds Meeting Table: (520) 229-8730

More information can be found at these sites:

Mysqldump equivalent for Microsoft SQL Server

August 19th, 2009

If you end up working in a wide variety of systems, you inevitably end up on system X, wishing that you had a specific tool or feature from system Y.

Today this happened to me, in that I wished I had something like mysqldump, but for MS SQL Server.  The pointy-clicky stuff is fine in certain circumstances, but fails spectacularly in others.

This is a scenario where I didn’t own both boxes, and only have limited access to the source machine.  So detach/attach and many other options are out of the picture.  Copy database fails in a variety of ways in this situation, and the Export Data function also fails, as it’s not smart enough to try to insert table records in the right order to satisfy foreign key constraints.

And to top it off, I’d really like to have a nice snapshot of schema and data (this is a very small db) to push into SVN.

Unfortunately, the built in tools for MS SQL failed quite spectacularly here.  This is a particularly frustrating limitation, as what should have been a 10-minute process to recreate the database on a new box turns into a sticky mess.

Fortunately, there is a solution, and it works quite well.  To top things off, it’s open source (MS-PL) and created by Microsoft.

Enter the Database Publishing Wizard, which is a part of the SQL Server Hosting Toolkit, up on CodePlex.

So now we can do wonderful things like this from the command line:

SqlPubWiz.exe script -d DBNAME -S SERVERNAME c:\db-schema.sql -schemaonly

and

SqlPubWiz.exe script -d DBNAME -S SERVERNAME c:\db-data.sql -dataonly

For the data extract, it actually uses an intelligent ordering, and produces SQL that generally ‘just works’, even with complex foreign key constraints.

There are other options as well if you want to control it to a greater degree.

This is close enough to mysqldump that it makes me quite happy, and even has a simpler syntax (though fewer options).  Also note that this isn’t really ideal for very large databases.  SSIS, bcp and other tools are a better choice in that scenario.

Do you have tools you like better?  Let me know in the comments.

Andrew Hollamon
D’Mention Systems, LLC

Follow my other blog at:
http://www.dmentionsystems.com/category/andrews-say/

Follow my business partner Mike’s blog at:
http://www.dmentionsystems.com/category/mikes-take/

Are you looking for database or software experts to help you with your software project?  Or need to integrate multiple systems or databases?

Contact us here for a free consultation.

Business Development With Tech Savvy

August 13th, 2009

THINKING OF STARTING A BUSINESS?

Have you been dreaming of starting your own business? Do you have the ideas but don’t know where to start? This can be one of the most unique and exciting experiences one can go through. Even if you think that you have a long road ahead of you, don’t worry you’re halfway there!

Taking the first steps to get started can be a challenge. Sometimes knowing where to start is not easy, especially if there are significant technical aspects involved. This process usually begins with the need for a website, web system and a search for expert technology capacity.

A PATH TO SUCCESS

One way to set up your business for success is to team up with a technology company that not only specializes in web application development, but also has knowledge and experience with business development. D’Mention Systems presents a diverse variety of services and experience to those who want to take their ideas and dreams of starting their own business and making it into a reality.

A SOLID TEAMATE

We offer more than just technology products. We have the capacity to help manage a small business through organizational expertise and deep experience. We are able to offer start-up businesses a solid administrative accounting department, management assistance, outreach, and tech support.

These elements are central to the infrastructure of any business, are often overlooked, and may not be obtainable for many start-ups due to their tight budgets.

KNOWING START-UPS

We know start-ups at D’Mention Systems-we have gone through the process ourselves. We can design a budget that can allow your organization to get a started.

We also provide one-on-one attention to each of our clients. You will deal directly with the experts.

SPECIAL OFFER

We are offering a free one-on-one consultation for those who are interested in learning more about our services. Click here to fill out our free inquiry form and we will contact you to set up a meeting. Let’s see if it’s a match!

 

If you liked this blog, here are some others you may enjoy:

Also take a look at our google site: D’Mention Systems

Do you know anyone who has a technical project–large or small, such as a website, software project, or network setup that is stalled or half complete? I’m never too busy for a referral, so if you think I could help–feel free to drop us an inquiry by clicking here…