There are situations when you’d like to know how long some code took to execute, for example to return statistics or compare code, and there are...
database-tools
Visualization and Analytics for a Competitive Edge
Every CEO and business leader wants to find a strategy that provides their enterprise with a competitive advantage over its rivals. In today’s...
Foreach -parallel (Part 3: Mass Ping)
In PowerShell 7, there is a new parallel ForEach-Object that can execute code in parallel and speed up things considerably. The same technique can...
How to improve your SQL queries to improve database performance
A query that runs well on a local set of test data can fail miserably on a production system. Very often, a simple change in the syntax can make a...
Implementing the Internet of Things with MySQL
The Internet of Things (IoT) has grown from an interesting concept to a paradigm that is changing the way individuals and businesses operate in the...
Which is the Right Cloud for Your SQL Server Instances?
The advantages of migrating some or all of your computing environment from on-premises data centers to the cloud are well documented. There are...
Foreach -parallel (Part 2: Windows PowerShell)
PowerShell 7 comes with a new ForEach-Object that supports parallel execution: 1..100 | ForEach-Object -ThrottleLimit 20 -Parallel { Start-Sleep...
Meeting Demand Results in Satisfied Customers
The holiday season in the United States that extends from Thanksgiving through the New Year has many different meanings to the country’s...
Issue after installing IDERA Dashboard not open with the following Error
Hello Everyone, facing the below error when opining Dashboard Error CWF cannot run because some application requirements are not met. IDERA Core...
Multiple Maintenance Modes
Is there anyway to have multiple maintenance modes for a single sql server. I have three minor outages a month: Monthly patching, snapshot...
A Great Tool for Tuning and Troubleshooting SQL Servers
Aqua Data Studio is a versatile and comprehensive IDE that supports over 25 of the most widely used database platforms. It offers DBAs and...
Foreach -parallel (Part 1: PowerShell 7)
PowerShell 7 comes with a built-in parameter to run different tasks in parallel. Here is a simple example: 1..100 | ForEach-Object -ThrottleLimit 20...
SQL Diagnostic Manager for MySQL 8.9 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager for MySQL 8.9. Existing users may upgrade to this version through...
Who uses IDERA’s products and what is their experience?
Are you curious about who the customers of IDERA Database Tools are in terms of the type of organization, industry, and country? And are you...
-RepeatHeader Parameter
Here is a somewhat unknown parameter: -RepeatHeader! What does it do? Let’s assume you want to see results page by page (which only works in a...
Monitoring Results in MySQL Performance Gains
MySQL is one of the most popular and widely used database platforms in the world. If you are a DBA or database developer, there is a very high...
One of These Things is Not Like the Others
Individuals of a certain age or those with children in the same range are probably familiar with this phrase. It was used extensively by the...
PowerShell 7 Ternary Operator
With PowerShell 7, the language gets a new operator that created a lot of debate. Basically, you don’t have to use it, but users with a developer...
Get-ComputerInfo vs. systeminfo.exe (Part 2)
In PowerShell 5, a new cmdlet called Get-ComputerInfo was introduced which does what systeminfo.exe did in the past, yet Get-ComputerInfo is...
How to plan capacity, monitor Always On availability groups, report, and integrate with PowerShell with SQL Diagnostic Manager for SQL Server
SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager for SQL Server helps database administrators to find and fix SQL Server performance...
Why You Need Change Management for Regulatory Compliance
Working in the IT field requires the ability to quickly and efficiently assimilate with many different types of change. Some of the changes are...
What Are Your Baselines and Why do They Matter?
A baseline is a fixed point of reference that is used for making comparisons. In the world of information technology, baselines are widely used as a...
Get-ComputerInfo vs. systeminfo.exe (Part 1)
For a long time, the command-line utility systeminfo.exe provides a wealth of information about a computer and can return object-oriented results...
Installing the SQLDM CWF dashboard during a trial
In this blog post, I'll be guiding you through the installation of the SQL Diagnostic Manager and the IDERA Dashboard in a trial...