Announcing the General Availability of IDERA SQL Compliance Manager 7.0

I was in Indiana this past weekend at SharePoint Saturday Indianapolis, and one of the presentations I delivered at the event was a favorite of mine: “Caching-In” for SharePoint Performance.” With SharePoint 2013 hitting the streets, I decided it would be a good idea...

In previous tips we illustrated how you can turn file system paths into arrays and then create new paths by changing or excluding parts of the array. This can become even more convenient when you cast the array to an ArrayList type. Now, it is very easy to exclude...

When you turn a path into an array to manipulate parts of the path, if you access path elements by fixed index numbers, then this approach will only work if the path has a fixed number of subfolders. To work with any path length, try using variables. This example will...

PowerShell lets you access multiple array elements. With the help of -split and -join, you can easily manipulate file system paths this way. To exclude the second and third level folder, try this: $path = 'C:\users\Tobias\Desktop\functions.ps1' $array = $path...

In PowerShell 2.0, Set-ItemProperty by default always creates REG_SZ (String) values. PowerShell 3.0 is smarter. When you submit a numeric value, then PowerShell 3.0 automatically creates a DWORD value. If you submit a non-numeric value, a REG_SZ is created. Try for...

Sometimes, you might see interesting information on websites. For example, navigating to http://www.ssa.gov/OACT/babynames/index.html will open a site with popular baby names. If you'd like to work with that data, the traditional approach is to read the raw HTML...

Let's assume you have a variable with a negative value, and you'd like to make it a positive value. Here's a simple way: Basically, this approach negates the variable, so you can do the opposite as well: Note that this will not change $a unless you...