Best Practices for Deployment of SQL Compliance Manager

So maybe you downloaded a trial of SQL Compliance Manager and want to play around with it. Or perhaps you already purchased licenses and want to deploy and setup the tool on your SQL Servers. Either way you can always use some help to really configure the product the...

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, snapshot, detach, and delete those unused EBS volumes. Identify It is important to identify if your EBS volumes are currently...

Counter calculations in SQL Diagnostic Manager

Probably the three most common questions I get about counters in SQL Diagnostic Manager are: “How can I prevent alerting on temporary noise values?”“How does collecting once every 6 minutes give enough data for alerting?”and, the big one“Why is SQLdm showing me...

Most Popular FAQs for SQL Doctor

SQL Doctor is one of the most popular products in the Idera portfolio and as such we get a variety of questions from users on how it works, where do the recommendations come from, etc. We picked out some of the more common questions that have been asked that perhaps...

New SQLyog and MONyog coming – please upgrade soon!

We are about to release upgrades to both SQLyog and MONyog with an important fix: linked libraries possibly vulnerable to the 'Heartbleed' OpenSSL bug have been upgraded to non-affected versions (the new MONyog release will have a few more fixes as well)....

Delphi (C++Builder) Android Mobile Client DataSnap Server

Delphi (C++Builder) Android Mobile Client DataSnap Server

Преамбула DataSnap – платформа создания многозвенных приложений. Её история достаточно продолжительна, начиная с совсем ранних версий Delphi. Роль и значимость этой технологии/платформы изменялась в течение эволюции Delphi/C++Builder/RAD Studio, но сейчас есть ряд...

Lazy Form Creation Design Pattern

Lazy Form Creation Design Pattern

One of the most important things about any application, and especially mobile apps, is short start-up time. End user does not like to wait for too long for an app to start. In some cases, if the start-up time is excessively long a mobile app may not be accepted into...

Deep Dive: SQL Diagnostic Manager Availability Checks

Deep Dive: SQL Diagnostic Manager Availability Checks

One of the frequent questions I get about SQL Diagnostic Manager pertains to one of the most fundamental features of the product – exactly how is server downtime detected? This is usually answered with relatively straightforward explanations about running test queries...

Some suggestions

Hi, I think it may be useful in SQL Defrag: 1. To see index script when I see the fragmentation of this index. Now I need to use another tool to do it. 2. Databases refresh (button?) 3. Now SQL Defrag is SDI, but sometimes I need to see the state of 2 databases in the...