yzorgsoft

polygon in SQL Server 2008: compute the angle of the first side of the polygon

2012-01-12T17:39:00.000-08:00

I wanted the angle of the first side of a polygon in SQL Server 2008+. Our code for entering the shapes evolved over time, specifically which direction drew the shapes.

For example: starting with the NW point drawing clockwise (the anglican way) or drawing counter-clockwise (the way SQL draws Geography).

I have to convert to geography on the fly because the geometry in the DB is combined with other shapes, hence the 2-level CTE.

WITH PolygonGeo (Id, Polygon)
AS (
SELECT
[MyIDColumn] AS [id]
,geometry::STGeomFromText(GeometryText, 4326) as [Polygon]
FROM [MyDatabase].[dbo].[MyTable]
WHERE GeometryText LIKE 'POLYGON%'
),
Points ([Id], Pt0, Pt1)
AS (
SELECT Id
, [Polygon].STPointN(1) AS Pt0
, [Polygon].STPointN(2) AS Pt1
FROM PolygonGeo
)
SELECT [Id]
, ATN2(Pt1.STX - Pt0.STX, Pt1.STY - Pt0.STY) / PI() * 180 AS Angle
FROM Points

Results:

Id_8	Angle
33BAA7F	180
167AAEA	176.395579460831
F6469B3	180
33BAA7F	180
167AAEA	177.137594773874
0D34759	154.490530508003
33BAA7F	165.499833233449
CB398C0	180
CB398C0	143.383248480932
F6469B3	179.283840054506
33BAA7F	-175.114797431858

DOS tricks by yzorg, part 2

2011-12-13T05:29:00.000-08:00

This is my second attempt at writing up my DOS tricks. I changed jobs, just like the original post said, but found the original tricks were woefully inadequate in real world use. Consider this as my first attempt at 'pro' tricks.I'll start with the basics from the command-line.

C:\Users\YzOrg>echo %date:~10,4% %date:~4,2%
2010 11

C:\Users\YzOrg>echo hi > %date:~10,4%%date:~4,2%.txt

C:\Users\YzOrg>dir *.txt
Volume in drive C has no label.
Volume Serial Number is B8EE-D08D

Directory of C:\Users\YzOrg

11/24/2010 09:32 AM                 5 201011.txt
10/01/2010 10:40 AM               210 SDK.txt
               2 File(s)            215 bytes
               0 Dir(s) 199,100,514,304 bytes free

C:\Users\YzOrg>set line=0123456789 ABCD 0123456789 ABCD0123456789 ABCD0123456789 ABCD0123456789

C:\Users\YzOrg>echo %line:~10,8%
ABCD 01

C:\Users\YzOrg>echo hi > demo%date:~10,4%%date:~4,2%%date:~7,2%.log & dir demo*.log
Volume in drive C has no label.
Volume Serial Number is B8EE-D08D

Directory of C:\Users\YzOrg

11/24/2010 09:50 AM                 6 demo20101124.log
               1 File(s)              6 bytes
               0 Dir(s) 199,100,379,136 bytes free

C:\Users\YzOrg>set /?
Displays, sets, or removes cmd.exe environment variables.

SET [variable=[string]]
...<SNIP>

Pitfalls with using %DATE% and %TIME% in filenames

Time and date from OS can have spaces. So put the log filename in its own variable and use

    SET MYVAR=%MYVAR: =0%

to replace any spaces from %DATE% and %TIME% to 0.

I recommend you follow this guidance, put StdErr redirection at the end of the line.

Here is the final snippet for use in scripts:

Code

set LOG_TIMESTAMP=%date:~10,4%%date:~4,2%%date:~7,2%-%time:~0,2%%time:~3,2%.JobName.log
set LOG_TIMESTAMP=%LOG_TIMESTAMP: =0%
echo starting at %date% %time% with log %CD%\log\%LOG_TIMESTAMP%

Output

starting at Tue 02/13/2011  8:26:57.99 with log C:\Users\YzOrg\log\20110213-0826.JobName.log

Other CMD Tricks

Use %~dp0 to get the full path of the current batch file. %0 is the scriptname argument, '~dp' are modifiers to get the drive and path of that argument, %~dp0.

Rule: always turn off 'echo' in batch files using this first line:

@if not defined _echo echo off

Use 'set _echo=1' before calling the script to debug it (it will echo every command)References: set /?, call /?, for /?, setlocal /?

don't need to install .NET 3.5 for Metro UI Tweaker

2011-09-24T00:18:00.000-07:00

The post I wrote for GreenShot used a configuration file to tell the app to use the CLR and .NET FX that is already installed on Windows 8. The same hack works for the Metro UI Tweaker tool from The Windows Club (which I found via winsupersite.com).

So grab the configuration file I used for GreenShot but this time name it "Metro UI Tweaker.exe.config".

Greenshot on Windows 8 (.NET 4.5)

2011-09-16T18:56:00.000-07:00

How to run Greenshot on .NET 4.5 (Windows 8). Greenshot is an OSS alternative for SnagIt (screenshot tool).
Don't install the Greenshot installer. It will refuse to install without .NET 2.0, even though it seems to run fine on .NET 4.5.

1) download the zip file and extract it to C:\Program Files\Greenshot.
Note: On Win8 you'll need to be running a process with Admin privileges to create the directory and extract the files.
2) create Greenshot.exe.config to tell .NET to run Greenshot on .NET 4 with a couple of compatibility options. https://gist.github.com/1223509

A look at ReactiveUI

2011-09-10T14:40:00.000-07:00

I'm thinking about how to take some of the middle-tier parallel concepts like #RxNet and apply them in a little OSS GUI app I've been thinking about. I quickly found this gem, ReactiveUI PDF . A couple of quotes that stoked my interest:

"What’s in this library

ReactiveCommand - an implementation of ICommand that is also a Subject whose OnNext is raised when Execute is executed. Its CanExecute can also be deﬁned by an IObservable which means the UI will instantly update instead of implementations which rely on RequerySuggested."

...

"Some philosophy

A lot of examples of the Reactive Extensions make its domain appear really constrained, like the only thing it’s ever useful for is either handing web service requests and implementing drag-and-drop. However, here’s the key thing to realize - a property change notiﬁcation is an event.Once you realize that Reactive Programming applies to any time an object changes state, Rx suddenly becomes far more applicable to any programming domain - really, Rx is a library to model state machines that are context-free with respect to threading."

And, I can use all the high-level composition that I've been using in the middle tier. Like Merge() to join streams of events, and Throttle() to do in one line that takes a half-page of code with other frameworks. This looks promising. One glitch. The author of the library recently moved from Microsoft (Office team) to GitHub. Uh-Oh. But too promising to ignore it. At least I hope he still works in C#, maybe he can help with the Windows OSS clients, like Git Extensions, which is written in C# (but not hosted on github).

nRoute is another MVVM framework that leans on Rx for event streams. It's author is French. Hmm.

It's good to have choices, unlike 18 months ago.

Middle-Tier: TPL and/or RxNet

2011-09-09T20:39:00.000-07:00

I was thinking about how to rewrite an old (2009) WCF middle-tier service, and have been thinking about George Tsiokos's recent TPL vs. RxNet post.
I think a middle-tier service is perfect to illustrate how I see the strengths and weaknesses of these two. Specifically the scenario:

Complex Middle-Tier: Startup vs. Message Handling

TPL might be great for startup tasks. There is one 'global' task, Initialize, that has many sequences and chunks (in TPL these could be child tasks) that can have different degrees of parallelization. It also requires global 'command and control' and 'top-down' composition and error handling (a type of event correlation). If any critical part of startup fails then tear-down the service (cancel outstanding parallel tasks) and exit the service quickly. So global handling and command-control programming style (root of the call hierarchy has all control).

Once everything is initialized you want bottom-up event correlation and error handling. The function at the top of the callstack has no control (usually a WCF operation or I/O completion callback). You only want global state to be touched when absolutely necessary, not touched by ignorable infrastructure errors, and not by errors that are ignorable according to business rules.

Startup, large complex top-down composable work:
TPL

Streams, composable business logic (streams that include error/end):
RxNet

With .NET 5 the TPL dataflow libraries might change things again, but for now I much prefer RxNet for composing and routing 'messages' between layers. We recently used it in a project and when you have to correctly handle error scenarios it shines. Imagine a WCF callback for a business operation that is completely async, where business logic has to fire if the notification fails (delivery of the data to the client). The code isn't pretty in either case, but is better and can be handled at the right level of the lego blocks with RxNet.

mandatory DOS trick - %date:~10,4%%date:~4,2%%date:~7,2%

2011-02-08T18:24:00.001-08:00

I’ve written this trick every new job or position I miss out on the old standby, using batch script to capture command-line output to a dated log file. This post is so I’ll never have to reproduce it again.

C:\Users\YzOrg>echo %date:~10,4% %date:~4,2%
2010 11

C:\Users\YzOrg>echo hi > %date:~10,4%%date:~4,2%.txt

C:\Users\YzOrg>dir *.txt
Volume in drive C has no label.
Volume Serial Number is B8EE-D08D

Directory of C:\Users\YzOrg

11/24/2010 09:32 AM                 5 201011.txt
10/01/2010 10:40 AM               210 SDK.txt
               2 File(s)            215 bytes
               0 Dir(s) 199,100,514,304 bytes free

C:\Users\YzOrg>set line=0123456789 ABCD 0123456789 ABCD0123456789 ABCD0123456789 ABCD0123456789

C:\Users\YzOrg>echo %line:~10,8%
ABCD 01

C:\Users\YzOrg>echo hi > demo%date:~10,4%%date:~4,2%%date:~7,2%.log & dir demo*.log
Volume in drive C has no label.
Volume Serial Number is B8EE-D08D

Directory of C:\Users\YzOrg

11/24/2010 09:50 AM                 6 demo20101124.log
               1 File(s)              6 bytes
               0 Dir(s) 199,100,379,136 bytes free

C:\Users\YzOrg>set /?
Displays, sets, or removes cmd.exe environment variables.

SET [variable=[string]]
...<SNIP>

Use %~dp0 to get the full path of the current batch file. %0 is the scriptname argument, '~dp' are modifiers to get the drive and path of that argument, %~dp0.

Interesting FOR commands in cmd.exe :
FOR /F ["options"] %variable IN (file-set) DO command [command-parameters]
FOR /F ["options"] %variable IN ("string") DO command [command-parameters]
FOR /F ["options"] %variable IN ('command') DO command [command-parameters]

Rule: always turn off 'echo' in batch files using this first line:
@if not defined _echo echo off
Use 'set _echo=1' before calling the script to debug it (it will echo every command)

References: set /?, call /?, for /?, setlocal /?

Round-Up

2011-02-01T20:35:00.000-08:00

iPod

I recently bought a 4th gen iPod and man do I love it. Don't have to pay a data plan, and with a few bucks for good software can really make use of the GB of
flash storage and the fat bandwidth over WiFi. Exactly what my old Windows Mobile 6.X phone sucked at. Great battery, great podcast playback (2x play, remembers where I left off, etc.).
The only thing I was missing was Podcast subscription (on device, no iTunes on Windows please) and automatic WiFi sync for podcasts. There's an app ...

iOS Apps

DownCast: $0.99 app to sync podcasts over WiFi. My Features: Multitasking (background play), subscribe to podcasts, sync to iPod via WiFi, 2x speed, good jump buttons (back 30, back 15, forward 30, forward 2:00). Bonus features: can sort a playlist by podcast name instead of date, so can see the three 'good'
weekly podcasts first (instead of listening to the daily podcasts first, which tend to be filler. I also found out too late that it can import an OPML from a URL (I was adding them one at a time, good time saver.)

Microsoft OneNote: free. My Features: (sync to Live/SkyDrive/OfficeLive, whatever they're calling it today). Love that it syncs my notes to all my devices + web.
So I can start gathering notes and thoughts for a blog post on the laptop, research it on the desktop, and pull it up on my pocket device (iPod in my case) to solicit feedback from a co-worker.
Leave it to Apple to help make OneNote useful enough to finally start using it instead of email.

StackOverflow + Google

The work Google is doing to reduce spammers and content farms seems to be working - SO rank has recently improved dramatically in my recent programming searches.

http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=threadsafe+INotifyPropertyChanged
http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=Property+name+from+lambda

For similar technology searches a few weeks ago I was getting spam/content farms of stackoverflow.com duplicated content for most of the results, with SO 3rd or 4th (obviously the content farms were gaming the SEO ranking). Not scientific by any stretch, but getting better.

linkfest 2011.Feb.01

2011-02-01T20:27:00.000-08:00

JSON / Diagnostics

Pretty Print JSON via JayRock
New JSON library for .NET, JayRock

WPF and INotifyPropertyChanged

http://code.google.com/p/notifypropertyweaver/
http://stackoverflow.com/questions/671968/retrieving-property-name-from-lambda-expression
http://msdn.microsoft.com/en-us/library/ms229614.aspx
http://caliburn.codeplex.com/wikipage?title=Asynchronous%20Actions
http://stackoverflow.com/questions/834632/bind-any-xml-document-to-wpf-treeview

IoC / Autofac

Nicholas Blumhardt: AutoFac and object Lifetime (summary: mind your 'unit of work' pattern)

robocopy /MT for Windows XP: RichCopy

2011-01-19T19:48:00.000-08:00

Microsoft's devs and testers write great little specialized utilities but far too often they never see the light of day. They write it for their team, and sometimes have time to post it internally, but all too often they're too busy to publish it outside the company.

This is one of those gems, and fortunately it is public.

My Scenario

I had a NY to FL file copy operation that was taking about 10 minutes with xcopy and pre-Win7 robocopy. The files weren't that big, but lots of small files, and one-at-a-time file copy performed horribly. Win7 introduced the /MT argument to allow 'multiple threads' to copy file simultaneously, which is exactly what I needed. But I'm not using Win7 (yet). Even better, the Win7 robocopy.exe won't run on older versions of Windows (both properly licensed). Nice. RichCopy to the rescue.

RichCopy is a graphical application for Windows and will run on Windows XP and Windows Server 2003. It also has (cryptic) command-line options for all of the various copy options like filter by name, filter by date, and copy file attribute. RichCopy really shines when copying huge files, but if you seriously raise the threading you can also get a boost when copying lots of small files (like source code files or in this case PowerShell scripts).

I've used robocopy a lot over the years, so while its options are cryptic I found RichCopy's options even worse. To save myself time I wanted to document the options I'm using.

RichCopy.exe source destination /TD 64 /TS 32 /SC 64 /FEF *.7z

Get it here. http://blogs.technet.com/ken/

Gotchas / Caveats

I was looking for a command-line tool, and this is a windows application. You can wait on the windows application (which does exit properly when given correct command-line options) using PowerShell's 'Start-Process -Wait RichCopy.exe' or in cmd.exe 'start /wait "" RichCopy.exe'.
I wasn't getting any command-line output when passing bad command-line arguments, and while it has logging options I didn't get them to work after a couple of tries.
RichCopy comes with a chm (compiled help) which explains all the options. But I get the feeling the author's first spoken language isn't English because the wording is clumsy. (Not that my blog writing is any good, ahem.)

Sample PowerShell

I was using RichCopy to copy my PowerShell profile to my DEV servers. It includes code to call robocopy (if found via Get-Command) and if not found fall back to RichCopy (XP / Server 2003 only). If planning to compare the tools a good addition would be to make this a script parameter instead. The code is available at PoshCode: PoshCode 2468

StreamBase annoyance for today

2011-01-17T20:26:00.000-08:00

After 9 months of use, SB Studio left 670MB of temporary files. Thanks StreamBase! In all fairness this might have something to do with SB Studio being built in/with Eclipse. They all start with .sb, which makes me feel better about casting blame.

Friendly poking aside, SB is critical to my current role. It's been a fun ride learning event-based programming, time-window aggregates, and getting back into Java. Eclipse perspectives need to be brought to Visual Studio.

Also an old but good article which makes the case for CEP.

x-platform, huge performance from LMAX, Azul

2011-01-14T23:17:00.001-08:00

I'm a cross-platform developer in the financial services sector. If any .NET or Java developer interested in reaching a 'new level' of performance on commodity hardware should watch this video about LMAX, hosted on InfoQ. Great refresher on HW, good example of pulling back a couple of layers of abstraction to find the worst and best in modern parallel processing. They achieve high throughput with low latency.

LMAX and TradeFair (think of BetFair)
http://www.infoq.com/presentations/LMAX

Interested in pause-less GC on Java? Not afraid of running custom everything? (Custom HW, Custom OS, leveraging power of HW virtualization to maximize JVM.) Take a look.

Azul and Zing
http://www.infoq.com/interviews/gil-tene-azul-zing

TopShelf and NuGet

2011-01-14T23:12:00.000-08:00

I've been playing with TopShelf service host. Its goal is to remove the repetitive code from Windows Services written in .NET. My production servers aren't Win 2008, so App Fabric service hosting isn't an option.

TopShelf 2.1 is still a bit of a moving target. I thought to myself: Self, if you want to update your 3-4 services that use this OSS library, and want to do it really easily, you'll create yourself a NuGet package for TopShelf.

For those who haven't heard, NuGet packages are to .NET what gems are to Ruby. The package is a zip with DLL and small bit of metadata. The package goes on a share*, add a line to Visual Studio, and now VS can find and add the package to your service host projects.

* - You could also drop some service code into IIS to host an internal gallery, but I only need a file share.

Here is the nuspec file (package description) and PowerShell script (prepare the folder and create the package).

TopShelfYZ.nuspec

<?xml version="1.0" encoding="utf-8"?>
<package xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <metadata xmlns="http://schemas.microsoft.com/packaging/2010/07/nuspec.xsd">
    <id>TopShelfCT</id>
    <version>2.1.1</version>
    <authors>Chris Patterson (phatboyg), Travis Smith (legomaster)</authors>
    <owners>Chris Patterson (phatboyg), Travis Smith (legomaster), Chris Tracy (yzorgsoft)</owners>
    <licenseUrl> https://github.com/Topshelf/Topshelf/blob/master/LICENSE </licenseUrl>
    <requireLicenseAcceptance>false</requireLicenseAcceptance>
    <description>A Windows Service hosting library for .NET, for those unfortunate enough to no be able to use AppFabric to host .NET services. Package created by Chris Tracy (yzorgsoft) until real owners can publish the package on NuGet gallery.</description>
    <language>en-US</language>
    <projectUrl> http://topshelf-project.com/ </projectUrl>
    <dependencies>
      <dependency id="log4net" version="1.2.10" />
    </dependencies>
  </metadata>
</package>

CreateTopshelfPackage.ps1

Write-Host "START [$($MyInvocation.MyCommand.Name)] $(get-date -f yyyyMMdd.HHmmss)"

try {

$packDir = 'pkg\lib\3.0'

rd -Recurse $packDir -Force

md $packDir -Verbose -EA SilentlyContinue

copy .\Topshelf.dll,.\Topshelf.pdb $packDir -Verbose -Force

nuget.exe pack .\TopShelfYZ.nuspec -b pkg

# should output:

# Successfully created package '...\TopShelfYZ.2.1.1.nupkg'.

}

catch { throw; }

Write-Host "END [$($MyInvocation.MyCommand.Name)] $(get-date -f yyyyMMdd.HHmmss)"

Gotchas

If you're like me then when creating your first package you might expect NuGet.exe (package creation utility) to be downloaded with the NuGet VisualStudio extension. This is not the case. You have to get it from the CodePlex project (under "Other Available Downloads").

When creating your package you must start with a 'lib' folder. I thought the lib folder in the examples was like 'foo' and 'bar' (a placeholder for real name), but no, it must be 'lib' to act like one would expect a .NET assembly package to work (to contain .NET DLLs). And it won't warn you if you don't have a lib folder, or even notify you in any way, it just creates a package that isn't what you were probably expecting.

Nit-Pick Corner

I like all my command-line tools on Windows to show help when I give them /?. It has been thus since my early days before DOS 5.0. But NuGet.exe doesn't, it shows an error if you give it /? but does show "good help" when not given any arguments. Is it just me or is this bad form?

Summary: tools help gather the right Lego pieces

The ruby community has been running circles around .NET the last few years. That time is passing and I expect .NET to make up lots of ground with NuGet and the growing .NET OSS community. NuGet is a great tool that has been sorely needed.

One more time for the SEO crowd: NuGet rocks!

OData back-end code example

2011-01-14T22:07:00.000-08:00

I've been playing with NuGet recently. @GTsiokos pointed out the package service seems to be the same code that hosts the Orchard CMS gallery at http://orchardproject.net/gallery .

The Gallery Service project has good example of code _to read_ for anyone building a production OData service (a.k.a. Astoria, WCF Data Services). Also looks like a good example for the 'shape' of a public OData service. Some very useful service conventions, like ServiceBase.ExecuteAction that wraps .NET exceptions in ServiceFault, so not even try/catch code is duplicated across service operations (methods).

I've spent a fair amount of time with WCF and back-end service code this year, and it's cathartic to see a small, lightweight example of .NET service code that is well-factored with (AFAICT) no duplicate code in the codebase.

http://galleryserver.codeplex.com/SourceControl/changeset/view/571cbbf82836#GalleryServer%2fsrc%2fGallery.Server%2fPackageService.cs

Enable and Disable monitor displays with Sikuli

2011-01-10T07:53:00.000-08:00

For a while I've been trying to find a way to switch from a many-monitor setup to a single monitor setup. Why? I'm using GoToMyPC with it's desktop composition when remoting into my developer workstation from my laptop, and sometimes I don't want all those desktops composed together.

I couldn't find anything with WMI or PowerShell to automate switching between these two configurations.

SuperUser question

I found a solution - GUI automation of the "Display Settings" control panel dialog via Sikuli.

I'm attaching a zip with Enable, Disable (simpler scripts) and optimized versions of both that run a bit faster. These are GUI automation and driven by screenshot, so they won't work for anyone else "out of the box" but should be a good starting point for others trying to accomplish a similar task.

SikuliMonitors.zip

blog 'Hello World' from yzorgsoft

2010-11-24T21:34:00.000-08:00

I created the name 'yzorg' during a time when I was looking for a smarter organization. I was looking for an IT management team that invested in the right tools, one that understood the power and limitations of technology, and one that understood technical debt (the slowly increasing dead weight that is inherent with very old IT systems, or broken IT systems of any age).

yz = 'Wise' and 'Org' = Oranization.

YzOrg = Wise Organization.

Now I try to build software and create teams to make whatever organization I'm in smarter. YzOrgSoft = smart software, smart IT.

I don't work in corporate IT anymore. I'm currently working for a financial services company whose offerings include technology solutions.

2010-11-24T20:28:00.001-08:00

I just did a little demo for [a coworker] today of DOS tricks I learned while at MS. I thought I'd send out the log as a sample (with mistakes removed, <smile>). I usually become the goto dev when someone needs a quick-n-dirty batch script, or need to know "Can DOS do X?".

C:\Users\TracyC>echo %date:~10,4% %date:~4,2%
2010 11

C:\Users\TracyC>echo hi >  %date:~10,4%%date:~4,2%.txt

C:\Users\TracyC>dir *.txt
Volume in drive C has no label.
Volume Serial Number is B8EE-D08D

Directory of C:\Users\TracyC

11/24/2010  09:32 AM                 5 201011.txt
10/01/2010  10:40 AM               210 SDK.txt
               2 File(s)            215 bytes
               0 Dir(s)  199,100,514,304 bytes free

C:\Users\TracyC>set line=0123456789 ABCD 0123456789 ABCD0123456789 ABCD0123456789 ABCD0123456789

C:\Users\TracyC>echo %line:~10,8%
ABCD 01

C:\Users\TracyC>echo hi > demo%date:~10,4%%date:~4,2%%date:~7,2%.log & dir demo*.log
Volume in drive C has no label.
Volume Serial Number is B8EE-D08D

Directory of C:\Users\TracyC

11/24/2010  09:50 AM                 6 demo20101124.log
               1 File(s)              6 bytes
               0 Dir(s)  199,100,379,136 bytes free

C:\Users\TracyC>set /?
Displays, sets, or removes cmd.exe environment variables.

SET [variable=[string]]
...<SNIP>

.BAT/.CMD

Use %~dp0 to get the full path of the current batch file. %0 is the scriptname argument, '~dp' are modifiers to get the drive and path of that argument, %~dp0.

Interesting FOR commands in cmd.exe :
FOR /F ["options"] %variable IN (file-set) DO command [command-parameters]
FOR /F ["options"] %variable IN ("string") DO command [command-parameters]
FOR /F ["options"] %variable IN ('command') DO command [command-parameters]

Rule: always turn off 'echo' in batch files using this first line:
@if not defined _echo echo off
Use 'set _echo=1' before calling the script to debug it (it will echo every command)

References: set /?, call /?, for /?, setlocal /?