Don’t Take Chances - Backup Your SQL Data! With an overwhelming amount of blog posts, news articles, LinkedIn horror stories, and water cooler chats...
database administration
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
How to Successfully Migrate SQL Server to Azure SQL Database
Learn about SQL Server to Azure migration and follow these procedures for a trouble-free migration process If you’re thinking about migrating your...
SQL Defrag Manager 3.8 General Availability
We’re excited to announce the release of SQL Defrag Manager 3.8 SQL Defrag Manager is an industry leading automated performance solution that...
SQL Diagnostic Manager 12.3 General Availability
SQL Diagnostic Manager 12.3 is available now. Upgrade or download the free trial version from Idera.com.
SQL Diagnostic Manager for MySQL 8.9.5 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager (SDM) for MySQL 8.9.5 Existing users may upgrade to this version...
The One Configuration Change to Make on All SQL Server Instances
With every fresh SQL Server installation, there are several default configuration changes you probably consider. For instance, you should probably...
The One Trace Flag to Use on All SQL Server Instances
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Being a Proactive DBA Makes You More Productive
A career as a database administrator (DBA) should appeal to individuals interested in a job that involves a diverse range of duties and technical...
Geek Sync | Automating Database Administration Is No Longer Optional
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Identifying Performance Problems Part 1
Every server, database, storage appliance and network encounter some sort of performance issues. It is a major part of our job as database...
How to ensure that SQL Server databases are backed up on a regular basis
Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases....
An Efficient Solution for Multi-Platform Environments
One of the challenges that database teams face every day is keeping up with their responsibilities in multi-platform environments. In many shops, a...
Database Development in Multi-Platform Environments
Multi-platform database environments are the norm in today’s business world. A database developer or administrator may still exhibit expertise...
The Best Way to Reduce Your DBAs’ Learning Curve
When an individual chooses a career as a database administrator they are committing themselves to a lifetime of learning. Keeping abreast of new...
A Simple Way to Make Your SQL Server DBAs More Efficient
The role of an SQL Server database administrator brings with it a wide range of responsibilities. On any given day a DBA may have to address...
Heightened Productivity for Your DBAs with Aqua Data Studio
The importance of data resources to modern businesses has resulted in database administrators assuming a more critical role in the corporate IT...
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....
The Rise of Cross-Platform Database Administration
Time and money are two things that are always in short supply. Let’s face facts. It’s a rare individual who turns down some extra cash...
Improve DBA Productivity with a Unified Management Tool
Computing professionals often are called upon to work in very challenging conditions. The world of information technology is constantly evolving as...
Who Uses Aqua Data Studio and What Are its Benefits?
Aqua Data Studio is a tool for developers and administrators that offers a platform for data management and analytics across any type of cloud,...
Which top metrics should you monitor for MySQL databases?
As tables increase in size and more and more users come online, it becomes necessary to finetune the database server from time to time. The secret...
How to become a database administrator for MySQL
You are reading this because you think that becoming a database administrator may be the right career path for you. Database administrators are...
September #SQLChat – Big Data and the DBA
With Big Data only getting bigger, what new technologies and tools should both junior and seasoned DBAs learn to stay relevant? Join IDERA...
Announcing the General Availability of DB PowerStudio 17.0.4
We are excited to announce the release of DB PowerStudio version 17.0.4 with improvements in the following areas. New Platform Support We have...
How to Make Your Database Administrators More Efficient
The role of a corporate database administrator has evolved tremendously since the introduction of relational databases in the late 1970s. A DBA from...
A Solution to the Cross-Platform Database Blues
The role of a database administrator (DBA) has undergone tremendous evolution in the 21st Century. In the murky past, a DBA could carve out a career...
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...
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...
SQL Performance, Part 4: Additional Considerations
Today’s blog post concludes our four-part look into SQL performance and optimization. Part one introduced and explained relational...
Announcing SQL Admin Toolset 1.9.2 General Availability
We are pleased to announce the general availability of SQL Admin Toolset 1.9.2. Existing users may upgrade to this version through the IDERA...