SQL Server Archives

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

by Bert Scalzo

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

by Bert Scalzo

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

by Former Member

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

by Anil M

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

by Former Member

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

by Joy Ruff

Nearly every month there is another announcement about a company disclosing a data breach in which sensitive customer data was exposed. Last week,...

What’s the most important thing SQL Server DBAs want to learn in 2018?

by Robert Anderson

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...

Five Important Features of SQL Diagnostic Manager

by Peter

SQL Diagnostic Manager is a robust performance monitoring, alerting and diagnostics solution for SQL Server. It proactively notifies of health,...

Updated Free Tool: PowerShell Scripts for SQL Server 5.0: Added Center for Internet Security (CIS) Benchmarks

by Peter

IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 30 new scripts for Center for Internet Security...

IDERA Helps You Face the Challenges of Implementing GDPR

by Joy Ruff

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

by Jim Donahoe

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

by Jim Donahoe

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

by Former Member

Are you hoping to become a Microsoft MVP? Or, have you already gone through the application process yourself? Then participate in our next Twitter...

New Discovery and Tuning Suite Now Available

by Scott Stone

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....

How to monitor tempdb databases

by Peter

Introduction The tempdb system database is a workspace used to hold temporary user objects, results created through queries and sorts, and other...

How to plan future capacity

by Peter

Capacity planning, especially when done for Microsoft SQL Server, is not for the faint of heart. Storage and disk capacity are apparent, but to...

How to monitor and diagnose SQL query performance

by Peter

Executing resource-intensive SQL queries requires a significant amount of processor time, memory, and bandwidth, and storage. Resource-intensive SQL...