We've has published many popular white papers that have become the go-to guide on best practices and insider reports for database...
Must Have DBA Resource: 5 Costly DBA Mistakes
read more
Liz Stephens
IDERA Announces Rapid Database Extractor Free Tool
We’ve recently released our latest free tool which is the first in the database development portfolio. With this new release, we now have 23...
Welcoming a New Free Tool: SQL Query Store Optimizer
We are excited to announce the release of a new free tool, SQL Query Store Optimizer, designed to help you improve the performance of SQL...
Database Lifecycle Management 2016 Survey
At IDERA, we believe data is king: how you use data, how your organizations use data, and how the world uses data. So, we set out on a journey to...
Join IDERA at the Annual SSWUG Spring Virtual Conference
We are pleased to be a part of this year’s virtual SSWUG conference taking place April 28-29. There is a rockstar lineup of presenters which...
January #SQLChat Wrap-Up
A new year means new beginnings! And, what a better way to celebrate than with a Twitter Chat centered around SQL Server and starting a new job....
National Rubber Ducky Day
What does IDERA love as much as our customers? Rubber Ducks! National Rubber Ducky Day is Wednesday, January 13. To help celebrate this holiday we...
Join us in Welcoming Embarcadero’s Customers and Partners
We recently announced our acquisition of Embarcadero Technologies. This week, IDERA CEO Randy Jacops sent a letter to Embarcadero’s customers and...
The Data Warehouse of the Future Using Microsoft SQL Server
The data landscape has changed considerably since Kimball first proposed the dimensional approach to building a data warehouse schema. Over the last...
IDERA Welcomes Embarcadero
This is an exciting day for us as we welcome Embarcadero into the Idera family. Embarcadero’s award-winning software tools help application...
Service Broker Gone Wild: Dealing With sysxmitqueue Bloat
Have you ever been surprised by suddenly finding out that one of your databases has grown way beyond your expectations? Hopefully, this isn’t...
Monitoring Disk Queue Length
Recently, I wrote a blog post about performance counters and why the threshold depends (Performance Counters: Why It Depends). In this post, I...
AWS cost saving tip: Delete unused EBS volumes
Organizing EBS volumes and deleting detached volumes on a regular basis to can help decrease AWS spend. See how easy it is to identify, tag,...
Is Your SQL Server Slow? Maybe It’s Trying Too Hard
The following is a guest post by Microsoft Certified Master Robert L Davis. Find more from him at SQLSoldier.com, and follow him on twitter...
Five Must-Have Tools For DBA’s
SQL Diagnostic Manager SQL diagnostic manager is a full, feature-rich monitoring solution for your SQL Server and virtualization platform with...
The Cheat-Sheet on SharePoint’s Distributed Cache
I was in Indiana this past weekend at SharePoint Saturday Indianapolis, and one of the presentations I delivered at the event was a favorite of...
Enabling High Performance Power Plan via Command Line
Hopefully, everyone knows by now that the default power plan in Windows 2008+ is “balanced” which can result in your CPUs being throttled down to...
Configure SQL diagnostic manager for non-standard ports
SQL Server uses the port 1433 as its standard listening port. Hackers know this and will use it to more easily hack into your SQL...
Why Back Up the Transaction Log if not Interested in Point-in-time Restore?
I’ve heard people say many times that they don’t use full or bulk-logged recovery model or backup the transaction log of their database...
Make Your PowerShell Scripts Click-runnable
If you are like me, you hate having to type in the full path to a PowerShell script to run it.Wouldn’t it be nice if you could just execute...
Is Using RECONFIGURE WITH OVERRIDE dangerous?
One of my pet peeves is the use of RECONFIGURE WITH OVERRIDE in scripts to change server options. Am I being unreasonable or is this justified? All...
Increase SQL Server Performance Using Multiple Files
By default, SQL Server databases are comprised of two files: the primary data file (or .mdf) and the log file (or .ldf). It is, however, possible to...
Getting the Permissions Wired-Up Properly When Attaching a Content Database to a SharePoint Farm
You’ve probably heard the latest news in the SharePoint world: SharePoint 2013 has been released to manufacturing (RTM)! We’ve been told...
Okay, Really – What Can I Do with a SharePoint Farm Configuration Database Backup?
I’ll cut straight to the chase: no, a configuration database backpastedimage1478188484999v3.pngup is not just a fancy paperweight. The prevailing...