Changes (as compared to Monyog MySQL Monitor 5.68) include: Bug fixes: * LDAP search for user in group authentication could fail with Active...
Month: February 2014
Tag Your Objects with Additional Information
There may be the need to add additional information to command results. Maybe you get data from different machines and want to keep a reference...
Save Time With Select-Object -First!
Select-Object has a parameter called -First that accepts a number. It will then return only the first x elements. Sounds simple, and it is. This...
Expanding Variables in Strings
To insert a variable into a string, you probably know that you can use double quotes like this: $domain = $env:USERDOMAIN $username = $env:USERNAME...
Using Aliases to Launch Windows Components
PowerShell is not just an automation language but also an alternate user interface. If you do not like the graphical interface, educate PowerShell...
Filtering Text-Based Command Output
Comparison operators act like filters when applied to arrays. So any console command that outputs multiple text lines can be used with comparison...
Keeping a Handle to a Process
When you launch an EXE file, PowerShell will happily start it, then continue and not care about it anymore: If you'd like to keep a handle to...
Use $PSScriptRoot to Load Resources
Beginning in PowerShell 3.0, there is a new automatic variable available called $PSScriptRoot. This variable previously was only available within...
Lazy Form Creation Design Pattern
One of the most important things about any application, and especially mobile apps, is short start-up time. End user does not like to wait for too...
Monyog MySQL Monitor 5.68 Has Been Released
Changes (as compared to Monyog MySQL Monitor 5.67) include Features: * Sniffer now shows database name in long running query notification and also...
Signing VBScript Files with PowerShell
You probably know that Set-AuthenticodeSignature can be used to digitally sign PowerShell scripts. But did you know that this cmdlet can sign...
Deep Dive: SQL Diagnostic Manager Availability Checks
One of the frequent questions I get about SQL Diagnostic Manager pertains to one of the most fundamental features of the product – exactly how is...
Correctly Filtering DateTime
When you use Where-Object to filter information by date or time, this works actually very well--provided you use the correct filtering format. Do...
Use Fresh Testing Environment in PowerShell ISE
When you develop PowerShell scripts in the PowerShell ISE editor, you should run the final tests in a clean environment, making sure that no...
Some suggestions
Hi, I think it may be useful in SQL Defrag: 1. To see index script when I see the fragmentation of this index. Now I need to use another tool to do...
Creating an InterBase database on the fly with FireDAC
Recently I have been creating a number of applications using InterBase on iOS and Android using FireDAC components to talk to the database. One...
Importing Multiple Certificates from PFX Files
Get-PfxCertificate can import digital certificates from a PFX file. However, it can only retrieve one certificate. So if your PFX file contains more...
Using Fully Qualified Names in Remoting
When you try PowerShell Remoting, you may run into connection errors just because your machine name was not fully qualified. Kerberos authentication...
Is Your SQL Server Slow? Maybe It’s Trying Too Hard
The following is a guest post by Microsoft Certified Master Robert L Davis. Find more from him at SQLSoldier.com, and follow him on twitter...
Ensuring Backward Compatibility
Let's assume you have created this function: function Test-Function { param ( [Parameter(Mandatory=$true)] $ServerPath ) "You selected...
Importing Certificates from PFX Files
You can use Get-PfxCertificate to load digital certificates from PFX files, and then use the certificate to sign script files, for example: $pfxpath...
Monyog MySQL Monitor 5.67 Has Been Released
Changes (as compared to Monyog MySQL Monitor 5.66) include: Bug fixes: * Fixed a rare crash occurring in CSO's (Custom SQL Objects). * Fixed a...
Reading StringExpand Registry Values
When you read a Registry value of type StringExpand, it will always automatically expand any environment variables contained in the text. This...
Setting (And Deleting) Environment Variables
PowerShell can read environment variables easily. This returns the current windows folder: $env:windir However, if you want to make permanent...