WMI is extremely powerful but a little underdocumented. To change this, a group has formed and is creating a PowerShell-specific WMI reference:...
Getting Help for WMI Objects
read more
database-tools
IDERA Newsletter April 2020
The Latest News from IDERA Product Release Updates, Vote IDERA, and Learn Something New Introducing SQL Inventory Manager v2.6 Get Complete...
Monitoring Infrastructure Will Help You Meet Your SLAs
In the world of information technology (IT) services, it is a requirement that some kind of contract defines the customer’s expectations and...
Backups are Your Best Friend When Disaster Strikes
IT professionals like programmers and database administrators have heard about best practices many times during their careers. Sometimes they adopt...
Ensure Database Health
Keep multiple database platforms running with a single tool. Organizations react to rapidly changing demands because of the escalating crisis while...
Reading Chassis SKU
In Windows 10 and Server 2016, WMI added a new property that simplifies collecting chassis or enclosure SKUs. This one-liner reads the SKU for you:...
Managing Automatic Reset
When a Windows system crashes, it typically reboots immediately. This is called “Automatic Reset Capability”, and with this one-liner...
The Impact of COVID-19 on Database Security
The COVID-19 pandemic is causing havoc in many areas of society across the globe. It has been the cause of thousands of deaths and has stressed our...
Using Custom Validation Attributes
Beginning in PowerShell 5, you can create your own attributes, i.e. custom validators. They can be applied to variables (and parameters), and once a...
Selecting the Best Cloud Environment for Your SQL Servers
The decision to move your SQL Servers to the cloud is not something that is usually done impulsively. There should be extensive planning that goes...
Protect your SQL Servers During the Pandemic
How are you dealing with security vulnerabilities during these turbulent times? Because of the unfolding pandemic, organizations need to make urgent...
How to monitor SQL Server performance with SQL Diagnostic Manager for SQL Server
The monitoring of SQL Server environments is much more straightforward with quality monitoring applications. The proper monitoring applications can...
DevOps, SQL Quality, and Performance
If you have ever written SQL statements then you know how flexible it is. Almost always there are several different ways to write a SQL query that...
Testing for Metered WLAN
Ever needed to know whether you are currently connected to a metered (costly) network? Here is a quick way to check: function Test-WlanMetered {...
Data Visualization as a Tool in the Fight Against COVID-19
Disseminating accurate and understandable information is a crucial part of any strategy to fight the novel coronavirus and help control its spread....
Using WMI Instance Paths (Part 2)
In the previous tip we showed that the new Get-CimInstance command is missing the important “__Path” property that was returned by...
How to Increase the Productivity of Your MySQL DBAs
MySQL is one of the most popular relational database management systems (RDBMS) in the world. Only Oracle has a larger installed base. Professional...
Protect Your Databases by Detecting Suspicious Activity
Some of an organization’s most important computing systems are the databases that store its information assets. They may contain multiple types of...
Aqua Data Studio Helps You Manage Databases and Visualize Data
Organizations are swiftly countering to the evolving requirements prompted by the rapidly developing situation. They apply data to guide decisions...
Using WMI Instance Paths (Part 1)
Generally, it is the best to move away from the old and deprecated Get-WmiObject command and instead use the modern and faster CIM cmdlets like...
How to add SQL Server instances to SQL Diagnostic Manager for SQL Server
With SQL Diagnostic Manager, monitor the performance of the entire SQL Server environment by quickly and easily adding SQL Server instances. There...
IDERA Nominated for 2020 DBTA Readers' Choice Awards
Tell the world how much you love IDERA database tools! We are proud to announce IDERA is nominated across multiple categories in the...
Installing PowerShell 7
PowerShell 7 is a portable app and can run side-by-side with Windows PowerShell. You just need to download and install it. This part is easy because...
Increase the Value of Your Data with the Right Visualization Tool
Data scientists and analysts work with large volumes of information as raw materials. Their job is to take the unprocessed ingredients and find ways...