Monthly Archives: November 2013

Interesting… report viewer

Bringin back the RDL. It’s been a while! http://gotreportviewer.com/

Posted in Programming, SQL Server | 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

Rule of thumbs

My rule of thumb, when I’m working on projects (also called my rule of keeping both thumbs): When you begin making stupid mistakes on a project, you are done. Take a break. It will wait until you are rested.

Posted in Home Maintenance | Leave a comment

High Availability with SQL Server and Double-Take – the links

In 2008, Steve Warren with TechRepublic created a 3-part blog post with details of how to configure Double-Take software to protect SQL Server. The 3 parts are not mutually linked to each other. Here are links to all three parts: Part … Continue reading

Posted in Programming, SQL Server, System/DB Administration | 1 Comment

T-SQL to Determine size of transaction log file

–http://blog.sqlauthority.com/2010/02/08/sql-server-find-the-size-of-database-file-find-the-size-of-log-file/ –SQL SERVER – Find the Size of Database File – Find the Size of Log File –Reference: Pinal Dave (http://blog.SQLAuthority.com) SELECT DB_NAME(database_id) AS DatabaseName, Name AS Logical_Name, Physical_Name, (size*8)/1024 SizeMB FROM sys.master_files WHERE DB_NAME(database_id) = ‘db_mes’ GO

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

Typo of the day

Refactoring a local variable to a stored procedure parameter resulted in this sillyname. From: DECLARE @operator To: @pOoperator Good policy: Never upset the pooperator!

Posted in Programming, Quote of the Day | Leave a comment

PDF customization links

Thanks to Google, here are some interesting links on PDF customization: http://www.w3.org/WAI/RD/2012/text-customization/t6 http://www.oxygenxml.com/doc/ug-editor/topics/dita_pdf_output_customization.html http://dita-ot.sourceforge.net/1.7/readme/dita2pdf-customization.html

Posted in Programming | Leave a comment