Sometimes a very good index can be even better post - Ducky Indices Post Tomorrow on Tuesday June 27, at 11am EDT / 10 Central, we'll share the...
database-tools
Database Continuous Delivery – It’s Not as Scary As You Think
Database continuous delivery can be a scary topic for database administrators. This requires the DBA to start trusting tools & processes,...
Displaying Folder Tree
PowerShell is a friend with old console commands, so the easiest way of displaying the tree structure of a folder is the old “tree”...
How to Secure Your Data in the Cloud
What happened? On Monday, June 12, 2017, a security researcher discovered that sensitive personal data of nearly all the 200 million registered...
Using Cached Port File
In the previous tip we explained how you can download port assignments via PowerShell from IANA. This process requires Internet access and can take...
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...