A database needs users to provide any value to an organization. While it might be instructive from an academic point of view to simply collect large...
It is Never a Bad Time to Revisit User Permissions
read more
blog
How can you balance database security and database performance?
The security of any database can be improved. However, that likely degrades the performance of the database. The cost increases to improve database...
Addressing Out of Control SQL Server Sprawl Effectively
Data is the driving force in business these days. Organizations rely on their information resources to make informed decisions regarding all aspects...
Are you aware of these database risks?
Databases are vitally important to modern businesses across all market sectors. They are the repository of an organization’s information...
Why are health checks for SQL Server life savers?
SQL Server health checks have garnered a great deal of notoriety over the last five years. What was originally a niche offering more than ten years...
How can you protect personally identifiable information (PII) in databases?
The data resources of an organization are one of its most valuable assets. Except for its people, the information contained in enterprise databases...
Backups Are Important Because Hackers Never Rest
It’s an aspect of human nature that people tend to ignore repeated warnings that do not manifest themselves into real problems. Letting their...
A Tool for Creating More Efficient SQL Code Quickly
Information technology has become one of the most important manifestations of society’s technological advancements. IT systems are widely used...
What do you need to know about compliance audits?
Compliance audits are an inescapable part of the information technology world we live in. A compliance audit is a detailed review that is conducted...
The Important Role of Compliance Reporting
The way organizations handle sensitive and personal information regarding their customers and employees has radically changed in the last twenty...
Maintaining the Security of Your MySQL Databases
MySQL is the database platform behind many popular websites and applications such as Netflix, YouTube, Facebook, and Twitter. As one of the most...
You Need to Read the Fine Print on Your Software Licenses
Computer technology touches virtually every aspect of our daily lives. We come in contact with computerized systems with such regularity that many...
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...
The Best Practices for Implementing Effective Monitoring
Monitoring is an important activity that is performed in many diverse situations. From healthcare workers to stockbrokers, monitoring the systems on...
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 sports,...
The Use of MySQL in the Scientific Community
MySQL is an extremely popular relational database management system (RDBMS) that is used in many different sectors of business and industry. It is...
Top 7 Reasons for SQL Database Performance Issues and How to Overcome Them
Fine-tuning SQL code is not a one-off effort. It's a recurring task for database administrators (DBAs) as changing conditions can adversely...
Automation is Key to Effective Database DevOps
Modern application development using agile development and DevOps techniques is growing in acceptance across all types of IT environments. The...
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...
Protecting Healthcare Computing Resources in the Pandemic
The COVID-19 pandemic has forced members of society to make many changes in their daily lives. Social distancing, working remotely and wearing masks...
DevOps and Database Design and Change Management
Today's blog post continues my series of posts relating to DevOps and database administration... The DBA is the information technician...
Why You Need to Track Database Changes
Change is a constant that all IT professionals accept as part of the job. There are many different concrete manifestations of the abstract concept...