IDERA Archives

How to Ensure That Databases Are Backed Up On a Regular Basis

Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases....

How to Analyze the Health of Database Indexes

by Peter

To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases. For this purpose,...

How to Migrate Databases and Data Files

by Peter

Do you need to: Move databases from one instance to another (for example, to move a performance-intensive database to a faster hard drive to...

How to Ensure that Databases Do Not Have Fragmented Indexes

by Peter

Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes. View the fragmentation...

Logical to Physical Data Modeling

by Anil M

In the last article we learned how to create a data model from scratch using ER/Studio Data Architect. In part II we will explore about how to...

Become an IDERA ACE Today!

by Former Member

Applications for the 2017 IDERA ACEs are now open! The search has begun for the 2017 IDERA ACEs. Do you have a passion in helping the community and...

Setting up an Apache Web Server in Debian using Google Cloud

by Anil M

Setting up an Apache Web Server in Debian using Google Cloud Howdy! In the...

Fireproof Your DBA Career in our Next Twitter Chat!

by Former Member

Is your DBA career fireproof? Let’s discuss the things that can get you fired and make sure you’re not doing them. Our next #SQLChat...

What is BPMN?

by Kim Brushaber

IDERA's ER/Studio Business Architect allows you to draw both Conceptual Models and Business Process Models. Business Process Models use...

Join the Team – Talk Back

by Scott Stone

Those of you who have endured a product roadmap session with me know that the insight into our direction comes with a price. That price is me...

Getting the Most from Your Software Vendor

by Scott Stone

This topic is relevant to more than just Idera and it comes from experience working for and with multiple software vendors in multiple...

History of the IDERA Duck

by Former Member

We know what you’re all thinking - what’s the deal with the Rubber Ducks? If you’ve attended a conference we've sponsored, or...

How Do You Approach a Performance Problem?

by Former Member

We all see performance problems on a regular basis. Some look to hardware first, some look to logical design. We all turn to IDERA and other tools....

Discover 10 Lesser-known Capabilities of SQL Diagnostic Manager

by Peter

Introduction This blog post describes ten lesser-known features of SQL Diagnostic Manager with links to short how-to videos and additional...

May the 4th Be With You!

by Former Member

Do. Or do not. There is no try. May the 4th is National Star Wars Day and IDERA is excited to celebrate. Keep your database universe Safe with the...

Attend our Virtual Conference to Win Big!

by Former Member

Be a part of history and attend IDERA’s first Virtual Conference! IDERA Live is our first Virtual Conference designed to educate and inform...

Combine PowerShell and SQL Diagnostic Manager to Automate SQL Server Monitoring

by Peter

Run new and existing PowerShell scripts with SQL Diagnostic Manager and utilize the vast power of PowerShell via the customizable monitoring...

Why Should A Data Modeler Care About Business Processes?

by Kim Brushaber

Data Modelers are responsible for creating and maintaining conceptual, logical and physical data models. These data models are used to define...

What are Business Processes??

by Kim Brushaber

Business Processes are a set of tasks or activities that help an organization to define and communicate their goals, optimize their...

Is your SQL drawing a blank? It’s NULL a surprise!

by Ron Huizenga

The title of this post is a play on words, but very appropriate. We are going to discuss the inconsistent results, as well as performance...

April #SQLChat Findings

by Former Member

Jim Donahoe (@SQLFlipFlopsDBA ) hosted a #SQLChat on Wednesday, April 5 over Career Satisfaction within the SQL Space. This was a busy conversation...