Understanding TempDB Contention

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...

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...

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...

Understanding the Limitation of Hash Tables Compared to Switch Statements In the previous tip, you used a hash table to translate input values. However, unlike Switch-statements, Hash Tables have no "default" so all values need to be present in the hash table. Check...

Sometimes, you may have an existing VBScript that already does just what you want. You can easily incorporate any VBScript into PowerShell because PowerShell can call just about anything that is executable, including VBScript. The tricky part is that you mainly want...

In a previous tip, you learned how to call PowerShell statements and read their return value. Return values are somewhat limited because they can only be numeric. There is an easy way to do this if you'd like to read more structured information from a PowerShell call...

WMI is an excellent way of remotely checking files or folders since it has the ability to access individual files and folders, and also works locally as well as remotely. Files are represented by the WMI class CIM_DataFile whereas folders are represented by...

Convert ASCII value to a character To convert the ASCII value to a character, use type casting like this: [char]65 Convert a character to ASCII value To do the opposite and convert a character to its ascii value, use this: [int][char]'A' Here, the letter "A" is first...

Validating User Input as a URL Using System.URI To make sure user input is a valid URL, you can use the System.URI type. Try to convert the raw string into this type. If it works, the string is a valid URI. You can then further examine the converted result to limit...

Refer the code : In PowerShell, you can initialize multiple variables in just one line. The following line sets all variables to the value 1: $a = $b = $c = $d = 1 To swap variables, list variables as comma-separated lists (actually, PowerShell treats your lists...

Hash Tables are convenient but are not true objects. This is bad because you are unable to output the hash content to formatting cmdlets or export cmdlets. With a short function, you can easily convert a Hash Table to an object, providing all the flexibility you need...