gurnig.blog – when you hear hoof beats, think horses not zebras. [Dr. Theodore Woodward]
As one begins to write more sophisticated AWS Lambda functions, it quickly becomes clear that using shell scripts and the CLI to package, deploy and test will speed up development time. I often start in the AWS Console; then as the code becomes more complex, move to a local editor. Packaging at the Command Line [...]
Note: this is a conceptual, "how does the SWF design pattern work" article, rather than a "how-to". In fact, implementation does not need to be Amazon specific, although SWF supports the pattern. A Naive, Simple Code Example We may write fairly complex algorithms to fulfill the needs of a complex process. One could write a single function [...]
Given a fileserver change, I needed a way to get all the server names for Receive Locations in the BizTalkMgmtDb. The InboundTransportURL would be in the form of \\servername\somepath. This query assumes a valid charindex value -- often a dangerous assumption. This did the trick nicely! select [id], [name], [ActiveStartDT], [InboundTransportURL], replace(left([InboundTransportURL], charindex('\', [InboundTransportURL], 3)), '\', [...]
g-blog 