Keep multiple database platforms running with a single tool. Organizations react to rapidly changing demands because of the escalating crisis while...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
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...
Enabling Clickable PowerPoint Actions
Using clickable actions in PowerPoint presentations can be super useful to launch Visual Studio Code or PowerShell ISE, and seamlessly open and demo...
Why is database backup compression better than file deduplication?
Database administrators often argue with their storage administrators about not compressing database backups. Storage Administrators state that they...
Manage Automatic Disk Checks
Whenever Windows detects irregularities with storage drives, it enables an automatic integrity check. For system partitions, on next boot, Windows...
Managing Databases in the Face of the Global Pandemic
The COVID-19 virus that is currently plaguing the world has impacted virtually every aspect of our lives. Things we previously took for granted like...
Getting Available Video Resolutions
WMI can return a list of available video resolutions for your video adapter: PS> Get-CimInstance -ClassName CIM_VideoControllerResolution |...
COVID-19 and Tools to Support Database Professionals
Are you working in crisis mode and need some help? Organizations are reacting to rapidly changing demands because of the current escalating crisis....
Why Capacity Planning is Important for Your Business
Many related factors need to come together to create successful IT solutions that effectively address business needs. The first requirement is that...
Monitoring the Critical Applications That Benefit Society
As the world faces the onslaught of the COVID-19 virus and its effects on society, the availability of certain websites and applications takes on a...
Be Careful with Some Commands
Here are three commands often found in PowerShell scripts that you should be careful about because they can have severe side effects: exit“exit” is...
Dealing with Out-GridView Bug
Out-GridView can serve as a universal selection dialog when you add the -PassThru parameter. The one-liner below stops all services you select in...