I often run into situations where DBAs are having discussions with their Storage Administrator around not compressing database backups so that they...
posts
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
2017: A New Year with new projects?
2017: A New Year with new projects? I’m not big into new year’s resolutions. Too often they are just words that we never act on. When...
Storage Performance Optimization, I/O Efficiency
Over time, the blocks in a relational database will typically contain fewer and fewer rows of data making each I/O operation less efficient. ...
Run Book, Run!!!
How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains how to execute all your jobs and...
How Do You Create a Disaster Recovery Plan?
Get 2017 on a healthy start and participate in our January #SQLChat! Our next Twitter Chat will take place Wednesday, January 11th at 11 AM CT with...
DB2 Monitoring and Optimization – Index Recommendations & Modeling
This blog post explores a strategy for improving processing efficiency within IBM’s DB2 on LUW. The Precise product line is designed for...
Explore PowerShell with Maximo Trinidad and WIN!
Our December #SQLChat will take place Thursday, December 8 at 11 AM CT with Maximo Trinidad (@MaxTrinidad). Maximo will lead a conversation on...
TOP IT HORROR STORIES AND HOW TO SURVIVE THEM
Tis the season for spooks and spoils so to get in the spirit here is a cauldron of scary, strange and sometimes humorous tales gathered from the...
Must Have DBA Resource: 5 Costly DBA Mistakes
We've has published many popular white papers that have become the go-to guide on best practices and insider reports for database...
Index Insanity: How to Avoid Database Chaos
Index Insanity: How to Avoid Database Chaos In early October, Oracle ACE and IDERA senior product manager Bert Scalzo joined Dr. Robin Bloor and Dez...
Product Beauty is in the Eye of the Beholder
I'm sure you have all heard the phrase "Beauty is in the Eye of the Beholder". It's something we learn when we are young, that...
Why Be Normal?
Being normal may not seem like much fun; I wore a “Why Be Normal?” button with pride throughout college. And I did it out of choice rather than as...
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...
How to Become Smarter Than the Average Bear
People sometimes ask me why the avatar that I often use is Yogi Bear. Well, it’s because Yogi is famous for the phrase...
The Art of Visibility: Enabling Multi-Platform Database Management
Scott Walz of IDERA joined Dr. Robin Bloor and Dez Blanchfield of The Bloor Group on the recent webinar, The Art of Visibility: Enabling...
Challenge Accepted
My life for the last 2 years has been a constant battle of putting out fires with system performance; finally user complaints have moved getting...
How Monyog helped CloudMagic detect an RDS issue within seconds
CloudMagic is an email app for iOS, Android and MacOS with over 4 million downloads. CloudMagic has catered to email users across the globe with...
The Role of DBA in Data Protection
IDERA recently released a Database Management Report Survey with interesting industry trends such as “nearly 90% of enterprise IT respondents...
How did Monyog help Moodlerooms deliver a unified experience for their key clients?
There is a growing culture of impatience in today’s fast-paced world. The demand for instant results means that most users cannot tolerate...
5 Database Reports In SQL Server Management Tools
When connecting to a SQL Server instance in SQL Server Management Studio, there are built in reports for databases you can use for free. These RDL...
This Idera ACE Has Been Busy
This year has been a whirlwind so far, thanks to the Idera ACE program. For those that don’t know what that is … What is an Idera ACE? (According to...
Do you Manage Multiple Servers? Participate in our September #SQLChat!
Our next #SQLChat will take place Wednesday, September 7th at 11 AM CT with K. Brian Kelley (@kbriankelley). Corresponding with Brian’s...
Why Netflix decided to migrate to AWS?
Netflix recently published an article describing the completion of billing migration to Amazon Web Services. More than half of the services...
Why Uber migrated its databases from Postgres to MySQL?
Uber has been in the news for numerous reasons in the past few days. Be it expansion to new countries or selling its China operations to Didi...
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...
Happy System Administrator Appreciation Day! Participate and Win a Roku Streaming Stick!
Friday, July 29 is National System Administrator Appreciation Day! IDERA wants to thank and recognize System Admins and other IT workers for their...
Using a Lookup Component in SSIS for Surrogate Keys in a Fact table
There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you find a pattern to...
Decoded: A Day in the Life of a Database Administrator
Companies know they need a database administrator, but they probably don't have any clue about what they actually do. The primary duty for a...
What it takes to make Pokémon GO a reality
People, the world over, have been awed by the launch of Pokémon Go. The game has brought nostalgia, curiosity, and a unique gaming experience to...
August #SQLChat – Participate and Win a $100 Amazon Gift Card!
Our next #SQLChat will take place Wednesday, August 17 at 11 AM CT with Pinal Dave (@pinaldave). Pinal will lead a conversation discussing...