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...
PowerShell 7 Ternary Operator
read more
database-tools
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...
Why You Need to Know What You Need
In a perfect world, an organization’s IT requirements are inexhaustible. As new users attempt to access the systems, network bandwidth is...
Announcing the GA Release of SQL Secure 3.3.1
We’re excited to announce the release of SQL Secure 3.3.1 SQL Secure is an auditing and security tool for SQL Servers. It helps identify...
SQL Diagnostic Manager 10.5 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 10.5. Existing users may upgrade to this version through the Idera...
Manage InterBase More Effectively with Aqua Data Studio
InterBase is an embeddable Relational Database Management System (RDBMS) that has many distinctive characteristics. This post will take a look at...
Safely Using WMI in PowerShell (Part 4)
In this mini-series, we are looking at the differences between Get-WmiObject and Get-CimInstance. Future PowerShell versions no longer support...
The EU is Taking Cybersecurity More Seriously. Are You?
Cybersecurity is an issue that is becoming more important every day. A quick glance at the news is liable to alert you to a new data breach that has...
How to run prescriptive analysis, monitor server-level waits, and monitor queries 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...
Using MySQL to Solve Diverse Business Problems
As one of the most popular database solutions in the world, MySQL is used by numerous organizations and businesses. From its humble beginnings as an...
Safely Using WMI in PowerShell (Part 3)
In this mini-series, we are looking at the differences between Get-WmiObject and Get-CimInstance. Future PowerShell versions no longer support...
Cut Downtime and Boost Your Business with These Tips
Computer systems are useless if they are not available. The most amazing applications will languish unused if they cannot be accessed. Unscheduled...
Safely Using WMI in PowerShell (Part 2)
In this mini-series, we are looking at the differences between Get-WmiObject and Get-CimInstance. Future PowerShell versions no longer support...
The Benefits of Increased Attention to the End-User Experience
An old and well-worn adage often heard in the world of business is that “the customer is always right.” This is not to be taken...
Solving the Problem of Complexity in Database Migration
One of the tasks that database teams engage in regularly is data migration. As platforms and environments evolve and become more complex, so do the...
Safely Using WMI in PowerShell (Part 1)
WMI (Windows Management Instrumentation) is part of any Windows operating system and a common and widely used way of getting information about a...
How to monitor tempdb, alert, and integrate with SCOM 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...
How to Optimize Your Database Performance with Automated Tuning
Optimizing database performance is one of the key roles of a database administrator. It can end up taking up the majority of their time and in some...
Keeping Your SQL Servers Healthy and Secure
It’s one of the DBA’s primary responsibilities to maintain the health and security of their SQL Servers. A typical SQL Server...