If you ever write PowerShell functions that need to accept sensitive input such as passwords, make sure you allow users to submit SecureString...
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
The Benefits of SQL Server Health Checks
Multiple benefits can be gained through the use of SQL server health checks. They might not be at the top of your DBA’s to-do list, but a...
Apply to the IDERA ACE Program!
Applications for the 2020 IDERA ACEs are now open! The search has begun for the 2020 IDERA ACEs. Do you have a passion for helping the community and...
Why You Should Automate MySQL Server Synchronization
One of the tasks a MySQL DBA is responsible for is keeping data synchronized between different but related instances of their databases. It is a...
Finding Hidden PowerShell Applications
The most widely known PowerShell hosts are certainly powershell.exe and powershell_ise.exe because they ship out-of-the-box. However, there can be...
Announcing the General Availability of SQL Safe Backup 8.5.2
We are pleased to announce the general availability of SQL Safe Backup 8.5.2. Existing users may upgrade to this version through the IDERA Customer...
Ensuring Security By Monitoring Performance
In the conclusion of our blog series, The Tradeoff Between Database Security and Database Performance, we outline how performance metrics can be...
Make Sure Unauthorized Users Stay Out of Your Database
Protecting your database is a critical responsibility of today’s DBA. It has always been important to control access to a company’s...
Precise’s Command Line Interface (CLI)
The CLI can be a convenient and fast way to make changes to the monitored deployment. The CLI is very versatile. Just about all...
Benefits of Automating Your Routine Database Tasks
There is no getting around the fact that most of us have jobs which involve at least some degree of repetitive and routine tasks. It really doesn’t...
Controlling Processor Affinity
Most modern computers have more than one processor, either physical or logical. If you’d like to find out the number of processors, here is a...
It Can Be Painful to Find Your Problem SQL Statements
One of the most important tasks that fall under the responsibility of your DBAs is the optimization of their SQL servers and associated databases....
Why an Application’s Performance Matters
Most software applications provide results through some form of interaction. The interaction may come in the form of large data sets being crunched...
Dumping All Passwords from Chrome
In the previous tip we illustrated how you can dump all passwords from your personal Windows Password Vault. The same is true for basically any...
Metrics To Optimize Security and Performance
Next in our series, The Tradeoff Between Database Security and Database Performance: we explore best practices for capacity planning as well as...
The Advantages of Automating Your MySQL Backups
Performing valid backups of their databases is one of the most important tasks for MySQL DBAs. A typical DBA spends the day maintaining databases...
Dumping Personal Passwords from Windows
Windows has a protected password vault where it can store your secret passwords so you don’t have to always enter them manually in Internet...
Best Practices for Network Monitoring
In the world of eCommerce, remote offices, and mobile users, your network is one of the most important components of your organization’s...
Fix Problems Proactively with SQL Diagnostic Manager for MySQL
In the conclusion of our blog series, Benefits of SQL Diagnostic Manager for MySQL, we explore features of SQL Diagnostic Manager for MySQL that...
Choosing the Best Database Tool for Your Needs
Database professionals such as DBAs and developers spend their time performing a diverse set of tasks designed to administer and improve the systems...
Installing Google Chrome via PowerShell
To download and install the Google Chrome browser, simply combine a couple of generic PowerShell commands: $Installer =...
An Inventory of Your SQL Servers Can Save You Money
Managing a large SQL Server environment poses a number of challenges to the DBAs and IT staff responsible for its maintenance. Keeping the databases...
SQL Diagnostic Manager 10.5 Preview
SQL Diagnostic Manager 10.5 will be available soon and it is currently available for our beta customers at...
Dealing with the Complexities of Optimizing Mobile Apps
There is no denying that the life of an application programmer has changed dramatically in the last thirty years. Once upon a time, the application...
Using Pop-up Dialogs that Are Always Visible
In the previous tip we used an old COM technique to display a pop-up box with a built-in timeout. That worked pretty well except that the dialog box...
Database Administrator Versus Security Administrator
In week two of our blog series The Tradeoff Between Database Security and Database Performance, we explore the roles of database administrator and...
A Superior Solution to Cross-Platform Database Development
Database developers and database administrators (DBAs) have different but related responsibilities concerning the systems that curate an...
The Advantages of Using SQL Safe Backup with TSM
Backing up the SQL databases for which they are responsible is one of the most important functions of a DBA. While streamlining performance might be...
Use Hash Tables to Make Code Readable
Maybe you stumbled across code like this in the past: $shell = New-Object -ComObject WScript.Shell $value = $shell.Popup('Restart...
Monitoring MySQL and MariaDB Servers
In week 5 of our Benefits of SQL Diagnostic Manager for MySQL blog series, we detail MySQL and MariaDB monitoring features with SQL Diagnostic...