Category Archives: Business

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