SQL Under Siege: The Hidden Threats Lurking in Your Databases

In the previous tip we covered klist.exe and how it can be used to purge all Kerberos tickets for the current user so that new permissions will take effect immediately. Combining PowerShell with klist.exe for More Flexibility While PowerShell can run external apps...

No need to reboot a system just to apply new permission settings. Instead, purge your Kerberos tickets so that you will get a new ticket based on the current permissions. PowerShell Command to Purge Kerberos Tickets In PowerShell, use this command to purge all cached...

Chocolatey is a free package manager for Windows that can be used to download and install software. Installing Chocolatey via PowerShell Before you can use Chocolatey from PowerShell, you need to download and install it. If you don’t have administrator privileges, use...

Enabling VT Escape Sequences in PowerShell 5.1 Starting in PowerShell 5.1, the PowerShell console supports VT escape sequences that can be used to position and format console text. Note that this works in the console only, not the PowerShell ISE. Note also that you...

When you try and sort IPv4 addresses via Sort-Object, this fails: PS> '10.1.2.3', '2.3.4.5', '1.2.3.4' | Sort-Object 1.2.3.4 10.1.2.3 2.3.4.5 Alphanumeric Sorting by Default This is no surprise because the data is of type “string”, so Sort-Object uses alphanumeric...

Reviewing the Test-OnlineFast Function In the previous tip we published a super-fast function called Test-OnlineFast, and this function was able to ping an entire IP segment in record time: PS> $iprange = 1..200 | ForEach-Object { "192.168.189.$_" } PS>...

Revisiting the Test-Online Fast Function In the previous tip series, we developed a new function called Test-OnlineFast that can ping multiple computers in record time. For some reason, the final version of this function did not include the pipeline support we...

Understanding Event Log Source Names When you write events to an event log using Write-EventLog, you must specify a valid source name. However, there is no easy way of finding out which source files are registered for a particular event log. This can also bite you...

Here is a line of code that often puzzles PowerShell users: Get-Service | Select-Object -ExcludeProperty Name Understanding the -ExcludeProperty Behavior When you use Select-Object, its -ExcludeProperty parameter does not seem to do anything. The truth is:...

Here is a fun PowerShell function called Convert-PowerShellToBatch. Provide it with the path to a PowerShell script, or pipe in the results from Get-ChildItem to batch-convert many scripts. How It Works: Batch File Generation The function creates a batch file per...

If you’d need to find out the SID for a user name, here is a useful chunk of code that does the job: $domain =…

Out-GridView always produces a table with one object per line: Get-Process -Id $pid | Out-GridView Occasionally, it would be more helpful to display the object…