Blog - Post List
  • Updated Free Tool: PowerShell Scripts for SQL Server: Added Center for Internet Security (CIS) Benchmarks

    IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 30 new scripts for Center for Internet Security (CIS) benchmarks. The CIS benchmarks consist of objective, consensus-driven security configuration...
    • 15 Feb 2018
  • Precise for Oracle Has Low Overhead, Impact

    Precise for Oracle can monitor real database performance with incredibly low overhead. In fact, we rarely even use a connection to the database, yet we still gather performance data on a sub-second . How is this possible? For every Oracle instance, t...
    • 14 Feb 2018
  • Valentine's Day (Product Bundles and Pairings)

    Valentine’s Day is a special day to celebrate affection, friendship, and romance. Many people worldwide celebrate Valentine’s Day by showing their appreciation for their loved ones and friends. Some people spend time with a special s...
    • 14 Feb 2018
  • ER/Studio 17.0.2 is available

    We are pleased to announce the general availability (GA) of IDERA ER/Studio 17.0.2 ER/Studio 17.0.2 contains improvements and enhancements in a number of areas within the product suite: Business Architect: Corrected intermittent issues with "...
    • 12 Feb 2018
  • March #SQLChat - GDPR

    Come May 25, 2018, all companies that work with EU data will need to comply with GDPR - this covers about 92% of companies in the US! If you don’t comply, you can be fined up to 2 million euros or up to 4% of your company’s revenue. Join...
    • 8 Feb 2018
  • Automatically migrate databases for DevOps

    Challenge For successful organizations, a critical differentiator is to deliver relevant applications faster and with higher quality with fewer resources is an important differentiator. Consequently, organizations need to improve all parts of the dev...
    • 1 Feb 2018
  • Win a Free Pass to Enterprise Data World 2018 in San Diego, CA!

    Has ER/Studio helped take your data modeling environment to the next level? If so, we want to hear from you! Let us know how ER/Studio has helped you in times of need and you could win a Full Conference Pass to Enterprise Dat...
    • 31 Jan 2018
  • A Year in Review

    As one of the three core pillars in Idera, Inc.’s portfolio that also includes Testing Tools and Developer Tools, our Database Tools business had a big year in 2017. In July, we announced the acquisition AquaFold, significantly expanding our mu...
    • 30 Jan 2018
  • Quickly deliver relevant data to the right people to improve DevOps

    Challenge As the number of projects for developing applications increases, organizations struggle with quality assurance, release management, and infrastructure support. Provisioning an instance of a production database for a development team can tak...
    • 25 Jan 2018
  • How to monitor Always On availability groups

    Always On availability groups are part of an integrated solution with the goal of achieving the highest level of data availability and disaster recovery for organizations. Availability groups grant database administrators the ability to automatically...
    • 22 Jan 2018
  • Precise 9.8.0.1 is available

    Precise 9.8.0.1 has been made generally available. It is an update that can be applied on top of 9.8.0 Precise 9.8.0.1 provide support for Oracle 12CR2 on Windows and AIX. This is in addition to the support for Oracle 12CR2 on Linux and Solaris that ...
    • 18 Jan 2018
  • How to get alert notifications through SMS

    In a number of our products, such as SQL Diagnostic Manager and SQL Safe Backup, there exists a means to configure alert notifications through an email. Despite the fact that just about everyone can read their email on their smart...
    • 17 Jan 2018
  • IDERA Helps You Face the Challenges of Implementing GDPR

    As many companies are coming to realize, the General Data Protection Regulation (GDPR) issued by the EU, which takes effect in May 2018, has a lot of stipulations and guidelines. It is definitely a team effort to follow all the rules and ensure compl...
    • 17 Jan 2018
  • Creating and Using Failover Groups in Azure DBaaS – Part 2

    Connecting to Failover Group So in Part 1 of this series, we created and configured our Failover Group. Well, now that the easy stuff is out of the way, let’s talk about how you connect to these groups via SSMS.  This is where so...
    • 16 Jan 2018
  • Creating and Using Failover Groups in Azure DBaaS – Part 1

    Introduction Hello everybody! One of my favorite features in Azure SQL DBaaS is Failover Groups.  I have been working with these since they were in preview and I cannot stress the value of this feature enough!  In my former company, we had ...
    • 16 Jan 2018
  • Configuring TempDB on Azure IaaS for SQL Server

    Hey everybody! I am asked by clients/team members/friends a lot about how to setup TEMPDB to use the D:\ drive on an Azure VM for SQL Server.  Following the steps listed below is how I configure it on my VM’s. This seems to be the most sta...
    • 16 Jan 2018
  • Using QPI to identify high data usage in Elastic Pool

    So I recently began working on a project for a client that wanted to move from a Premium Elastic Pool to a Standard Elastic Pool due to the costs.  They wanted to know if it was possible, and asked me to provide expert advice and steps to accomp...
    • 16 Jan 2018
  • February #SQLChat - Becoming a Microsoft MVP

    Are you hoping to become a Microsoft MVP? Or, have you already gone through the application process yourself? Then participate in our next Twitter Chat! Our next #SQLChat will take place on Wednesday, February 7th at 11 AM CT with Mindy Curnutt (@sql...
    • 16 Jan 2018
  • Alert Burnout

    Do you routinely ignore alerts?  If you have an email rule that sends alerts to their own folder, that is a hint.  If you find that a day passes without opening this folder, that clinches it.  Do you ignore some alerts and not others?&...
    • 15 Jan 2018
  • Statistics and PowerBI Visualizations, Part Two

    In the previous post, we went over the details of DBCC_SHOW_STATISTICS, now let’s see how this comes together.  We shall run the histogram for the ProductID from the Sales.SalesOrderDetail table.   1 2 3   &nbsp...
    • 15 Jan 2018
  • DB PowerStudio 17.0 Is Now Available

    We are pleased to announce the availability of DB PowerStudio 17.0.  This release greatly enhances the features of the product for SQL Server environments.   It also brings support for SQL Server 2017 while also enhancing support and f...
    • 11 Jan 2018
  • Statistics and PowerBI Visualizations, Part One

    In this article, we are going to discuss how SQL Server uses statistics.  Differences between how 2016 and older versions use statistics for the optimizer.  In the end, we will review the PowerBI report that Patrick LeBlanc designed.
    • 9 Jan 2018
  • New Discovery and Tuning Suite Now Available

    We are pleased to announce the availability of a new suite of performance products packaged to fill the core needs of most SQL Server DBAs. Discovery and Tuning Suite includes products to measure and optimize SQL Server performance for your critical ...
    • 8 Jan 2018
  • National Rubber Ducky Day 2018!

    Our favorite holiday is almost here! National Rubber Ducky Day is Saturday, January 13. To help celebrate this holiday we are sending you our newest Mardi Gras duck for free! Our Twitter followers who post a picture of their favorite IDERA duck, tag...
    • 8 Jan 2018
  • Creating a Basic PowerShell Function

    In my last blog, I wrote about how to create a PowerShell module. Now, it's time to learn how to write a basic PowerShell function to put in that module. We are going to keep the functionality of this function very simple, and just writ...
    • 7 Jan 2018