Blog

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...

It’s that time of year again! We invite you to join us for IDERA Live, our second-annual Virtual Conference, designed to educate and inform users of any level in a fun, engaging atmosphere. We’ve gathered some of the industry’s top...

The Precise solution gathers a lot of information across all tiers of web-based applications, as well as database activity. This data is stored in the Performance Management Database (PMDB) with a three-year history. It is often useful to pull data o...

Precise’s historic repository, the Performance Management Database (PMDB) holds up to a three-year history of performance data by default. The data is stored in different tables representing different time periods, and it is worth understanding...

World Backup Day This year, World Backup Day is on Saturday, March 31, 2018. Per my blog post from last year “Guidelines for Backup and Recovery of Databases”: “World Backup Day is a day for everyone to learn about the increasing ro...

Nearly every month there is another announcement about a company disclosing a data breach in which sensitive customer data was exposed. Last week, it was Orbitz announcing that an outdated site for a business partner was hacked, and the exposed infor...

We are pleased to announce the General Availability of DB Optimizer 17.0.1 This release greatly enhances the features of the product for SQL Server environments.    We enlisted a Microsoft Data Platform MVP to determine the top SQL Ser...

Data Governance is essential for companies working in highly regulated industries and it is important for organizations to review their Data Governance policies on a regular basis. Please join us for our next #SQLChat on Wednesday, April 18 at 11 AM...

 If you suspected the title of this blog is click-bait, then you would be correct.  But bear with me anyway on a little retrospection of the relational database market, where it has been, and where I think it is going to end. What is an RDB...

Our product management team at IDERA recently polled a sample of our customer base and asked them to tell us what is the most important technology they want to learn about in 2018. This question is interesting because what DBAs most want to learn abo...

SQL Safe Backup offers a number of different ways to initiate a backup/restore operation. Operations can be initiated from the SQL Safe Management Console, the SQL Safe Backup Web Console, the SQL Safe Backup Command Line Interface (CLI), and the SQL...

We are pleased to announce the general availability of SQL Doctor 3.7. 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 Doctor is your one-stop s...

We have heard a number of our DBA customers ask for reporting of SQL Inventory Manager data for a number of reasons - (be able to provide executive reporting, determine the state of environment and make better informed decisions about the SQL server...

In recent years, there has been a re-awakening, with organizations recognizing the importance of data not only as an operational imperative, but also as a strategic asset.  However, managing and harnessing the power of data is becoming increasin...

The Precise Application Performance Platform measures end-users transactions from “click to disk”.  If the most resources are consumed within the .NET tier, that would warrant a deeper investigation.  Let’s take a look.&nb...

SQL Diagnostic Manager is a robust performance monitoring, alerting and diagnostics solution for SQL Server. It proactively notifies of health, performance, and availability problems via a desktop console, a web console add-on, and mobile device. It ...

Howdy! Again! Check out my top 5 SQL Server Videos in 2017 1) Everything you need to know about SQL Server 2017 www.youtube.com/watch 2)  Database DevOps for .NET Developers with SSDT and SQL Server 2017 www.youtube.com/watch  3) &...

We are pleased to announce the general availability of SQL Defrag Manager 3.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 Defrag Manager i...