Edward Manning

Relentless Improvement: The Pursuit of Mastery

UI with Powershell Calls

(From internal blog - 5 January 2012) All Microsoft applications are now written so the admin functionality is executed via powershell. The UI simply calls these powershell scripts. Advantage is that full functionality of the applications can be scripted instead. Used to be the case that the scripting was bolted on afterwards. This meant that the scripting could not always perform the same tasks as the UI could.

PL/SQL - How to Remove Trailing Zeros but Keep Leading Zero

WITH T AS ( SELECT 100 AS EXAMPLE FROM DUAL UNION SELECT 98.336 AS EXAMPLE FROM DUAL UNION SELECT 25 AS EXAMPLE FROM DUAL ) SELECT EXAMPLE / 100 AS EXAMPLE_1, TO_CHAR(EXAMPLE / 100) AS EXAMPLE_2, RTRIM(TO_CHAR(EXAMPLE / 100, 'FM0.999999999999'), '.') AS EXAMPLE_3 FROM T; Thanks to Oracle Community

Standalone Flash Player (Flash Projector)

It took me a while to find this. Only because I didn’t read the actual page! There’s 3 highly visible links leading you away from the standalone player which is below. Adobe call their standalone player a “projector”. Update: It would help if I posted a link wouldn’t it :) http://www.adobe.com/support/flashplayer/downloads.html If you can’t find it either, take a look at the picture below.

Flash without DLM

Want to download and install flash without the download manager? I know I do. Why force installation of a download manager for files that are only a few megabytes? It’s an overhead that simply isn’t required. I don’t need any more rubbish installed on my computer and neither do you. The links below will take you to the official install files. Download to your local machine and install directly. Flash

Quotes To Make You Think

“Far better it is to dare mighty things, to win glorious triumphs, even though checkered by failure, than to take rank with those poor souls who neither enjoy much nor suffer much, because they live in the gray twilight that knows neither victory nor defeat.” – Theodore Roosevelt “It is not the critic who counts, not the man who points out how the strong man stumbled, or where the doer of deeds could have done them better.

Java - The updater that won't die...

Well, I’ve been having problems with Java the last couple of weeks. No, I don’t want to install every point release. When I say “Do not update”, I really mean it. Seems Java’s hard of hearing. Despite unchecking the “Check for Updates Automatically” check box, it was still checking for updates and trying to install them. Turns out that Java’s Control Panel will only accept changes made by Administrators, so any changes you make will be quietly ignored.

Accessing SQL Server 2005 on Vista

Windows Admins are not automatically SQL Server 2005 Admins. There’s a provisioning tool that runs at the end of the service pack setup that fixes this. If you skip past it or SQL Server isn’t running then you need to run the tool separately. You can do this by running the “SQL Server Surface Area Configuration” tool and clicking “Add New Administrator”.

Batch File Comments

Recently I needed to add a comment in a batch file and I couldn’t remember how to do it. Google proved somewhat elusive in providing adequate results and so the search took longer than it should have done. For posterity, you can add a comment to a windows batch file by adding “REM” to the start of the line. REM This is a comment REM This is also a comment I was using the batch file to automate the encryption of the system.identity element for multiple sites on a web server.