Category Archives: Business

tip: passive error and warning messages

It’s best to put error/warning messages in very passive, non-blaming language, especially if users might see them. Avoid exclamation marks unless something is seriously wrong and they need to take immediate action, and in that case tell them which actions … Continue reading

Posted in Business, Musings, Programming, System/DB Administration | Leave a comment

Onboarding tasks: SQL Server

https://www.mssqltips.com/sqlservertip/4871/sql-server-dba-onboarding-checklist/  

Posted in Business, Linkdump, SQL Server | Leave a comment

Lean Factory HowTo from IndustryWeek

http://www.industryweek.com/continuous-improvement/how-set-lean-factory-works-part-1 http://www.industryweek.com/continuous-improvement/how-set-lean-factory-works-part-2  

Posted in Business | Leave a comment

Competitors of Siemens PLM

For future reference: Siemens SIMATIC IT Unicam eMES for Electronics Manufacturing. What’s new in v11? Dassault Systemes ARAS SAP Oracle PTC Autodesk See also: https://www.g2crowd.com/products/siemens-teamcenter/competitors/alternatives Siemens  SIMATIC IT Unicam eMES competitors: Aegis Aster Itac Mentor (Valor) Siemens PLM Software Vayo  

Posted in Business | Leave a comment

The Five Questions of Flow

From an interesting webinar, “Creating a Visual Office for Operational Excellence” by jenkrider@instituteopex.org https://instituteopex.org/site/webinars/creating_a_visual_office_for_operational_excellence. One of the key takeaways emphasized is that monthly updates to charted metrics are a tool, not visual management. The goal of visual management is to remove a … Continue reading

Posted in Business | Leave a comment

On the far side of DevOps

Lately I’m feeling like I am on the far side of DevOps. If you consider DevOps to be a bridge under construction over the chasm between business and IT, I am on sitting on the reaching edge of the business … Continue reading

Posted in Business, Musings, Project Management | Leave a comment

Synchronicity, serendipity, and Server service schedules

Background: For the past year, I have been receiving nightly administrative monitoring messages from our production database. A recent project required a nightly quality check with associated alert. I used a technique similar to the well-proven monitoring messages, and after careful testing … Continue reading

Posted in Business, Programming, Project Management, SQL Server, System/DB Administration | Leave a comment

MES rollout white papers etc

How to Leverage a Two-Tiered ERP Strategy with MES An Emerging Trend: Two-Tiered ERP Strategy 5 Steps to Successfully Deploy IT Systems http://www.criticalmanufacturing.com/newsroom/blog/2013/11/guidetomes/ http://www.google.com/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=10&cad=rja&ved=0CIABEBYwCQ&url=http%3A%2F%2Fwww.gzs.si%2Fpripone%2F20465%2Foei40734d20465.pdf&ei=d0CWUtriL5PnsATYs4KQAw&usg=AFQjCNH_y3YXNkoy3WxhzWub7GgClMoI8A&sig2=fIrZNcv1aDk-dMfYucgm2g&bvm=bv.57155469,d.cGU http://www.ats-global.com/gb/en/84_food-beverage/1348_probably-the-world-s-best-mes-system.html?do=article http://www.scdigest.com/ontarget/13-06-19-3.php?cid=7166 http://geometricglobal.com/wp-content/uploads/2013/03/White_Paper_Ensuring_Success_of_Global_MES_Developments_Aug093.pdf http://www.mescc.com/index.html http://www.instrumentation.co.za/article.aspx?pklarticleid=3791 http://www.apriso.com/blog/tag/global-roll-out/ http://www.cognizant.com/InsightsWhitepapers/Best-Practices-for-Global-MES-Rollouts.pdf http://www.automationworld.com/operations/mes-implementation-best-practices

Posted in Business, Project Management | Leave a comment

Change Data Capture pattern

We’re having a problem with ETL between our ERP and MES systems. We use a timestamp-based periodic export. It occasionally skips a record. We have determined this is due to the duration a transaction is open. If an export occurs … Continue reading

Posted in Business, Programming, SQL Server, System/DB Administration | Leave a comment

Internal SLAs

Thanks to Google, here are some interesting links regarding internal service level agreements: http://www.bhconsulting.ie/Developing%20an%20Internal%20SLA.pdf http://en.wikipedia.org/wiki/Service-level_agreement http://pic.dhe.ibm.com/infocenter/tivihelp/v49r1/index.jsp?topic=%2Fcom.ibm.mbs.doc%2Fsla%2Fc_types_slas.html    

Posted in Business, System/DB Administration | Leave a comment