• Install Precise PMDB in an Oracle PDB

    Working in tandem with David’s announcement of Precise version 9.8, here is a one screen how-to. Precise version 9.7 supports installing the Performance Management Database in a PDB. Precise version 9.8 supports monitoring Oracle PDBs. This screen shows the installation path for installing Precise’s historic repository (PMDB) in an Pluggable Database.
    • 10 Nov 2017

    Announcing Precise V9.8.0

    We are pleased to announce the general availability of Precise V9.8.0 Here are some of the highlights: Oracle 12CR2 support on Solaris and Linux Full support for Oracle Multitenant Architecture (Containerized Databases) on Solaris and Linux on Oracle This This is an important area for sales of Precise and we are now perfectly positioned to take advantage of the activity when customers begin their upgrades…
    • 9 Nov 2017

    Meet the IDERA ACE Class of 2018!

    We are excited to introduce our new 2018 IDERA ACEs! This program helps active members of the database and data modeling community share knowledge by sponsoring their travel for speaking engagements and networking opportunities to a variety of SQL and Data Management conferences and events. Members are selected annually and are up-and-coming data professionals who wish to become more active in the community. We are…
    • 31 Oct 2017

    IDERA Presents on SQL Performance and Highlights Product Updates at PASS Summit 2017

    SEATTLE–( BUSINESS WIRE )– IDERA , (a division of Idera, Inc.), a provider of powerful database productivity tools, today announced an SQL Server performance presentation and the 2018 members of its Advisors and Community Educators (ACE) program at the annual PASS Summit 2017, the world’s largest gathering of SQL Server professionals. At IDERA’s PASS Summit booth (#112), the company will feature the following…
    • 25 Oct 2017

    Share Your PASS Summit Experience To Win!

    Are you attending PASS Summit 2017 in Seattle? Mention IDERA on social for your chance to win a YETI ROADIE 20! Attending our Summit after-party? Take a picture of one of our famous IDERA ducks you scored? We want to hear about your Summit experience! Those that tag us in a social mention on either Twitter , Facebook , or Instagram during PASS Summit will automatically be entered to win the YETI. You must be following…
    • 25 Oct 2017

    3 Critical Tasks DBAs Wish They Had More Time to Complete

    People are constantly asking me what to do to make money. My answer is, “I spend time with people who have trouble with SQL Server Performance and I make money by helping them”. Once I admit that I make money by helping people tune their SQL Server, the next set of questions almost always follow. This is how the conversation usually continues… DBA Joe: “Hey Pinal, how do you make money?”…
    • 23 Oct 2017

    Getting Prepared for GDPR

    GDPR goes into effect on May 25, 2018. Anyone who captures personal data for EU members will be subject to meeting these compliance guidelines or risk fines of up to 20 Million Euro or 4% of annual worldwide turnover from your previous year. Recently Sultan Shiffa produced an amazing whitepaper about ” Governing GDPR Challenges with Enterprise Data Architecture “. As I was reading it I started to put together…
    • 22 Oct 2017

    Monitor Apache Cassandra for Performance and Availability

    Are you using Apache Cassandra in your application? You can use IDERA Uptime Cloud Monitor to monitor your Apache Cassandra for availability and performance. As an illustration, you can configure and receive alerts for the following scenari…
    • 22 Oct 2017

    Monitor REDIS for Performance and Availability

    Are you using Redis in your application? You can use IDERA Uptime Cloud Monitor (UCM) to monitor your Redis performance. As an illustration, you can configure and receive alerts for the following scenarios: Performance: alert if the Redis p…
    • 20 Oct 2017

    Using Business Processes for Data Governance

    Business Processes can be a huge asset for you when you are trying to define your Data Governance Policies. While they aren’t specifically a data governance tool they can help you and your organization to identify areas where you should be engaging processes to implement the regulatory guidelines. Some regulatory guidelines (like GDPR which goes into affect May 25, 2018) state that you must define your business processes…
    • 20 Oct 2017

    Database Performance Evolution

    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 the application code and its SQL statements were written by many different developers over the years with varying SQL programming skills. In short it’s your typical DBA…
    • 18 Oct 2017

    HIPAA Compliance for Data Professionals

    While medical facilities are most at risk for a HIPAA violation, most organizations in the United States have to comply with the law and can be hit with civil and criminal penalties. Participate in our next Twitter Chat on November 29 at 11 AM CT with host K. Brian Kelley ( @kbriankelley ) as he leads a community discussion on meeting HIPAA compliance with your databases. What challenges are you having? What can you…
    • 12 Oct 2017

    New Free Tool: SQL Data Profiler

    IDERA released a new free tool, SQL Data Profiler , designed to provide quick visibility into data patterns contained in SQL Server databases. Its intuitive user interface simplifies exploring patterns in data by streamlining and automating the process. Quickly view a summary of the data in selected database tables and columns, and receive recommendations based on the data in the columns. With the free tool, profile…
    • 5 Oct 2017

    Announcing SQL Safe 8.4.2 (patch release) General Availability

    We are pleased to announce the general availability of SQL Safe 8.4.2, IDERA’s premier backup tool. Existing users may upgrade to this version through the IDERA Customer Portal . New users may download the trial version from the IDERA website . This release includes a number of bug fixes, most of which will improve the user experience within the SQL Safe Web Console. For a more detailed list of bug fixes, please…
    • 2 Oct 2017

    Data Governance Questions You Should Be Asking

    October is National Cybersecurity Awareness Month. Many large data breaches have topped news headlines. With all of this great conversation taking place, it’s a perfect opportunity for technical stakeholders and business stakeholders to come together and review their Data Governance Policies. There are 5 Pillars in Data Governance: Data Quality Data Definitions Data Lineage Data Modeling Data Access…
    • 28 Sep 2017

    SQL Workload Analysis 1.6.1 General Availability

    We are pleased to announce the general availability of SQL Workload Analysis 1.6.1. Existing users may upgrade to this version through the Idera Customer Portal . New users may download the trial version from the Idera Website . This release includes the following features: What’s New in Workload Analysis 1.6.1? Top Stored Procedure/Batch Drilldown . Identify which Stored Procedures are consuming the most…
    • 27 Sep 2017

    Automatic Alert Response

    We’d like to know if you’ve automated alert response. Script execution on a particular condition can improve availability and enhance DBA productivity. Click on this blog title “Automatic Alert Response” to take the poll. How To Configure Automatic Alert Response in Precise
    • 26 Sep 2017

    October #SQLChat – Adult Learning

    IT is a fast moving profession. If you aren’t keeping up you are falling behind. Participate in our next #SQLChat on Wednesday, October 18 at 11 AM CT with Kenneth Fisher ( @sqlstudent144 ). Kenneth will be leading a discussion on learning within your career space. What’s the new shiny thing that SQL professionals should be learning? Linux? Python? DevOps? What are your favorite methods of learning? What…
    • 26 Sep 2017

    Announcing the general availability of Uptime Infrastructure Monitor 7.8.3

    IDERA is pleased to announce the general availability of Uptime Infrastructure Monitor 7.8.3 . Existing users may upgrade to this latest version via the online downloads . New users may download the trial version from the IDERA Web…
    • 18 Sep 2017


    It’s that time of year again! IDERA is excited to see everyone at PASS Summit 2017! This year’s summit will take place from November 1 st -3 rd at the Washington State Convention Center in Seattle, Washington. The exhibit hall will be open from Wednesday (November 1) to Friday (November 3). IDERA will be located at booth 112. Come check us out! What to expect this year at the summit: More than 5,000…
    • 5 Sep 2017

    Instantly Access Data in Backup Files to Improve Database Continuity

    SQL Server databases are often repositories for large volumes of business-critical data. As the sizes of databases grow, restore operations become time-consuming. Database professionals need to access data in backup files quickly to reduce recovery time and increase application and business availability. Learn how to instantly access your data in backup files via several conventional and advanced recovery capabilities…
    • 4 Sep 2017

    IDERA ER/Studio Repository Database Setup and Ports – Part 1 – SQL Server

    Howdy! In this latest blog post, I will be covering the Database setup one would need for our IDERA ER/Studio Repository. Pre-requisites: SQL Server 2012-2016 (Standard and Above) SQL Server Configuration Manager Enable TCP Ports The default port is 1433. You may add your custom Port. View Article here.. Enable Repository Ports in your Windows Firewall View Article here.. H ere are the list of ports that…
    • 31 Aug 2017

    How to Tune the Performance of SQL Server, Azure SQL Database and Amazon RDS

    SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance information, analyze it, and determine the resolution in minutes rather than hours. Leverage proven industry best practices endorsed by Most Valuable Professionals (MVPs) to analyze the performance and to provide recommendations. Target some of the most common areas of performance…
    • 30 Aug 2017

    Tell Me A Data Story – Part Two

    Our new 2 minute video, “Tell Me A Data Story – Part Two” tells the story of a growing business that realizes that things are quickly getting out of hand. In the video, we look at how a business can use Business Process Models to identify places where they can have increased growth and data captured. (Please visit the site to view this video) Understanding the Concepts in this Video Business Stakeholders…
    • 30 Aug 2017

    IDERA’s Hurricane Harvey Relief Efforts

    As many of you know, Houston is currently experiencing catastrophic flooding. Houston has a special place in our hearts as it is the home of IDERA Headquarters and many of our employees and valued customers reside there. To help with recovery efforts, we will send you a free “Texas Duck” with a $10 donation made to Houston Pets Alive. And, as a thank you, IDERA has agreed to match donations up to $15,000…