Blog - Post List
  • How to monitor tempdb databases

    Introduction The tempdb system database is a workspace used to hold temporary user objects, results created through queries and sorts, and other objects created by the SQL Server Database Engine. Because of the significant amount of data stored ...
    • 5 Jan 2018
  • How to plan future capacity

    Capacity planning, especially when done for Microsoft SQL Server, is not for the faint of heart. Storage and disk capacity are apparent, but to right-size databases for a new SQL Server implementation or migration, there is a lot more than space to c...
    • 5 Jan 2018
  • How to monitor and diagnose SQL query performance

    Executing resource-intensive SQL queries requires a significant amount of processor time, memory, and bandwidth, and storage. Resource-intensive SQL queries prevent other SQL queries from using these resources. This can eventually lead to blocking. C...
    • 5 Jan 2018
  • Troubleshooting Common Cloud Database Connectivity Issues

    Howdy! And wishing Y'all a Very Happy and Prosperous 2018!  In this very first blog of 2018, I'm excited to be writing this series on troubleshooting common Cloud database connectivity issues. The goal is to provide useful quick hyperl...
    • 1 Jan 2018
  • Balancing Data and Processes to Achieve Organizational Maturity

    On December 19th, 2017, Ron Huizenga presented a DATAVERSITY webinar on the importance of organizational maturity. His experience with manufacturing flows and Six Sigma standards provides him with a unique perspective, which is enhanced by his years ...
    • 22 Dec 2017
  • Creating a Custom PowerShell Module and Saving a Function

    My first time creating a PowerShell module I copied a folder structure and some files from the way set up their module.  But Rob Sewell (b | t) has shown me a better way and that is to use Plaster. In this article, we will walk ...
    • 16 Dec 2017
  • January #SQLChat: SQL Server New Year Resolutions - Breaking SQL Bad Habits for 2018

    The New Year is almost here! Have you made any resolutions for 2018? Participate in our next #SQLChat on Wednesday, January 3rd at 11 AM CT with Monica Rathbun (@SQLEspresso). Monica will be leading a conversation on SQL Server Bad Habits in Configu...
    • 12 Dec 2017
  • Announcing SQL Comparison Toolset 7.5

    We are pleased to announce the general availability of SQL Comparison Toolset 7.5. Existing users may upgrade to this version through the IDERA Customer Portal. New users may download the trial version from the IDERA website. The 7.5 Version of SQL C...
    • 12 Dec 2017
  • Diversity within Tech - Community Findings

    Diversity is a huge topic of discussion, especially as of late. Rie Irish (@IrishSQL) partnered with the PASS Women in Technology (WIT) Virtual Group (@PASS_WIT) for our latest #SQLChat. They discussed ways to increase diversity in tech and attract ...
    • 7 Dec 2017
  • Looking towards 2018 - GDPR Impact

    As 2018 quickly approaches, we have a good opportunity to look towards the future.  GDPR will go into effect in May and with it we should see some significant changes in how companies handle their data.   GDPR will affect more than Europe ...
    • 4 Dec 2017
  • When is your data safe?

    This blog title may seem a little odd at first. Then again today's news is rife with stories about data breaches, therefore on second thought it's not as odd a title as you may have initially thought. So when is your data actually safe? Since almost ...
    • 4 Dec 2017
  • Download and Complete our SQL Server Crossword!

    This fun puzzle, created by Kenneth Fisher, is primarily focused on SQL Server but also includes some IDERA terms. Up for the challenge? Download the PDF below and complete the crossword yourself.

    The first three participants to successfully send a picture of their completed crossword to will receive a prize!

    About the Creator: Kenneth Fisher has worked with databases of one flavor or another for…

    • 29 Nov 2017
  • Alert Configuration Templates in SQL Diagnostic Manager

    Several versions ago, SQL Diagnostic Manager (SQLDM) introduced Alert Configuration Templates, which basically allowed users to preconfigure alert settings (metrics which are to be alerted upon and the thresholds set for those metrics). This was a great addition to SQL Diagnostic Manager at the time as it allowed users to apply the alert settings to one or more monitored SQL Server instances with a few simple clicks. Without…

    • 28 Nov 2017
  • December #SQLChat - A Discussion on Diversity in Tech with WIT

    A lot of emphasis has been placed on diversity in tech of late, with good reason. Research has shown that a more diverse team finds more innovative ways to solve problems and build better products.   Women aren't entering tech at the same rates as men but are leaving the field almost twice as fast.  Other minorities are underrepresented in all steps of the hiring process.

    Studies indicate that men will apply for a job…

    • 20 Nov 2017
  • Top 12 Tips for Safe Online Shopping on Black Friday

    Online shopping has become a popular way to purchase items without the hassles of traffic and crowds. Online shopping offers convenience and comfort not available from other shopping outlets. From the comfort of your home, you can search for items fr...
    • 17 Nov 2017
  • Updated Free Tool: PowerShell Scripts for SQL Server

    IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release supports SQL Server 2016 and 2017, and Windows Server 2016. The update features 13 new scripts (four for SQL Server 2017, eight for security, and one for aliases) and seven updated scripts to support SQL Server 2017.

    The free tool now contains 102 sample scripts that demonstrate various techniques for gathering and managing SQL Server…

    • 16 Nov 2017
  • The SQL Song That’s About to Hit The Billboard Hot 100 Chart

    Homer McEwen, aka Killa DBA, has always loved music – from his early years in the church choir to today's gigs as a singer and songwriter. After two decades in IT working as a DBA, he decided to combine his passion for music and technology and start making songs about the ever-changing world of databases, bits, bytes, and coding.

    Killa DBA did us the honor of creating his very own IDERA Rap, and performing it…

    • 15 Nov 2017
  • Monitor Azure Accounts with Uptime Cloud Monitor

    Is Azure cloud part of your infrastructure? You can use IDERA Uptime Cloud Monitor to monitor your Azure cloud resources. As of today, we support monitoring for Azure Virtual Machines, Azure MSSQL, Azure database for MySQL and Azure database for PostgreSQL.


    Uptime Cloud Monitor from IDERA offers a SAAS based out-of-the-box solution for monitoring Azure resources for performance and availability. You need…

    • 15 Nov 2017
  • 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.

    • 14 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…

    • 10 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 looking…

    • 9 Nov 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 tools…

    • 31 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?”…

    • 25 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…

    • 23 Oct 2017