On May 25th, 2018, GDPR (General Data Protection Regulation) went into effect. This regulation affects anyone who collects PII (Personally...
SQL Server
Announcing ER/Studio 17.1 General Availability
We are pleased to announce the general availability (GA) of IDERA ER/Studio 17.1 ER/Studio 17.1 contains improvements and enhancements in a number...
August #SQLChat – SQL Server Coding Standards
Designing and managing databases can be a daunting tasks. However, defining database coding standards can help keep everything in order. Join IDERA...
Updated Free Tool: PowerShell Scripts for SQL Server 6.0: Added Scripts for Microsoft Azure SQL Database
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 15 new scripts for Microsoft Azure SQL...
Database Performance History
Servers are moving from on-prem to the cloud. Applications are upgraded, so are operating systems, databases, and hardware. New users,...
Changing Lanes: Part II. Shifting between Relational and Big Data Platforms
In the last blog, I covered Shifting Roles with Relational and Big Data Platforms and how that is affecting the people and their roles within...
Announcing Precise 9.9 General Availability
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...
How To Improve a Business-critical Third-party Application by Optimizing Its Generic Database Settings
Problem Background A business-critical third-party application for Microsoft SQL Server configured the database with generic settings, including...
IDERA Database Tools roadmap for DBAs, database developers and data architects
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...
Database Execution Plans Can Lie
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...
The Evolution of Database Tuning Approaches
Imagine that you’re the lead DBA managing a high profile, mission critical production database whose application processes $20 million per...
Managing Mountains of Data with the Cloud
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...
Database Needs in The Cloud – May #SQLChat
Movement to the cloud is in full swing! Regardless of the cloud provider, you will need a migration strategy and the knowledge to make choices...
Setting up ER/Studio in the Google Cloud Platform – Part I – Setup
Hi All, In this blog post we will be going through on how to setting up IDERA's ER/Studio Repository Database Setup in The Google Cloud. In Part...
Free Virtual Conference! IDERA Live 2018
It’s that time of year again! We invite you to join us for IDERA Live, our second-annual Virtual Conference, designed to educate and inform...
Dealing with Database Security
Nearly every month there is another announcement about a company disclosing a data breach in which sensitive customer data was exposed. Last week,...
Announcing the General Availability of DB Optimizer 17.0.1
We are pleased to announce the General Availability of DB Optimizer 17.0.1 This release greatly enhances the features of the product for SQL Server...
What’s the most important thing SQL Server DBAs want to learn in 2018?
Our product management team at IDERA recently polled a sample of our customer base and asked them to tell us what is the most important technology...
Updated Free Tool: PowerShell Scripts for SQL Server 5.0: 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...
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...
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...
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...
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...
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...