Blog - Post List
  • 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
  • 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 DBATools.io 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 zoe.bell@idera.com will receive a prize!

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

    • 29 Nov 2017