Performing an inventory may not immediately spring to mind when considering the various tasks performed by an organization’s database team....
database-tools
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...
Precise for Oracle on Windows
In recent versions of Oracle, their installer creates a new standard Windows user which is not part of the admin group. Previously, the user...
Error upgrading SQLdm Dashboard
I am trying to upgrade the Idera Dashboard from version 4.4.0.18 to 4.6.0.9 but, when I run the installer it tells me the installation was...
IntelliSense for Parameters (Part 3)
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...
Improve DBA Productivity with a Unified Management Tool
Computing professionals often are called upon to work in very challenging conditions. The world of information technology is constantly evolving as...
IntelliSense for Parameters (Part 2)
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...
Informative Alerts Help You Avoid SQL Server Problems
Microsoft’s SQL Server is an extremely popular relational database management system (RDBMS) that is used by hundreds of thousands of...
How to monitor the performance of Galera Clusters
There are several ways to deploy and maintain a Galera Cluster for the MySQL environment. SQL Diagnostic Manager for MySQL can help with each...
IntelliSense for Parameters (Part 1)
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...