Getting Proactive with Performance: Leveraging Prescriptive Analysis in IDERA’s SQL Diagnostic Manager
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
New plugin for hard disk SMART monitoring
Ever wonder if your hard drive was trying to tell you something? Well, it just might be. S.M.A.R.T. has been around forever it seems but it largely goes unnoticed or ignored. No longer. Well, speaking of going unnoticed, I created this plugin a while ago and never got...
Smell Like Flowers With Ducky Indices
B-tree indices in Oracle are powerful. Sometimes a very good index can be even better. Precise for Oracle helps DBAs recognize this situation. This screen excerpt (please click on it to enlarge) from Precise for Oracle identifies that 20% of execution time...
Optimal Oracle Index Performance
B-tree indices in Oracle are powerful. Sometimes a very good index can be even better. Precise for Oracle helps DBAs recognize this situation. This screen excerpt (please click on it to enlarge) from Precise for Oracle identifies that 20% of execution time is spent...
Customized Solutions Using SQL Safe Backup’s XSPs
During my days as a Technical Support Engineer here at IDERA, I’d occasionally encounter a customer trying to do something that’s not directly available in the SQL Safe Management Console and/or the SQL Safe Web Console. Some of these things that were possible through...
Video: Adding InterBase 2017 ToGo to RAD Studio 10.2
InterBase 2017 is now available for installation directly into RAD Studio via GetIt for use in Delphi and C++Builder applications across Windows, macOS, iOS, Android and also for Linux. While a Linux InterBase Server Edition has been available for many years with...
Dashboards
Precise's historic repository is available for trend reporting, dashboards, and analysis. On Precise's Application screen, in the top right corner, select More, then Precise Custom Portal. Precise dashboards offer essential functionality for sharing information with...
Webinar series – A step-by-step process to optimize MySQL database performance
Hope you have been following our recent webinars on MySQL, Galera Cluster, AWS monitoring and more. We are coming up with a webinar series in association with Eric Vanier, a leading MySQL expert consultant. The series will provide a step-by-step process to optimize...
Delphi Linux и создание серверных приложений – постскриптум
8 июня прошел первый вебинар Embarcadero, на котором мы начали знакомить с возможностями Delphi for Linux из RAD Studio 10.2. Запланированного практического материала было так много, что мы не успели рассмотреть один из важных вопросов. Договорились рассмотреть его на...
Save Time With This Quick LiveBindings Trick For Delphi And C++Builder
LiveBindings is a great technology built into Delphi and C++Builder for bypassing most of the code involved in a CRUD data cycle (Create, Read, Update and Delete Cycle). It can keep you out of massive amounts of technical debt. However, sometimes the...
Join the Team – Talk Back
Those of you who have endured a product roadmap session with me know that the insight into our direction comes with a price. That price is me badgering you about your own plans and priorities, how you plan to use any suggestions you make, whether you agree with our...
Getting the Most from Your Software Vendor
This topic is relevant to more than just Idera and it comes from experience working for and with multiple software vendors in multiple industries. The simple realization is that certain customers seem to know how to gain advantages beyond the purchases and...
Modeling Graph Data Stores in ER/Studio
Modeling Background Enterprise data environments have become increasingly complex due to a proliferation of different technologies and data platforms. A given organization may have hundreds of different data stores including multiple relational database...
FireDAC & ODBC for Paradox and dBase tables.
I continue to get customer requests for options to migrate legacy RAD Studio, Delphi or C++ Builder applications using the Borland Database Engine (BDE) with Paradox and/or dBase files. With the current versions of RAD...
History of the IDERA Duck
We know what you’re all thinking - what’s the deal with the Rubber Ducks? If you’ve attended a conference we've sponsored, or downloaded a trial off an IDERA email blast, chances are you’ve received an IDERA duck in the mail. ...
A Simple Test (for geographically distributed systems)
Here is a simple test that might save you a lot of heartache. If Oracle is a long distance from the application server, open SQLplus, set timing on, and run a select. Do this locally where the database runs and from the application server. Great...
Bad Index – use Clustering Factor to determine when a range scan is expensive
Oracle's Optimizer attempts to pick the most efficient plan for resolving a SQL statement. Most of the time, it succeeds and execution time is fast. Sometimes, it doesn't and execution time is slow. If the Optimizer chooses a bad index, it will not only be slow, it...
Getting Started with MySQL Replication for High-Availability
Many organizations have MySQL or MariaDB databases at the core of their business—for processing and storing product sales, collecting information related to services offered, or just providing essential information to customers. As a result, keeping these databases...
May Cool App Winner: Ofertas do Dia
The cool app Winner for May comes from Brazil. It is Ofertas do Dia, or "Daily Offers" for us English speakers. This cool mobile app runs on iOS, Android and Windows Desktop. It collects all the daily offers from the bigger brazilian online stores and...
Tutorial : Setting up ER/Studio Repository with Microsoft SQL Server in Amazon Web Services
Howdy! In this series, we will explore on how easy it is to setup our Model Repository in the Amazon Web Services Cloud Environment. Now I will not be going through setting up an AWS EC2 instance etc. However, I will guide you through the steps you...
Getting Started with MySQL High-Availability
Keeping databases running consistently and continuously is crucial to many organizations. When your site or application fails to load because of problems with your databases, you risk losing revenues—especially a business with a high traffic site which is the main...