Recent MySQL versions (first the chaotic series of releases that preceeded 5.5 - 5.2, 6.0 and 5.4 - and now 5.6) adds new 'character sets'...
database-tools
Sophisticated Directory Filtering in PowerShell v3
In PowerShell v3, Get-ChildItem now supports sophisticated filtering through its –Attribute parameter. To get all files in your Windows folder...
Restarting Computers in PowerShell
In PowerShell v3, Restart-Computer now has a number of useful new parameters. For example, you can restart a remote machine and wait for the reboot...
Colorizing PowerShell ISE v3
The new PowerShell ISE script editor in PowerShell v3 lets you customize a lot of colors, so if a particular color does not show well on a...
Out-GridView Grows Up
In PowerShell v2, Out-GridView was a useful way of displaying information in a separate window but its functionality was limited because you could...
Get-Content Can Now Read Raw Text
In PowerShell v3, Get-Content was reading text files line by line. This was great for pipeline processing but could take a long time and also...
Disabling Console Apps in PowerShell ISE
In PowerShell v3, the new PowerShell ISE script editor has improved a lot. Yet, it still has no real console but instead sports a useful console...
Controlling IntelliSense in PowerShell ISE v3
The new PowerShell ISE script editor that ships with PowerShell v3 has a much improved IntelliSense (code completion) that you can even fine-tune...
Removing Code Snippets in PowerShell ISE v3
In a previous tip we showed you how to add your own little code snippets to the new PowerShell ISE v3 script editor. Here's how you can get rid...
Testing URLs for Proxy Bypass
If you'd like to find out whether a given URL goes through a proxy or is accessed directly, you can use this neat little trick: Function...
Using ActiveDirectory Module without AD Drive
By default, when you import Microsoft’s ActiveDirectory PowerShell module which ships with Server 2008 R2 and is a part of the free RSAT...
New PowerShell ISE v3 Console Keyboard Tricks
If you already use the new PowerShell ISE v3 script editor, you noticed that the editor now has an almost real console with input and output going...
Using Code Snippets in PowerShell ISE v3
PowerShell ISE v3 script editor supports code snippets. Press CTRL+J to open a list of built-in snippets. You can add your own snippets, too. For...
Reading Twitter (And Detecting Speed Traps)
With just a couple lines of code, PowerShell can search for Twitter news. If you happen to live in Germany, then this would tell you the latest...
Downloading PowerShell v3 Help
Beginning with PowerShell v3, help is no longer shipped by default. Instead, in order to get help you need to download the help information from the...
More Useful Keyboard Tricks for PowerShell ISE v3
Here are some more useful keyboard strokes that work in the new PowerShell ISE script editor that comes with PowerShell v3. These keyboard shortcuts...
Getting Relative Dates
Here's a quick and fast way of generating relative dates in any format: (Get-Date).AddDays(-1).ToString('yyyy-MM-dd') This would return...
PowerShell ISE v3 Keyboard Shortcuts
Note: Beginning now, we will include useful tips on PowerShell v3. PowerShell v3 is the next generation of PowerShell that is in public beta right...
Getting Movie Database Information
Here's a sample that illustrates how versatile PowerShell is. The function Get-Movie retrieves information about movies from the Internet....
Identifying PowerShell Host
If your script requires a real console, or if your script requires PowerShell ISE features, it may be a wise thing to check which host is actually...
Find WMI Classes
Get-WmiObject is a great cmdlet that returns all instances of a WMI class: PS> Get-WmiObject -Class Win32_LogicalDisk All you need to know is the...
Adding Type Accelerators
Type accelerators are shortcut names that represent .NET types. For example, you can use [XML] instead of [System.Xml.XmlDocument]. By default,...
Rename PowerShell Scripts
Rename-Item can easily batch-rename large numbers of files, simply by piping file objects into it. Here is a sample that finds all PowerShell script...
Verifying Restore Points
When you create a new restore point with Checkpoint-Computer, you do not get back any feedback telling you whether the operation succeeded....