The Latest News from IDERA Extended Cloud Support, Get Lucky with Savings, Upcoming Events, and more! IDERA Database Tools Expand Support for...
database-tools
Dynamic Argument Completion (Part 4)
In the previous tip we explained how you can use [ArgumentCompleter] to add powerful argument completers for parameters. There are limitations...
Dynamic Argument Completion (Part 3)
With the discoveries in our past tips, let’s compose a useful completion code that suggests all available programs you can launch: function...
Using Aqua Data Studio for Reverse Engineering
The practice of reverse engineering has many applications in the world of information technology. It can be used to gain insight into the...
How to monitor MySQL performance with SQL Diagnostic Manager for MySQL
The monitoring of MySQL and MariaDB environments is much more straightforward with quality monitoring applications. The proper monitoring...
Dynamic Argument Completion (Part 2)
In our previous tip we looked at [ArgumentCompleter] and how this attribute can add clever code to parameters that provides auto-completion values...
Dynamic Argument Completion (Part 1)
In previous tips we explained various ways of adding argument completers to your parameters. One approach used the [ArgumentCompleter] attribute and...
Large Financial Organization Using ER/Studio to Manage Data – Case Study
This is one of our larger clients. They are a huge financial organization. They use ER/Studio to document and design data assets. As they say...
The Value of a Complete Server Inventory
Performing an inventory may not immediately spring to mind when considering the various tasks performed by an organization’s database team....
Focusing on the IT End-User Experience
Most computer systems and applications are designed to provide information to human users. There are certain interactions between applications or...
Listing Installed Applications (Part 2)
In the previous tip we read the registry to find out paths to applications you can launch. This approach worked well but had two flaws: first, the...
Listing Installed Applications (Part 1)
Ever wondered what the path is to launch a given application? The Windows registry has a key that stores such information: $key =...
A Way to Help Locate Hidden Cryptojacked Systems
In the world of information technology, there is a wide variety of software products and tools available for anyone to use. For the most part, these...
Strong Policies Result in Better Database Security
Keeping their databases secure is one of the things that can keep a DBA up at night. There might be pressure to improve performance to satisfy...
Secret Dynamic Argument Completer
In the previous tip we introduced the lesser-known “ArgumentCompletion” attribute that can provide IntelliSense-like autocompletion to parameters....
The Benefits of Data Visualization in Science
Data visualization is a powerful technique that is used extensively to enable complex information to be more readily understood. It is one of the...
How to configure metric thresholds and baselines with SQL Diagnostic Manager for SQL Server
In SQL Diagnostic Manager, whenever a metric exceeds the configured value or threshold, the state of the metric changes and it can execute an...
Creating Colorful Console Hardcopies
If you’d like to hardcopy the content of a PowerShell console, you can copy and select the text, but this messes up colors and formatting. A better...
The Challenge of Keeping PII Secure in the Cloud
A common characteristic shared by things of value is that measures must be taken to keep them safe. There are always entities who would like to take...
Enterprise Data Modeling for Business Intelligence Applications
Executing an effective business intelligence workflow requires effective data management. You need to know where you’ve been and what you have...
Understanding $ErrorView
When PowerShell encounters a problem, it displays a rather lengthy error message: PS> 1/0 Attempted to divide by zero. At line:1 char:1 + 1/0 +...
Finding the MySQL Queries That Need to be Optimized
There are many aspects of a MySQL database that can lead to performance issues. A system that was returning blazingly fast responses when it was...
IntelliSense for Parameters (Part 4)
Wouldn’t it be nice if parameters would suggest valid arguments for the user? Sometimes they do. When you type below command and press a SPACE after...
How to configure alert actions and responses with SQL Diagnostic Manager for SQL Server
One of the more innovative components in SQL Diagnostic Manager is the alert actions and responses. This is the part of SQL Diagnostic Manager that...