Author Archives: pfb_admin

Windows 10 wireless displays

https://www.hanselman.com/blog/UseASecondLaptopAsAnExtendedMonitorWithWindows10WirelessDisplays.aspx Cool!

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

String.Format codes for DateTime etc

HH:mm:ss.fff HH = 24-hour clock. hh=12-hour = tt=am/pm MM/dd/yyyy yyyy = 4-digit year. https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

Posted in Uncategorized | Leave a comment

Clone programming steps

— list products that might need to be programmed. SELECT name,revision, product_id FROM qs_products where name like ‘277000-200-%’ — list current programming steps select p.name,p.revision,steps.* from [dbo].[ACA_swprg_programming_steps] steps INNER JOIN qs_products p ON p.product_id = steps.mes_product_id — after updating the … Continue reading

Posted in SQL Server | Leave a comment

Populate NULL component_ids from related tables

Needed to populate a new column in one table from a semi-related existing table, based on a value in another related table. I do this once in a blue moon and needed a refresher. Thanks, Pinal Dave, for your post … Continue reading

Posted in SQL Server | Leave a comment

List of line endings

programmingScriptText += “\r\n”; //Windows style CRLF line ending. //programmingScriptText += “\n\r”; // Nobody does this. //programmingScriptText += “\r”; // Max style (CR) line ending. //programmingScriptText += “\n”; //UNIX style (LF) line ending.

Posted in C#, Programming | Leave a comment

C# Make a SplitContainer dragbar visible to users

/// /// Given a SplitContainer, /// set the color of its background to make the splitter dragbar visible to users. /// Set the color of the splitter’s panels to the original color of the splitter, /// to keep their backcolors … Continue reading

Posted in C#, Programming | Leave a comment

Returning errors codes in .Net apps

https://msdn.microsoft.com/en-us/library/system.environment.exitcode(v=vs.110).aspx https://msdn.microsoft.com/library/ms681381(v=vs.85)

Posted in Uncategorized | Leave a comment

ClickOnce, Crystal Reports, and dependent projects

Problem causing failure to install ClickOnce project after adding a reference to another project: ERROR DETAILSERROR DETAILS Following errors were detected during this operation. * [7/17/2017 12:01:25 PM] System.Deployment.Application.InvalidDeploymentException (RefDefValidation) – Reference in the manifest does not match the identity … Continue reading

Posted in C#, Linkdump, Programming, System/DB Administration | Leave a comment

Linkdump: Dynatrace- app monitoring with AI

https://info.dynatrace.com/apm_wc_ai_webinar_na_registration.html  

Posted in Business Intelligence, Linkdump | Leave a comment

Google handoff to Site Reliability Engineering (SRE)

Part 1:¬†https://cloudplatform.googleblog.com/2017/06/why-should-your-app-get-SRE-support-CRE-life-lessons.html Part 2: https://cloudplatform.googleblog.com/2017/06/how-SREs-find-the-landmines-in-a-service-CRE-life-lessons.html Part 3:¬†https://cloudplatform.googleblog.com/2017/07/making-the-most-of-an-SRE-service-takeover-CRE-life-lessons.html  

Posted in Uncategorized | Leave a comment