Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. Response Jonathan Powers over 11 years ago Unstable...
Blog
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...