ApexSQL Audit Is Reaching End of Life — Here’s Your Next Step

If you’ve been using ApexSQL Audit, you’ve probably already heard the news: the product is moving into limited support and will be retired completely by...
Read More

Categories

Using RegEx to Filter Files

Using RegEx to Filter Files

by | Jul 7, 2013 |

Get-ChildItem supports basic wildcards, but it does not support the rich feature set of regular expressions. If you combine Get-ChildItem with Where-Object, you can easily add this functionality. Filtering DLL Files by Name Pattern in PowerShell This example lists all...

Using RegEx to Filter Files

Finding User Account with WMI

by | May 24, 2013 |

WMI represents all kinds of physical and logical entities on your machine. It also has classes that represent user accounts which include both local and domain accounts. Retrieving the Currently Logged-On User This piece of code returns the user account of the...

Using RegEx to Filter Files

Increase SQL Server Performance Using Multiple Files

by | Jan 2, 2013 |

By default, SQL Server databases are comprised of two files: the primary data file (or .mdf) and the log file (or .ldf). It is, however, possible to configure SQL Server databases to use additional files – which can be an effective means of increasing SQL Server...

Using RegEx to Filter Files

Change Order of CSV Columns

by | Nov 5, 2012 |

If you have a CSV file and would like to change the order of columns, simply import it into PowerShell, use Select-Object to change the order, and then re-export the CSV file again! $Path = "c:\somepathtocsv.csv" (Import-CSV -Path $Path) | Select-Object -Property...

Using RegEx to Filter Files

Check Windows License Status

by | Oct 17, 2012 |

In a previous tip we explained how you can use slmgr, a built-in VBScript, to check Windows licensing state. Accessing the Raw Licensing Data in PowerShell The core information used by this VBScript actually comes from WMI, so in PowerShell, you can directly access...

Using RegEx to Filter Files

Tips for Optimizing XML in SQL Server

by | Sep 5, 2012 |

I’ve worked on a project that used XML heavily inside SQL Server. We really utilized SQL Server’s XML support almost to the full extent, but with some repercussions. As we did our load testing, performance did degrade and we had to step back and adjust how...

Using RegEx to Filter Files

Stripping Decimals Without Rounding

by | Feb 10, 2012 |

Extracting the Integer Part of a Division Result When you divide numbers and just want the decimals before the decimal point, you could cast the result to integer. However, this would also round the result: PS> 18 / 5 3.6 PS> [Int](18/5) 4 Removing Decimals...

Using RegEx to Filter Files

Removing Multiple White Spaces

by | Feb 2, 2012 |

Removing multiple white spaces from text is easy in PowerShell. -replace operator Simply use -replace operator and look for whitespaces ("\s") that occur one or more time ("+"), then replace them all with just one whitespace: PS> '[ Man, it works! ]' -replace...

Using RegEx to Filter Files

Sending Emails with Special Characters

by | Jan 23, 2012 |

Send Emails with PowerShell Using Send-MailMessage PowerShell has built-in support for sending emails: Send-MailMessage! All you need is an SMTP server. However, with standard encoding you may run into issues where special characters are mangled. -Encoding parameter...

Using RegEx to Filter Files

Ignoring Empty Lines

by | Jan 12, 2012 |

Reading Text Files and Skipping Blank Lines To read in a text file and skip blank lines, try this: $file = 'c:\sometextfile.txt' Get-Content $file | Where-Object { $_.Trim() -ne '' } It will omit empty lines, lines with only blanks and lines with only tabs. ReTweet...

Using RegEx to Filter Files

Writing Registry Key Default Values

by | Dec 8, 2011 |

Set the default value for a registry key If you need to set the default value for a registry key, you can use either of these approaches: Set-ItemProperty -Path HKCU:\Software\Somekey -Name ‘(Default)’ -Value MyValue Or, you can just do this: Set-Item -Path...

Using RegEx to Filter Files

HTML-Scraping with RegEx

by | Oct 20, 2011 |

Scraping Website Data with PowerShell To scrape valuable information from websites with PowerShell you can download the HTML code and then use regular expressions to extract what you are after. That's not hard. Here is a sample: $webclient = New-Object...

Using RegEx to Filter Files

Case-Sensitive Hash Tables

by | Jun 13, 2011 |

PowerShell hash tables PowerShell hash tables are, by default, not case sensitive: PS > $hash = @{} PS > $hash.Key = 1 PS > $hash.keY = 2 PS > $hash.KEY 2 Creating Case-Sensitive Hash Tables in PowerShell If you need case-sensitive keys, you can create the...

Using RegEx to Filter Files

Making sure PowerShell scripts run in 32-bit

by | May 3, 2011 |

Dealing with 32-bit Dependencies in a 64-bit Environment If you are using code that can only run in a 32-bit environment (i.e. using old database drivers or COM objects), here is a solution that will re-launch the script in a 32-bit PowerShell when it is launched in a...

Using RegEx to Filter Files

Configuring WSMan Remotely for multiple computers

by | Nov 23, 2009 |

When working remotely in a peer-to-peer or cross-domain scenario, you will have to add all the computers you'd like to communicate with into the trusted hosts list. Overwriting Issue When Adding Trusted Hosts Unfortunately, when you try this, any new entry will...