After determining that your IT infrastructure will benefit from the introduction of enterprise-level monitoring, you will be faced with selecting an...
Is Monitoring with Agents Right for Your IT Environment?
read more
database-tools
Validating Active Directory Credentials
PowerShell can validate AD username and passwords against the Active Directory: Add-Type -AssemblyName System.DirectoryServices.AccountManagement...
DBArtisan Tips and Tricks for July
The July edition of DBArtisan tips and techniques covered three tips for using DBArtisan. Datasource Navigator SQL Editor Migrating Schema and Data...
Precise is the Best Tool to Identify Database Performance Gains
IDERA’s Precise Application Performance Platform offers users a comprehensive monitoring tool designed to assist in identifying issues that...
Numbering Output (Part 1)
If you’d like to add an incrementing number to your output, here is a simple way: Get-Process | Select-Object -Property '#',...
Where to start with performance tuning Microsoft SQL Server
For a database professional, the most dreaded time is when the database server is unresponsive so that it does not serve the application requests....
What You Need to Know About Entity-Relationship Models
An entity-relationship model - also known as an ER Model, ER Diagram or ERD - is a graphical representation of entities and their relationships used...
Analyzing the Capital One Data Breach
Analyzing the Capital One Data Breach Last week, Capital One hit the news with one of the largest data breaches recorded. In this particular...
Why You Need to Know What You Don’t Know
In the complicated world of database management, a lot of data needs to be assimilated by those responsible for keeping the systems healthy and...
Accepting Masked Passwords
If you ever write PowerShell functions that need to accept sensitive input such as passwords, make sure you allow users to submit SecureString...
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...