Blog

Howdy! Ever considered or wanted to know how Data would move around the organization? Data Lineage is a key driver that ensures on connecting the right dots with the business and its sources. According to Technopedia: "Definition - What does Da...

Database administrators need to handle all facets of managing Microsoft SQL Server ranging from installation and patching to creating databases to managing permissions that allow users to use the databases. However, more than anything, they are respo...

We’re excited to announce the release of SQL Compliance Manager 5.5 SQL Compliance Manager is a comprehensive database auditing solution that monitors and tracks changes to SQL Server objects and data, and sends alerts on suspicious activity. ...

Microsoft’s Windows PowerShell is a task-based command-line shell and scripting language. It is an automation platform and scripting language that simplifies the management of Windows environments. It is designed primarily for system admin...

“The DBA is dying” has been a common concept for at least 15 - 20 years. What makes this time period different? Join IDERA (@Idera_Software) and host Kenneth Fisher (@sqlstudent144) on Wednesday, July 25 at 11 AM CT for a community discu...

Howdy! Introduction: In this blog post, we will show you how easy it is to connect to MySQL and PostgreSQL via ODBC. As you are aware we can reverse engineer databases natively with  SQL Server  Oracle Hive Sybase ASE Azure SQLDB and Mongo...

In today's economy it is imperative that database developers work smarter, not harder, to meet the demands put on them by line of business owners, senior management, and the company as a whole. Due to time, money, and resource limitations it is often...

We are excited to welcome the AquaCluster users to the IDERA Community! As you know, IDERA acquired AquaFold in July 2017, and we are committed to the continued success of AquaFold and its products. As a member of our IDERA community, AquaCluster us...

When looking at a database to improve performance, I look at three types of tuning; statement, object, and instance. I want to walk you through some of the tools and features available within the Precise for Database solution that can help you identi...

Industry leading organizations recognize and manage data as a strategic asset. By ensuring high data quality, they are able to rely upon data for critical decision making. Business intelligence and analytics spending has been increasing dramatically ...

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

Precise 9.9 is now generally available. This is a brand new version of Precise and heralds a change for us with the Precise AdminPoint being developed on a new UI framework. Precise 9.9 also provides support for the following: MS-Azure support Amazon...

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