In the previous tip we explained how you can download port assignments via PowerShell from IANA. This process requires Internet access and can take...
database-tools
Get List of Port Assignments
The IANA (Internet Assigned Numbers Authority) maintains a CSV file with all known port assignments. PowerShell can download this list for you: $out...
New plugin for hard disk SMART monitoring
Ever wonder if your hard drive was trying to tell you something? Well, it just might be. S.M.A.R.T. has been around forever it seems but it largely...
Smell Like Flowers With Ducky Indices
B-tree indices in Oracle are powerful. Sometimes a very good index can be even better. Precise for Oracle helps DBAs recognize this...
World Time Clock
PowerShell 5 comes with Get-TimeZone which returns all defined time zones and their time offset. This is all you need for a one-liner world clock:...
Optimal Oracle Index Performance
B-tree indices in Oracle are powerful. Sometimes a very good index can be even better. Precise for Oracle helps DBAs recognize this situation....
Customized Solutions Using SQL Safe Backup’s XSPs
During my days as a Technical Support Engineer here at IDERA, I’d occasionally encounter a customer trying to do something that’s not directly...
Check for Daylight Savings Time
Here is how PowerShell can find out whether Daylight Savings Time is currently effective – a potentially needed detail when doing GMT...
Setting Time Zone
While you need administrative privileges to adjust time and date on your computer, each user can change the time zone, i.e. when you travel....
Finding All Variables in a Script
In the previous tip we illustrated how you can analyze the content of a script block and search for variables or commands. The same is possible for...
Finding All Variables in a Script Block
To analyze the content of a script block, you can easily examine the AST, and, for example, create a list of all variables in the code: $code = { $a...
Dashboards
Precise's historic repository is available for trend reporting, dashboards, and analysis. On Precise's Application screen, in the top right corner,...
Running PowerShell Script as a Scheduled Task
If you need to run a PowerShell script in regular intervals, why not run it as a scheduled task? Here are some lines that help you create a new...
Webinar series – A step-by-step process to optimize MySQL database performance
Hope you have been following our recent webinars on MySQL, Galera Cluster, AWS monitoring and more. We are coming up with a webinar series in...
Spying on Function Source Code
Here is a quick way how to find the source code of PowerShell functions: ${function:Clear-Host} | clip This would copy the Clear-Host source code to...
Join the Team – Talk Back
Those of you who have endured a product roadmap session with me know that the insight into our direction comes with a price. That price is me...
Getting the Most from Your Software Vendor
This topic is relevant to more than just Idera and it comes from experience working for and with multiple software vendors in multiple...
Modeling Graph Data Stores in ER/Studio
Modeling Background Enterprise data environments have become increasingly complex due to a proliferation of different technologies and data...
Modern Alternative to More
In a PowerShell console, you can continue to pipe to more, just like in cmd.exe, to view results page by page. However, more does not support...
History of the IDERA Duck
We know what you’re all thinking - what’s the deal with the Rubber Ducks? If you’ve attended a conference we've sponsored, or...
Creating SMB Shares Remotely
Here are a couple of lines that remotely create an SMB share on a server: #requires -Version 3.0 -Modules CimCmdlets, SmbShare -RunAsAdministrator...
Important PowerShell Variables
Here is a list of important PowerShell variables: $pshome is the path to the place where PowerShell lives. $home is the path to your personal...
Read-Host Blocks Automation
Using Read-Host to ask for user information can be problematic because it prevents scripts from running unattended. A better way could be to wrap...
Force Client Time Resync
If your client does not sync time correctly with your domain controller, try the code below. It does require Admin privileges: w32tm.exe /resync...