Performing valid backups of their databases is one of the most important tasks for MySQL DBAs. A typical DBA spends the day maintaining databases...
database-tools
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...
Before You Stop Using MySQL, Read This
An organization’s databases contain information that is essential for its survival. This may encompass sensitive customer data, employee...
Increasing Pipeline Speed
The PowerShell pipeline tends to be slow when it is processing a lot of elements. This can take a lot of time: $result = 1..15000 | ForEach-Object {...
July #SQLChat – Let’s Talk About SQL Server 2019!
What’s new in SQL Server 2019? Join IDERA (@Idera_Software) and host Matt Gordon (@sqlatspeed) on July 31 at 11AM CT for a community...
The Tradeoff Between Database Security and Database Performance
Welcome to our new blog series, The Tradeoff Between Database Security and Database Performance. This series will cover best practices that will...
Using a Centralized Console Will Make You a Better DBA
Consider the working life of a database administrator (DBA). It is their responsibility to maintain the systems that contain an organization’s...
Detecting Key Presses
It may be useful for PowerShell to know whether a given key is currently pressed. This way, your profile script could, for example, do things during...
Monitoring Can be a Valuable Capacity Planning Tool
The cloud provides numerous examples of new and exciting uses of its powerful and flexible computing resources. There are many advantages afforded...
Understand Database Performance Trends
Next in our Benefits of SQL Diagnostic Manager for MySQL blog series, we discuss monitoring and understanding performance trends using visual...
Overriding Out-Default (Part 3)
Advanced PowerShell users often find themselves doing one of three things: They run a previous command and add Get-Member to learn more about the...