Blog

Last week I was fortunate to be asked to present during the IDERA Live Event. There were many great presentations and those who attended received a lot of good information. I wanted to post a summary of my presentation here for those that were unable...

Problem Background A business-critical third-party application for Microsoft SQL Server configured the database with generic settings, including general indexes. Such generic parameters are likely going to lead to suboptimal performance and may even ...

As a database administrator and IT professional there are certain technical skills that one is expected to know - but what soft skills are important? Angela Tidwell (@AngelaTidwell) will be leading a community discussion on soft skills for the DBA / ...

Every DBA has at some point asked: “What the heck happened to my database?” In this blog, we’ll review some of the more common scenarios where some little detail slips through the proverbial crack and that often results in some kind...

At IDERA, users drive our product direction. That’s why we have been listening to your needs and have built a roadmap centered around you. In the coming year, we will be hard at work extending our most popular products to support the newest pla...

Precise tests availability, space, deadlocks, backups, jobs, CPU, load and performance trending plus many more conditions on a scheduled basis with defined blackout times.  When there is a problem, Precise sends an email, a message, execute...

If you are a database administrator, then you are no stranger to the idea that data must be highly available. High availability simply helps ensure that business operations continue to run with as little downtime as possible. Over the years...

It’s not uncommon to observe rampant over reliance of database application code on TEMP tables, most often as a SQL language programming crutch. I have a theory as to why. Programmers are chiefly taught record oriented or “record at a tim...

Last week, Idera, Inc. sponsored Enterprise Data World 2018 in San Diego, CA.  As usual, it was a fantastic event, organized by the great team at DATAVERSITY.  I had the privilege of presenting 3 sessions and interacting with many attendees...

Quote: Do not put your faith in what statistics say until you have carefully considered what they do not say.  ~William W. Watt. I started this blog with that quote because I find that database execution plans can sometimes behave very much like...

Imagine that you’re the lead DBA managing a high profile, mission critical production database whose application processes $20 million per hour. The database schema design is complex with approximately 1,000 tables and 1,500 indexes. Moreover t...

You may already know that the cloud provides always-on architecture, automatic monitoring and management, enterprise-class security, fast access to a range of resources, integrated disaster recovery, optimized infrastructure, and simplified IT operat...

When is data less valuable? How do you manage data as it becomes less valuable? In the good old days the answer to these questions was easy; it was simply based on what the company was willing to pay for relatively expensive onsite disk space. So whi...

Idera, Inc. enjoyed participating as a sponsor for this year’s Enterprise Data World event, run by the great folks at DATAVERSITY in San Diego during April 22-27, 2018. We highlighted our flagship data modeling and enterprise architecture suite...

We are pleased to announce the availability of the Aqua Data Studio version 19.0 release.  This release greatly enhances several areas of the product. You can now view explain plans for NoSQL data warehouse platforms, like Hive, Spark and...

Movement to the cloud is in full swing! Regardless of the cloud provider, you will need a migration strategy and the knowledge to make choices unique to your database. Please join us for a community discussion on the Cloud during our next #SQLChat o...

or Collaborative Holistic Tuning of the Application Stack When planning for this blog, I deliberated over the title much more than anyone should ever deliberate over anything.  But I knew the subject I wanted to cover and it spanned a number of ...

This week I had the honor to host the #SQLChat on Twitter on the topic of Data Governance.  Here's some quick highlights from hour long conversation: Q1) How do you define data governance? My response:  Data Governance is a system of decis...

Overview I have been asked multiple times if ER/Studio supports Data Vault Modeling. The answer is yes, ER/Studio does support multiple approaches of data modeling including Data Vault. This article will introduce some key facts behind the Data Vault...

At the moment, Mark Zuckerberg is testifying in front of Congress. Facebook is under the microscope because they allowed an app to take data that they collected and use it in ways that were not in alignment with their company policies. Zuckerberg&nbs...

Hi All, In this blog post we will be going through on how to setting up IDERA's ER/Studio Repository Database Setup in The Google Cloud. In Part 1, we will cover the basics on getting prepared. Here is what we will need. A Google Cloud Account - Tr...

As Relational and Big Data Store databases evolve, so do the responsibilities of the people that support them. Whether you are an Analyst dealing with multiple spreadsheets, crafting different ways of transforming or delivering data; a Developer who ...

Today I’m excited to announce the Idera, Inc. acquisition of Webyog, which represents a major step forward for our Database Tools business. Webyog provides management and monitoring solutions for MySQL databases, and boasts an impressive custom...

We are pleased to announce the general availability of SQL Safe Backup 8.5. Existing users may upgrade to this version through the IDERA Customer Portal. New users may download the trial version from the IDERA website. IDERA SQL Safe Backup provides...

In my 35 years of data modeling many data platforms have come and gone, while others continue to change.  For many, maintaining pace with the frequency of change in data platforms is an ongoing challenge.  For a modeling vendor such as...