<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:admin="http://webns.net/mvcb/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">
<channel>
<title>Just Enough Governance for Notes Blog</title>
<description>Just Enough Governance for Notes Blog</description>
<lastBuildDate>Tue, 10 Nov 2009 22:10:52 +0500</lastBuildDate>
<link>http://www.governancefornotes.com/blog/governanceblog.nsf</link>
<image>
<title>Just Enough Governance for Notes Blog</title>
<url>http://www.governancefornotes.com/blog/governanceblog.nsf/rss.gif</url>
<link>http://www.governancefornotes.com/blog/governanceblog.nsf</link>
</image>
<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" href="http://feeds.feedburner.com/justenoughgovernance" type="application/rss+xml" /><feedburner:emailServiceId>justenoughgovernance</feedburner:emailServiceId><feedburner:feedburnerHostname>http://feedburner.google.com</feedburner:feedburnerHostname><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com" /><item>
<title>Project Held Hostage</title>
<link>http://feedproxy.google.com/~r/justenoughgovernance/~3/Fvg5tfchDkw/SJON-7WYH95-Project_Held_Hostage</link>
<description><![CDATA[ Several years ago I was working on a new software release for a previous employer when the CTO came into my office asking a favor. He wanted me to let one of the developers on the project implement a feature &#8220;his way&#8221;. You see, the issue was that he found ... ]]></description>
<dc:creator>Scott Johnsen</dc:creator>
<comments>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7WYH95-Project_Held_Hostage</comments>
<guid isPermaLink="false">http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7WYH95-Project_Held_Hostage</guid>
<content:encoded><![CDATA[ Several years ago I was working on a new software release for a previous employer when the CTO came into my office asking a favor. He wanted me to let one of the developers on the project implement a feature &#8220;his way&#8221;. You see, the issue was that he found what he thought was a clever way to implement one of the new features required by the users. 
<BR><BR>
The problem with letting him do things his way was that other developers on the project felt it simply wouldn&#8217;t work. More importantly, the business said this solution failed to meet their requirement. The proposed design was pretty cool, but we really needed something that would work AND met the needs of the business.
<BR><BR>
So why was the CTO so adamant about this? It turned out that this particular developer possessed some unique knowledge because he had been with the company for a very long time and worked on many business critical applications over the years. The CTO was afraid that he might quit if he didn&#8217;t get his way on this new project.
<BR><BR>
I couldn&#8217;t believe what I was hearing. Essentially, the CTO wanted to let the project fail in order to retain this guy. Incredible! 
<BR><BR>
I spent a lot of time working with the VP of Development to find a way around this with no real solution in sight. As it turned out, the guy quit within a week. Whew! That was a close call.
<BR><BR>
In telling this story since then, I&#8217;ve come to realize that my experience is not unique. Projects are often held hostage by a key member of the team. So what can you do to prevent your project from turning into a complete disaster when it is being held captive? 
<BR><BR>
There are a few things you can do, but it is important to recognize that losing those sorts of people doesn&#8217;t usually end up being as painful as you think it&#8217;s going to be.
<BR><BR>
Following is a short list of suggestions:<BR>
<UL><LI>NEVER allow individuals to hold projects hostage to their expertise, experience or knowledge. It is a rare project that ends in success when this happens. </LI>
<LI>If a hostage situation occurs, remove the problem immediately. Project delays and challenges will only increase until the problem is addressed. It&#8217;s better to make this change on <b>your</b> terms instead of theirs. </LI>
<LI>Contact the business immediately to let them know what happened. There may be a delay in the project because of it, but do your best to minimize any negative impact this might have on the schedule. </LI>
<LI>Recognize (to the team and yourself) that removal of a key resource may slow a project down at first, but a well managed team will recover quickly and produce a much better result in the long run.</LI></UL>
<BR>
I&#8217;d love to hear your ideas on this. Have you been in a similar situation? If so, what did you learn that might be helpful to others who find themselves in a similar situation?<br /> <img src="http://feeds.feedburner.com/~r/justenoughgovernance/~4/Fvg5tfchDkw" height="1" width="1"/>]]></content:encoded>
<pubDate>Mon, 19 Oct 2009 08:59:20 +0500</pubDate>
<slash:comments>2</slash:comments>
<category>Risk</category>
<category>Good Practice</category>
<feedburner:origLink>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7WYH95-Project_Held_Hostage</feedburner:origLink></item>
<item>
<title>Glass Houses ...</title>
<link>http://feedproxy.google.com/~r/justenoughgovernance/~3/UTCAsOIsIZ8/SJON-7W4RQA-Glass_Houses</link>
<description><![CDATA[ Very interesting post on Ed Brill's blog recently, though I don't think this is as unique to any one platform as Ed wants you to believe. This is just as easy to do in Domino as it is in Google and comes down to the management of security policies. 

How ... ]]></description>
<dc:creator>Craig Schumann</dc:creator>
<comments>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7W4RQA-Glass_Houses</comments>
<guid isPermaLink="false">http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7W4RQA-Glass_Houses</guid>
<content:encoded><![CDATA[ Very interesting post on <a href="http://www.edbrill.com/ebrill/edbrill.nsf/dx/new-york-times-whoops-students-going-google-get-to-read-each-others-emails-" title="Ed Brill's blog">Ed Brill's blog</a> recently, though I don't think this is as unique to any one platform as Ed wants you to believe. This is just as easy to do in Domino as it is in Google and comes down to the management of security policies. 
<BR><BR>
How many organizations out there are dutifully managing ACLs using groups? If an unknowing admin were to add say, the "Everyone" group to a group that was nested, at some level, inside the "LocalDomainAdmins" group, how long would it take you to discover that? How many apps would be affected? How long had it been since the change was made? My guess is that there are very few people who would have even known that it happened, let alone, what the damage was.
<BR><BR>
A deep understanding of the contents of <b>ALL</b> (yes I said all) the groups in your address book is incredibly important. However knowing the effect a group has on the access to applications (mail included) is even more important. The problem is being able to quickly learn what the <i>effective access</i> is to your applications at all times. This can be a full time job and very difficult to do on a regular basis. Just knowing that a group was changed is one thing. Knowing what effect that had is what is really important. 
<BR><BR>
Exactly this issue is what led to the creation of <a href="http://www.teamstudio.com/new/products/administration.html" title="Teamstudio's Admin Suite">Teamstudio's Admin Suite</a> of solutions. If you are having difficulty knowing who changed what and when, who has access (<b>really!</b>) to which applications, you are not alone. Feel free to give us a call, or contact me directly at craig_schumann@teamstudio.com. I would be happy to show you how we can help.
<br /> <img src="http://feeds.feedburner.com/~r/justenoughgovernance/~4/UTCAsOIsIZ8" height="1" width="1"/>]]></content:encoded>
<pubDate>Mon, 21 Sep 2009 16:13:09 +0500</pubDate>
<slash:comments>3</slash:comments>
<category>Notes Threats</category>
<feedburner:origLink>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7W4RQA-Glass_Houses</feedburner:origLink></item>
<item>
<title>Stagnate or Innovate</title>
<link>http://feedproxy.google.com/~r/justenoughgovernance/~3/EwNOfw4Q89Q/SJON-7VXHLD-Stagnate_or_innovate</link>
<description><![CDATA[ IBM surveyed more than 2,500 CIOs and compared what executives at companies with high-profit growth are doing vs. those at low-growth companies. The results are interesting. 

Highlights include:




 


Do you integrate business with technology to ... ]]></description>
<dc:creator>Scott Johnsen</dc:creator>
<comments>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VXHLD-Stagnate_or_innovate</comments>
<guid isPermaLink="false">http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VXHLD-Stagnate_or_innovate</guid>
<content:encoded><![CDATA[ IBM <a href="http://www.ibm.com/ciostudy" title="surveyed">surveyed</a> more than 2,500 CIOs and compared what executives at companies with high-profit growth are doing vs. those at low-growth companies. The results are interesting. 
<BR><BR>
<b>Highlights include:</b>
<BR>
<Table>
<table cellspacing "1">
<table width=90%>
<td colspan="3"> 
<td rowspan="5">
<tr>
<td>Do you integrate business with technology to innovate?</td> <td><font color="blue">High Growth: 64%</font></td> <td><font color="red">Low Growth: 33%</font></td></tr>
<tr>
<td>Do you focus your time on providing core technology services?</td> <td><font color="blue">High Growth: 23%</font></td> <td><font color="red">Low Growth: 40%</font></td></tr>
<tr>
<td>Do you aggressively turn data into actionable information? </td><td><font color="blue">High Growth: 58%</font></td> <td><font color="red">Low Growth: 36%</font></td></tr>
<tr>
<td>Do you expect standardized business processes? </td><td><font color="blue">High Growth: 61%</font></td><td> <font color="red">Low Growth: 50%</font></td></tr>
<tr>
<td>Do you manage change successfully? </td><td><font color="blue">High Growth: 61%</font> </td><td><font color="red">Low Growth: 43%</font></td></tr>
</Table>
<BR><BR>
The full report can be obtained at www.ibm.com/ciostudy. 
<br /> <img src="http://feeds.feedburner.com/~r/justenoughgovernance/~4/EwNOfw4Q89Q" height="1" width="1"/>]]></content:encoded>
<pubDate>Wed, 16 Sep 2009 09:17:20 +0500</pubDate>
<slash:comments>0</slash:comments>
<category>IT Trends</category>
<feedburner:origLink>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VXHLD-Stagnate_or_innovate</feedburner:origLink></item>
<item>
<title>Resist the List</title>
<link>http://feedproxy.google.com/~r/justenoughgovernance/~3/S-oJQ4u6EmE/SJON-7VWG83-Resist_the_list</link>
<description><![CDATA[ According to s Business Software Alliance survey, these are the 10 industries most often reported for software piracy:


Manufacturing
Sales/Distribution
Service
Financial services
Software development (Surprising?)
IT ... ]]></description>
<dc:creator>Scott Johnsen</dc:creator>
<comments>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VWG83-Resist_the_list</comments>
<guid isPermaLink="false">http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VWG83-Resist_the_list</guid>
<content:encoded><![CDATA[ According to s <a href="http://www.bsa.org/country.aspx" title="Business Software Alliance">Business Software Alliance</a> <a href="http://www.itbusiness.ca/it/client/en/home/News.asp?id=54518&PageMem=2" title="survey">survey</a>, these are the 10 industries most often reported for software piracy:

<ol><ol>
<li>Manufacturing</li>
<li>Sales/Distribution</li>
<li>Service</li>
<li>Financial services</li>
<li>Software development (Surprising?)</li>
<li>IT consulting</li>
<li>Medical</li>
<li>Engineering</li>
<li>Education</li>
<li>Consulting</li>
</ol></ol>
Question: Are these really the worst industries for software piracy? Or do they simply contain the most whistle-blowers? 
<BR><BR>
The September 14 issue of <i>Computerworld</i> has an interesting <a href="http://www.computerworld.com/s/article/342035/Gotcha_Pursuing_software_pirates" title="article">article</a> on the topic.
<br /> <img src="http://feeds.feedburner.com/~r/justenoughgovernance/~4/S-oJQ4u6EmE" height="1" width="1"/>]]></content:encoded>
<pubDate>Tue, 15 Sep 2009 08:06:24 +0500</pubDate>
<slash:comments>0</slash:comments>
<category>Worst Practices</category>
<feedburner:origLink>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VWG83-Resist_the_list</feedburner:origLink></item>
<item>
<title>One Man's Trash ...</title>
<link>http://feedproxy.google.com/~r/justenoughgovernance/~3/c9uawaE6G3E/SJON-7VRFZQ-One_mans_trash</link>
<description><![CDATA[ The role of Technical Director (TD) at Teamstudio is responsible for pre-sales activities as well as post-sales implementation and training services. We have an opportunity to learn about a lot of Lotus Notes implementations. When asked a general question ... ]]></description>
<dc:creator>Scott Johnsen</dc:creator>
<comments>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VRFZQ-One_mans_trash</comments>
<guid isPermaLink="false">http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VRFZQ-One_mans_trash</guid>
<content:encoded><![CDATA[ The role of Technical Director (TD) at Teamstudio is responsible for pre-sales activities as well as post-sales implementation and training services. We have an opportunity to learn about a lot of Lotus Notes implementations. When asked a general question about our clients, The TDs will usually respond with &#8220;it depends&#8221;. Our customers are quite varied, and surprisingly unique from one another in a lot of ways.
<BR><BR>
Since we have a variety of products to help our customers understand <a href="http://www.teamstudio.com/new/products/security-manager.html" title="who has access to what">who has access to what</a>, <a href="http://www.teamstudio.com/new/products/usage-monitor.html" title="who has accessed what and when">who has accessed what and when</a>, as well as <a href="http://www.teamstudio.com/new/products/agent-registry.html" title="what Notes agents have access to">what Notes agents have access to</a>, we tend to learn a lot about our customers Lotus Notes/Domino environments, applications and processes. 
<BR><BR>
One area that is more consistent across our customer base is with regard to data loss prevention (DLP) capabilities. It is surprising to me the number of customers we talk to who either have not implemented a DLP plan or are unaware of such a plan. You might not think your company has much in the way of confidential data, but one man&#8217;s trash is another man&#8217;s treasure. 
<BR><BR>
Think about what exists on your company&#8217;s servers, databases, laptops and file systems across your company. You may not store credit card information, but every company has financial statements, sales projections and employee lists that are valuable to someone outside your organization.
<BR><BR>
If you haven&#8217;t already implemented a DLP solution, it&#8217;s worth a look. Not only can this save you from a very expensive and painful data breach, but it can also help you with your data discovery requirements.<br /> <img src="http://feeds.feedburner.com/~r/justenoughgovernance/~4/c9uawaE6G3E" height="1" width="1"/>]]></content:encoded>
<pubDate>Thu, 10 Sep 2009 07:56:16 +0500</pubDate>
<slash:comments>0</slash:comments>
<category>Good Practice</category>
<category>Risk</category>
<feedburner:origLink>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VRFZQ-One_mans_trash</feedburner:origLink></item>
<item>
<title>Guess what I forgot to bring to the gym this time?</title>
<link>http://feedproxy.google.com/~r/justenoughgovernance/~3/G61FdTLKSow/SJON-7VPFR8-Guess_What_I_Forgot</link>
<description><![CDATA[ Sandals.  Not a mission critical piece of workout gear, but if you want to avoid a nasty fungus....  Two days earlier I saw one of our account managers at the gym in stocking feet - he forgot his sneakers.  But he has two pair in his trunk.  (Side bar - at ... ]]></description>
<dc:creator>John Kingsley</dc:creator>
<comments>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VPFR8-Guess_What_I_Forgot</comments>
<guid isPermaLink="false">http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VPFR8-Guess_What_I_Forgot</guid>
<content:encoded><![CDATA[ Sandals.  Not a mission critical piece of workout gear, but if you want to avoid a nasty fungus....  Two days earlier I saw one of our account managers at the gym in stocking feet - he forgot his sneakers.  But he has two pair in his trunk.  (Side bar - at our office in the US, you are very likely to run into some Teamstudio person at the gym.  There is another company in our complex where you are very likely to run into one of them on a cigarette break down by the pond.  Talk about corporate culture!)  
<BR><BR>
Anyway, I have been to the gym dozens of times, but sometimes something gets left off.  Have you tried running with a dead MP3 player?  It turns out that any manual process, like getting ready to go to the gym or releasing a new update of an application, can occasionally have missed steps.  No matter how often you do it, no matter how well documented your procedures are.   Missing a step in the gym prep routine isn't usually a big deal.  But missing a step in releasing that application can be.  I know one of our customers didn't have that single property to Require SSL connection turned on, and ended up having to pay for credit protection for thousand of customers.  
<BR><BR>
I am sure you all have your own horror stories.  The moral of the story is if you can automate your release procedures so that you can have a repeatable process where nothing gets skipped, you should.  It also turns out we have worked with a lot of companies to do this, and could probably help you as well.<br /> <img src="http://feeds.feedburner.com/~r/justenoughgovernance/~4/G61FdTLKSow" height="1" width="1"/>]]></content:encoded>
<pubDate>Tue, 08 Sep 2009 07:42:40 +0500</pubDate>
<slash:comments>0</slash:comments>
<category>Good Practice</category>
<category>Build Process</category>
<category>Risk</category>
<feedburner:origLink>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7VPFR8-Guess_What_I_Forgot</feedburner:origLink></item>
<item>
<title>Automation Station</title>
<link>http://feedproxy.google.com/~r/justenoughgovernance/~3/3JWE-Acbl5k/SJON-7ULT8Z-Automation_Station</link>
<description><![CDATA[ 
Automation Station

As we have discussed many times
on this blog, eliminating tedious manual chores from Lotus Notes Administrators
will reduce the chance for errors. We have also discussed how this will
allow Admins to work on more interesting tasks. ... ]]></description>
<dc:creator>Scott Johnsen</dc:creator>
<comments>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7ULT8Z-Automation_Station</comments>
<guid isPermaLink="false">http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7ULT8Z-Automation_Station</guid>
<content:encoded><![CDATA[ 
<br /><font size='3' face="Times New Roman">Automation Station</font>
<br />
<br /><font size='3' face="Times New Roman">As we have discussed many times
on this blog, eliminating tedious manual chores from Lotus Notes Administrators
will reduce the chance for errors. We have also discussed how this will
allow Admins to work on more interesting tasks. One of the things we don&#8217;t
talk about much is how adding automation to your repertoire will allow
them to deliver a more consistent, agile and auditable service for your
business.</font>
<br />
<br /><font size='3' face="Times New Roman">According to a recent Analytics
Automation </font><a href="http://community.solutionscenter.techweb.com/docs/DOC-1428?sid=automation&amp;cid=edt_art"><font size='3' face="Times New Roman"><u>survey</u></font></a><font size='3' face="Times New Roman">
done by InformationWeek, half of respondents claim to have saved 50% of
all full-time employees previously involved in those processes. That&#8217;s
impressive. </font>
<br />
<br /><font size='3' face="Times New Roman">As businesses expand and contract
in response to today&#8217;s evolving business realities, Admins must find ways
to capture, track and analyze changes to applications, ACLs, application
agents, etc. This is not an easy task certainly, but it&#8217;s critical because
understanding those changes is the basis for securing data, improving service
levels and meeting compliance requirements. Automation of key tasks can
certainly help here.</font>
<br />
<br /><font size='3' face="Times New Roman">Finally, enforcement of existing
regulations, changes to those regulations and new regulations is very likely
to improve. The worldwide financial crisis experienced over the last 2
years and the almost guaranteed overhaul of the health care system in the
United States are only two of the reasons we can be sure more regulations
are coming and better enforcement of those regulations are likely to occur.
As such, the auditable service you provide will become even more important
than it is today. Doing so through automation will not only be helpful,
it could very well be required!</font>
<br /> <img src="http://feeds.feedburner.com/~r/justenoughgovernance/~4/3JWE-Acbl5k" height="1" width="1"/>]]></content:encoded>
<pubDate>Tue, 04 Aug 2009 17:31:07 +0500</pubDate>
<slash:comments>0</slash:comments>
<category>Good Practice</category>
<feedburner:origLink>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7ULT8Z-Automation_Station</feedburner:origLink></item>
<item>
<title>So You Think the User Interface Does Not Matter</title>
<link>http://feedproxy.google.com/~r/justenoughgovernance/~3/fVs8qeP_O0A/SJON-7U5SKJ-So_You_Think_the_User_Interface_Doesn't_Matter</link>
<description><![CDATA[ Due to circumstances I will not go into here (except to say that none of them were any fun), I had the opportunity to drive several different vehicles than my normal transportation.  I was on my way home and it started to rain,  Now how do you turn on the ... ]]></description>
<dc:creator>John Kingsley</dc:creator>
<comments>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7U5SKJ-So_You_Think_the_User_Interface_Doesn't_Matter</comments>
<guid isPermaLink="false">http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7U5SKJ-So_You_Think_the_User_Interface_Doesn't_Matter</guid>
<content:encoded><![CDATA[ Due to circumstances I will not go into here (except to say that none of them were any fun), I had the <i>opportunity</i> to drive several different vehicles than my normal transportation.  I was on my way home and it started to rain,  Now how do you turn on the wipers?  Is it that dial or on that stick thing?  No, that's the rear wiper.  Oops, that's the sun roof, not what I wanted on a rainy day.  I finally got that thing working.  
<BR><BR>
Now it is getting dark - how do I turn on the lights?  It's dark outside and now it's dark inside and I can't even see where a switch might be.  But I know if I open the door a light will go on inside - better pull over first before opening that door.  Fortunately, the turn signal is one of those things that is consistent for every car (it's the stick on the left side of the steering wheel - you push it down to tell people you are turning left and push it up to tell people you are turning right.  I say that because evidence suggests not many people know this.)   And you know the other thing that is consistent between cars?  The ever intuitive push-and-hold to set your pre-sets on the radio.  
<BR><BR>
The point, is, if your controls are consistent between your applications, it is easier for your users when switching from one to another.  And it doesn't really matter that the icon for save is a floppy disk (at least it is a 3.5 inch disc, not a 5 1/4 one!) - people just know what it means.  And don't worry - the terminology will eventually catch up (who knows what a Return key did?).<br /> <img src="http://feeds.feedburner.com/~r/justenoughgovernance/~4/fVs8qeP_O0A" height="1" width="1"/>]]></content:encoded>
<pubDate>Mon, 20 Jul 2009 16:56:46 +0500</pubDate>
<slash:comments>3</slash:comments>
<category>Coding Practices</category>
<feedburner:origLink>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/SJON-7U5SKJ-So_You_Think_the_User_Interface_Doesn't_Matter</feedburner:origLink></item>
<item>
<title>Data Integrity Audit</title>
<link>http://feedproxy.google.com/~r/justenoughgovernance/~3/EEnvR35cLWU/KFRA-7U2J88-Data-Integrity-Audit</link>
<description><![CDATA[ While there can be many contributing factors to data integrity errors, making sure you understand the true cause of your data integrity issues has to be the first step. Failing to do this will cause you to be continuously fixing symptoms and never have a ... ]]></description>
<dc:creator>Scott Johnsen</dc:creator>
<comments>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/KFRA-7U2J88-Data-Integrity-Audit</comments>
<guid isPermaLink="false">http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/KFRA-7U2J88-Data-Integrity-Audit</guid>
<content:encoded><![CDATA[ While there can be many contributing factors to data integrity errors, making sure you understand the true cause of your data integrity issues has to be the first step. Failing to do this will cause you to be continuously fixing symptoms and never have a complete solution. To help prevent data integrity problems from occurring in the first place, you need to look at your data security and database usage statistics to determine where data is actively being compromised or has potential to be compromised. The only way to do this is by knowing exactly what your users are doing. You should design your application data management policy so you can answer the following questions:<BR>
<UL><LI>Question: Do you know who is accessing and changing vital or sensitive data?
<LI>Comment: Collect the access logs for all critical applications and documents. Design all applications to support document change histories.<BR> 
</UL>
<UL><LI>Question: Are you confident you know who has access to your high impact production applications?
<LI>Comment: Make sure all application access is regularly audited. Preventing abuse by unauthorized users is the foundation of any data integrity policy. This is outlined in the Security Management policy.
</UL>
<BR><a href="http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/KFRA-7U2J88-Data-Integrity-Audit" title="Data Integrity Audit">(read more)</a>
<br /><UL><LI>Question: Do you know which applications are being used at all?
<LI>Comment: Abandoned applications may contain sensitive data. Do not let unused applications remain on the server.<BR>
</UL>
<UL><LI>Question: Do you have an easy way to deal with replication conflicts that preserve data that would otherwise be lost?
<LI>Comment: Many users just delete a replication conflict when they are discovered. Do not let this to happen as important data may be lost.<BR>
</UL>
<UL><LI>Question: Can you be alerted when an error is introduced before a customer or user finds it?
<LI>Comment: Even though notification occurs after the error has occurred, you are in a position to address the issue proactively. Early identification of problems can help you resolve them more easily, and user notification before they realize there is a data issue can result in improved customer satisfaction.<BR>
</UL>
<UL><LI>Question: Is your QA environment a mirror of the production environment? 
<LI>Comment: During testing is the best time to identify any potential data integrity weaknesses. Use QA to monitor issues in order to keep to a minimum the number of users encountering problems.<BR>
</UL>
To sum up: You should start with any new data management policy by first identifying where your existing issues are. While these issues are being addressed, institute the necessary prevention and monitoring changes to help prevent these issues from reoccurring. On the prevention side, a lot can be accomplished with training and application modifications. <img src="http://feeds.feedburner.com/~r/justenoughgovernance/~4/EEnvR35cLWU" height="1" width="1"/>]]></content:encoded>
<pubDate>Fri, 17 Jul 2009 09:49:04 +0500</pubDate>
<slash:comments>0</slash:comments>
<category>Application</category>
<category>Development</category>
<category>Best Practices</category>
<category>Coding Practices</category>
<feedburner:origLink>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/KFRA-7U2J88-Data-Integrity-Audit</feedburner:origLink></item>
<item>
<title>Data Integrity Risks from External Systems</title>
<link>http://feedproxy.google.com/~r/justenoughgovernance/~3/k5Tb1Av2aAU/KFRA-7TYQE6-Data-Integrity-Risks-from-External-Systems</link>
<description><![CDATA[ Where applications replicate or update data with external sources such as relational database systems, changes to applications must be tested extensively with realistic data. If done incorrectly, small changes to applications can have catastrophic effects on ... ]]></description>
<dc:creator>Scott Johnsen</dc:creator>
<comments>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/KFRA-7TYQE6-Data-Integrity-Risks-from-External-Systems</comments>
<guid isPermaLink="false">http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/KFRA-7TYQE6-Data-Integrity-Risks-from-External-Systems</guid>
<content:encoded><![CDATA[ Where applications replicate or update data with external sources such as relational database systems, changes to applications must be tested extensively with realistic data. If done incorrectly, small changes to applications can have catastrophic effects on data integrity. Such situations require:<UL>
<LI>Defined processes for analyzing and assessing whether data integrity requirements have been met</LI>
<LI>Detailed rollback plans including plans for how to restore integrity of existing data and new data created post-deployment</LI>
<LI>Coded and tested rollback functionality, if applicable</LI>
<LI>Documented process for determining if the planned rollback can successfully restore data integrity</LI>
<LI>Identification of parties responsible for decision making in the event that roll-backs or other drastic actions are required</LI></UL>
Upgrades to applications that require data transformations pose similar risks and should be handled with the same level of care.<br /> <img src="http://feeds.feedburner.com/~r/justenoughgovernance/~4/k5Tb1Av2aAU" height="1" width="1"/>]]></content:encoded>
<pubDate>Wed, 15 Jul 2009 15:05:46 +0500</pubDate>
<slash:comments>0</slash:comments>
<category>Data Management</category>
<category>Risk</category>
<feedburner:origLink>http://www.governancefornotes.com/blog/governanceblog.nsf/d6plinks/KFRA-7TYQE6-Data-Integrity-Risks-from-External-Systems</feedburner:origLink></item>
</channel>
</rss>
