It's been a while since I've posted some code, but I did a nice little SQL hack today that I've been puzzling over for a while. I freely admit that I may have made this more difficult with the original data model, but the die has been cast. Consider a single SQL table that captures project updates as comments note that this table also allows me to change the "phase" (ex. Design, Development, Test, Production) and/or Status (ex. Proposed, Red,…
I met Lora Cecere this evening, well-known AMR analyst for Supply Chain - a good conversation about the deeper potential for supply chain integration technology. The topic: are there bigger benefits here? Is it really only limited to optimization of your own supply chain? Don't get trapped into thinking that the business benefit of supply chain integration is limited to increased visibility - look at the different scenarios. A simplistic view of an integrated supply chain shows all the elements,…
I got a call a few weeks ago that put me in a slightly cranky, slightly bemused mood. This is not a recent phenomenon - it has happened at every company in my career. A few of the big-name vendors (including IBM, Oracle, SAP, Microsoft, HP, and others) have no problem peppering different people in a company with requests for basic information (What systems are your running? Do you have a general ledger system? Do you use computers? Do you…
Here's a typical IT scenario: each quarter, you need to check audit user access to a critical application. Your internal security standards require that you revoke access for those who haven't been on the system for over 90 days. I've seen this before, and the process (at the time) had many challenges: It's manual; we did a quick-and-dirty set of steps years ago to cover the minimum requirements, that involves extracts from application logs, file transfers MS Access and MS…
Eric Savitz posted an interesting article (via Techmeme) reviewing a VC discussion earlier this month, on how the enterprise software business looks increasingly like big pharma. Their focus was the contemporary businesses, but one quote got me thinking: ... the salient attribute of big pharma ... is the plausibility of a new entrant to raise capital and get to be a real business before they are acquired. Things were much the same in the 90's, when the "little guys" of…
Catching up on old links that I wanted to comment on - here is a selection regarding some PowerPoint best practices, including five of my personal favorites that I don't often see in those ubiquitous articles / postings detailing the Secrets of Presentation Success ... Under-Emphasized PowerPoint Best Practices Never Embed Objects: I grew to dislike embedded objects years ago, when computers could barely handle the launch of an Excel instance from within Word, or Visio from within PowerPoint. This…
alternate title - Techs Managing Techs; not Required, but it Helps This evening, catching up with my RSS feeds, I happened upon this old screencast from Jon Udell, looking over the shoulder as he and Anders Hejlsberg take a look at LINQ, a work-in-process set of extensions for the .NET framework. Udell captured my curiousity with this description of the session ... You have to be a certain kind of person to enjoy watching Anders run LINQ through its paces,…
Consider these conversations over the past few weeks: At SAPPHIRE, I spoke with many from the big Fortune 1000-type companies, on outsourcing (or "co-sourcing", a new PC term). Lots of discussion around India; they have memorized the flight schedules, swap stories about social disparity and the caste system, and rattle off all of the cities they have visited. Note that it's not all about India; I talked with organizations who have moved their SAP Center of Excellence (support and/or development) to…
In a recent NetworkWorld piece, Gibbs wrote about the tagging meme, and where it apparently sits on the technology life cycle. No new insights for me there (but possibly fits the CEPP rule for others); I was involved in a number of knowledge management (KM) projects back in my Monsanto days (IAPL) [note to self: too many acronyms, hhh] and we hit many of the classic walls; CRM systems that failed because sales reps guard their customer intelligence Collaboration spaces that…
Had a really good conversation about metrics the other day. We've been discussing ways to express how our systems are performing, delivering value, and staying available - and I'd like to use the same general structure for all systems, regardless of function (transactions, integrations, analytics) or platform (Wintel, AS/400, Open Systems). For each type of metric, we need to understand two dimensions: Performance against some Target. This can either be a baseline (a minimum or average expected score), or a…