Over the past decade or so, cloud providers have steadily expanded their portfolio of offerings. This has complicated the process of migrating...
blog
Why Automation is Mandatory for Database Administrators
One of the promises of technology was that it would make our lives less complicated and afford the average person more free time to pursue the...
Using Data Visualization for More Effective Communication
Enterprise data represent some of an organization’s most valuable assets. Using enterprise data resources productively can spell the...
Make Sure You are Using the Right Kind of SQL Server Backup
All but the most novice SQL Server DBA understands that creating database backups is an important part of their job. A viable backup can be the...
How to Perform Valuable Capacity Planning
Actively performing capacity planning can prove to be a very valuable exercise for growing enterprises. It’s always preferable to be aware of...
Beginning Indexes for SQL Server Performance
Introduction People often characterize indexes as silver bullets for the performance issues in SQL Server. Is it true? Well, yes and no. In this...
Don’t Let Increased GDPR Fines Hurt Your Bottom Line
The European Union’s General Data Protection Regulation (GDPR) was put into effect on May 25, 2018. In the rapidly evolving world of...
Why You Need to Care About SQL Server Fragmentation
DBAs have many responsibilities as the keepers of enterprise data resources. Keeping systems available for their users is one of the big ones....
The Benefits of Consolidating Your Database Support Tools
You will be hard-pressed to locate a database team that is fully satisfied with their level of productivity. Something always seems to demand their...
Identifying Performance Problems Part 2
Performance Monitoring Tools In this second post we are diving into what tools you can use to capture the important performance metrics you need to...
Why Data Modeling Makes Information Resources More Valuable
Enterprise data comprises one of an organization’s most valuable resources. The ability to compete with market rivals is directly impacted by...
Make Sure Your SQL Servers Don’t Get Lost in the Cloud
Moving a computing environment from on-premises data centers to public cloud providers has become a fairly standard activity for many database...
Geek Sync | Automating Database Administration Is No Longer Optional
Data management continues to rise in importance as organizations amass and use more data every year. Combining this avalanche of data with more data...
Announcing General Availability of Aqua Data Studio 21.1
On behalf of the entire Aqua Data Studio team, we’re excited to announce the release of Aqua Data Studio version 21.1 with Enhancements in 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...
Best Practices for Your SQL Server Security
SQL Server security has always been important. Protecting the enterprise data resources stored in SQL Server databases is arguably the prime...
How Secure Are Your MySQL Databases?
Answering this question should be a pretty straightforward exercise for MySQL support teams. In some cases, such as when databases are still in the...
IDERA’s ER/Studio Selected as Best Database Management Software of 2021
We are extremely pleased to announce the inclusion of IDERA’s ER/Studio Data Architect in Digital.com's list of the Best Database...
More Effective Business Intelligence With Data Governance
Data warehouses have had to evolve to maintain pace with the needs of the business community. The individuals who are the customers of the data...
Automating Database Administration is no Longer Optional
Yes, the title of today’s blog post is somewhat provocative, but I think after reading what I have to say that you’ll agree with it....
Top Six Data Modeling Benefits
Data modeling benefits the modern, data-driven organization greatly. It provides organizations with a blueprint and process for planning, creating...
What are the Benefits of Using an IDE?
Database professionals need to perform many different activities in their role of supporting the systems that store and protect enterprise data...
How Data Modeling Benefits Your Business
In today’s data-driven business world, speed is the name of the game. How fast can you derive insights—and drive business results—from all your data...
Geek Sync | 3 Secrets to Improve MySQL Performance
MySQL is a very robust database, but just like any other RDBMS there is an opportunity to improve performance. This session is for all the...