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...
SQL Server
Monitoring is the Key to Improving Database Performance
Performance is a term that gets thrown around in many different contexts. It’s a much sought-after commodity in endeavors as diverse as...
Successfully Manage SQL Server Performance
Learn how to manage SQL Server performance from IDERA’s experts. Now more than ever, it is important to ensure that your SQL Server instances...
What the Regulatory Auditors Want to See
The very mention of the words “regulatory audit” can send shivers down the spine of an organization’s IT management team. There...
Announcing General Availability of Aqua Data Studio 20.6!
On behalf of the entire Aqua Data Studio team, we’re excited to announce the release of Aqua Data Studio version 20.6 with Enhancements in the...
Keep Your SQL Servers Up and Running During the Pandemic
During this pandemic, many healthcare organizations are struggling with a shortage of medical supplies and staffing. They are also experiencing a...
How to Keep Track of Your SQL Servers
The designers of modern SQL Server environments have many implementation models available to them. Based on the organization’s needs,...
Why You Should be Encrypting Database Backups
Data security is a hot topic in the IT industry for reasons that range from simply safeguarding information resources to maintaining compliance with...
Using SQL Server Database Projects
Back in 2012, I had the pleasure and privilege of working with one of the sharpest developers I’ve ever met. He was a .NET lead of the...
Are Statistics Being Used?
You know those tweets that you see once but can never find again? I remember seeing one a while ago where someone tweeted to #sqlhelp asking if the...
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...
Keep Your SQL Servers Secure with These Best Practices
Keeping an organization’s SQL Servers secure is the supporting DBAs’ most critical responsibility. The performance and availability of...
Best Practices to Protect and Backup Your SQL Servers
One of the most important jobs a DBA has is keeping their databases safe and protected. While performance is a critical factor in database...
SQL Inventory Manager 2.6 Now Available
SQL Inventory Manager 2.6 Now Available We are pleased to announce the general availability of SQL Inventory Manager 2.6. Existing users may upgrade...
The Value of a Complete Server Inventory
Performing an inventory may not immediately spring to mind when considering the various tasks performed by an organization’s database team....
The Challenge of Keeping PII Secure in the Cloud
A common characteristic shared by things of value is that measures must be taken to keep them safe. There are always entities who would like to take...
The Best Way For You to Manage SQL Server Jobs
Being a DBA for an SQL Server implementation is no trivial exercise. In many cases, mission-critical business systems rely on the performance and...
Informative Alerts Help You Avoid SQL Server Problems
Microsoft’s SQL Server is an extremely popular relational database management system (RDBMS) that is used by hundreds of thousands of...
What is Index Fragmentation and What Can You Do About It?
In the world of SQL Server administration, many issues can negatively impact database performance. They range from inappropriately provisioned...
CCPA is in effect – Now What??
On Jan 1st, 2020 as many of us were sleeping off the revelry from the previous night, silently the CCPA (California Consumer Protection Act) went...
Aqua Data Studio 20.5 General Availability
Idera is excited to announce Version 20.5 of Aqua Data with major Enhancements in the following areas. Platform support now includes Amazon RDS...
Announcing the GA Release of SQL Safe Backup 8.6
We are pleased to announce the general availability of SQL Safe Backup 8.6. IDERA SQL Safe Backup provides a mission-critical backup and recovery...
An Improved GUI Results in Better SQL Server Tuning
Database transactions are at the heart of many mission-critical applications throughout the business world. Monitoring these transactions to tune...