Many cmdlets have built-in remoting capabilities, for example Get-Service and Get-Process both have the parameter -ComputerName, and so does...
Month: March 2014
Exporting and Importing Credentials in PowerShell
Credential objects contain a username and a password. You can create them using Get-Credential, and then supply this object to any cmdlet that has...
Custom counter – deadlocks in the past X hours
In response to a couple of requests, here’s a custom counter that allows you to alert on the total number of deadlocks which happen in a...
Monyog MySQL Monitor 5.71 Has Been Released
Changes (as compared to Monyog MySQL Monitor 5.7) include: Features * With only one MySQL server selected, Dashboard page will now display charts in...
Finding USB Stick Information
Did you know that Windows logs any USB stick type you ever used? To get that information from the Registry, simply use this function: function...
Finding Time Servers (And Reading All RegKey Values)
Maybe you'd like to get a list of timeservers registered in the Registry database. Then you probably run code like this: Get-ItemProperty -Path...
Finding Expired Certificates
PowerShell grants access to your certificate stores by using the cert: drive. You can use this drive to find certificates based on given criteria....
SQL Server 2014 is almost here!
In case you hadn’t yet heard, last week Microsoft’s Quentin Clark, announced that SQL Server 2014 had reached the RTM milestone on March 18, and it...
Submitting Arguments to EXE Files
Running applications such as robocopy.exe from PowerShell sometimes is not trivial. How do you submit arguments to the EXE so that PowerShell...
Applying NTFS Access Rules
There are many ways to add or change NTFS permissions. One is to reuse existing tools such as icacls.exe. This function will create new folders that...
Delphi (C++Builder) Android Mobile Client DataSnap Server
Преамбула DataSnap – платформа создания многозвенных приложений. Её история достаточно продолжительна, начиная с совсем ранних версий Delphi. Роль и...
SQL Elements 1.1 Beta Now Available
UPDATE: The beta is now closed, thank you for your help! A beta build for SQL Elements 1.1 is now available. Please refer to the beta thread for...
Profiling Systems
If you just want to profile a local or remote system and get back the most commonly used pieces of information, then do not waste time for your own...
SQL Saturday Silicon Valley March 2014 Recap
It was my great pleasure to attend SQL Saturday Silicon Valley this past weekend, along with two of my Idera colleagues, Robert and Jessica. If...
Running Commands Elevated in PowerShell
Sometimes, a script may need to run a command that needs elevation (Administrator privileges). Instead of requiring the script to run with full...
Get-WirelessAdapter
In the previous tip, we illustrated how you can use Registry information to find wireless network adapters. Here is now a function...
Finding Wireless Network Adapters
There are many ways of finding network adapters, but apparently none to identify active wireless adapters. All information about your network...
Drive Data in GB and Percent
When a cmdlet returns raw data, you may want to convert the data into a better format. For example, WMI can report the free space of a drive but...
Aqua Data Studio 14.0.10 – Minor Fixes and an Enhancement
We have released the 14.0.10 patch which addresses a few defects and includes an enhancement. Patch: dd1.aquafold.com/.../ads-14.0.10-patch.zip...
Five tiny features of SQL Diagnostic Manager you may not know about
SQL Diagnostic Manager has been around for a long time, and many of you have been using it for years. For today’s topic I thought it might be fun to...
Finding Hard Drives Running Low on Storage
WMI can retrieve information about drives easily. This will get you the drive information for your local machine (use -ComputerName to access a...
Finding Errors since Yesterday
Relative dates are important to get data within a special time frame, avoiding hard-coded dates and times. This script will get all error and...
Idera SQL XEvent Profiler – a free tool for XEvent monitoring
The Extended Events technology added to SQL Server in SQL 2008 and expanded upon greatly in SQL 2012 is a powerful mechanism for monitoring activity...
Monyog MySQL Monitor 5.7 Has Been Released
Changes (as compared to Monyog MySQL Monitor 5.6.9) include: Bug fixes: * 5.6.9 introduced an issue causing LDAP authentication to fail in some...