I can right mouse click on a procedure in Oracle, DB2 and SQL Server and choose the "Edit in Procedure Editor", but in MySQL this option doesn't...
Blog
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
Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. What do I do?
Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. Response Jonathan Powers over 11 years ago Unstable...
How can I backup Aqua Data Studio settings and server connections, or move them from one computer to another?
How can I backup Aqua Data Studio settings and server connections, or move them from one computer to another? Response Jonathan Powers over 11 years...
Scripts with multiple statements return errors. Some database commands or symbols do not work in Aqua Data Studio while they do work in the database vendor’s command line tool.
Scripts with multiple statements return errors. Some database commands or symbols (such as “;”) do not work in Aqua Data Studio while they do work...
Aqua Data Studio is running out of memory. How do I increase it?
Aqua Data Studio is running out of memory. How do I increase it? Response Jonathan Powers over 11 years ago Memory Allocation in Aqua Data Studio If...
Aqua Data Studio gets disconnected after a certain period of time.
Aqua Data Studio gets disconnected after a certain period of time. Response Tariq Rahiman over 11 years ago Timeouts: ADS periodically gets...
How do I connect to PostgreSQL using SSL and my personally created certificate
I want to connect to my PostgreSQL server using SSL. I've created a certificate on my PostgreSQL server, but I can't configure Aqua Data Studio to...
How do I connect to Teradata with LDAP?
How do I connect to Teradata with LDAP authentication using Aqua Data Studio? Response Niels Gron over 11 years ago The authentication mechanism for...
Re: dataSetChart image in emails
Do you know how to ensure chart images are displayed in emails correctly? Is there a way to have them embedded (attached, but displayed in the...
Writing a FireMonkey DLL for use with a VCL application.
We have had a lot of questions on the road show tour about how to mix Fire Monkey and VCL. Although this is not officially supported, a number of...
LiveBindings: Fill a TListBox from a TClientDataSet at design time
TBindList can iterate through the records in a TClientDataSet and fill a TListBox. Here is how to configure TBindList in the designer. Drop a...
Understanding SQL Server Statistics
Donabel Santos (twitter (@sqlbelle) | blog) – April 25, 2011 “Statistics provides tools that you need in order to react intelligently to...
Why is the MySQL Table Data Editor and DDL Scripting slow?
I execute a query in MySQL and it returns in 200ms. I "Execute Edit" the same query and it takes 4 minutes. I try to Script...
What are Hardware Requirements for Monyog?
We are often asked by users deploying MONyog what hardware system they should plan for it. Typically they have been evaluating and testing with a...
Active Directory In Up.time 5.5.0
I am trying to get AD authentication working in up.time 5.5.0 as I have several engineers in different locations that want to evaluate it. But so...
How to start a programming career with Delphi XE and C++Builder XE Starter Editions
Over the years, one of the recurring conversations has been around how to get started in computer programming, what language to learn first and how...
Customization of monitors & advisors become more easy with the latest MONyog 4.1
The highlights of this release are: * A brand new helper function interface: We have implemented an easy-form based interface for customizing helper...
Move Groups Of Tables
I've just started to use the Schema Designer feature, and whilst handy it is driving me mad as I can't see any way of moving a group of...
Take your indexed columns out of functions to really boost SQL Server performance!
In a future article I will show how to quantify and rank your “heaviest” SQL Server queries according to the overall load they place on...
Performance of COALESCE vs. IS NULL
There are a great many articles out there expounding the virtues of using the ANSI standard COALESCE function over the...
Monitoring Disk Space Of Nas Devices
I have 3 different NAS devices (Netgear, Lacie, IOmega) that I would like to monitor through uptime to see if their disk space is being used or...
Using Windows Stock Icons in Delphi
it is not a big discovery that all applications are running in the environment provided by the underlying operating system. Delphi is well-known for...
Converting to grayscale with TBitmap.ScanLine property
In my previous post "Boian’s TBitmap Visualizer and converting to grayscale" I have described an algorithm for converting arbitrary TBitmap...
Archive Alternative Methods
We have been looking at how Uptime stores its data and how me can make better use of Uptime.With the exception of the disk performance_fscap table...
“MySQL server has gone away” Part 2: session timeout.
This is the second and last article of a small series on reasons for the error message: “MySQL server has gone away”. The first appeared here...
"MySQL server has gone away" Part 1: max_allowed_packet.
Most MySQL users have tried getting this rather cryptic error message: "MySQL server has gone away". The MySQL documentation describes...
DataSnap Server Method Stream Parameters
This is a continuation of my posts on DataSnap server method parameters and return types. This post is about TStream and TDBXStreamValue. The...
Ldap Monitor
hello, I downloaded friday 20 mars “up-time5″ for test. when i try to use 'test ldap service instance', I have always error=53....
Monthly Capacity Reporting
Monthly Capacity Reporting I need to provide server by server (Wintel) some preety management pictures that show CPU both peaks and average with a...
DataSnap Server Methods Parameters
Delphi 2009 introduced support for DataSnap server methods. If you are not familiar with this feature, here are two articles that describe server...