Announcing the General Availability of IDERA SQL Safe Backup 9.3
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
How to add a simple Custom Object in Monyog
MySQL is developing rapidly. And today it does not only happen along a single track but in multiple directions simultaneously. This is due to both server 'forks' as well as various plugins and 3rd party storage engines available. Each of those will often add...
How to Make a Copy of a Database on Windows Azure SQL Database
Windows Azure SQL Database (previously SQL Azure) offers a unique way to make a database copy to another database using the CREATE DATABASE as COPY OF command. The copy operation is a mechanism that developers and administrators can use to clone a SQL Database...
Per-database information in performance_schema, please!
This is a follow-up om my first Blog on performance_schema that appeared here: One particular request that we had frequently from our users is to have status variables exposed per database and maybe even per table. Currently this is not possible. Not even with MySQL...
FLUSH STATUS surprise?
What does FLUSH STATUS do? We all know that it will simply reset all status variables (except for 'uptime') to same values as immediately after a server restart. Just google it and you will find that behaviour statet on hundreds of sites on the Internet. But...
Performance_schema considerations.
I have for the first time been spending some time trying to understand the performance_schema. It is not easy to understand everything unless you are very well-versed in server internals (what I am not) and much information available here is probably more useful for...
Setting per-server thresholds in Monyog.
Please note that this blog was updated on April 5th 2012. We have added(at the buttom) how to use server TAGS for defining thresholds. Introduction: If you have been using MONyog you will know that any metrics/counters may be identified with either of the 'states'...
Why does selecting a file in the filechooser on OSX not select the file extension with the full file name?
I run the Import Tool, and click browse to select a file to import. When I select one of my files, which has a .CSV extension, the full file name is selected without the .CSV extension. Is this a bug? Response Niels Gron over 11 years ago This looks like it this is a...
I get the warning “Server returned invalid line number (0)” when debugging a Sybase procedure, am I doing something wrong?
I am not sure why I am getting the warning "Server returned invalid line number (0)" when debugging Sybase stored procedures. Response Niels Gron over 11 years ago The warning message you are getting "Server returned invalid line number (0)" is coming from the Sybase...
Why are certains operations of Aqua Data Studio very slow with MySQL?
I have a server registration to MySQL and other databases. When I execute queries in the Query Window for MySQL they are fast. But If I try to Create or Alter a table is to can 30 seconds for the dialog to come up. But Create and Alter of tables on other databases are...
Why isn’t there a Procedure Editor for MySQL like there is for the other database vendors?
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 exist. Why is "Edit in Procedure Editor" missing in MySQL? Response Niels Gron over 11 years ago You can right-mouse-click...
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 Behavior and Crashes Using ADS JRE-related Issues Please make sure to run ADS with the bundled JRE. ADS requires the Oracle...
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 ago Backing up and Transferring Aqua Data Studio Settings For details and OS-specific information about creating...
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 in the database vendor’s command line tool. Response Jonathan Powers over 11 years ago Example: select * from t1 select *...
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 crashes, becomes unresponsive, or displays no output when querying for a large amount of data, it has...
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 disconnected from the server Aqua Data Studio does not timeout user connections. However, many DBAs configure the database...
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 connect to it using SSL. How do I configure my connection? Response Niels Gron over 11 years ago In your Server...
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 a database server login is controlled by the JDBC driver of the vendor. Each vendor has non-standard properties 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 building of the email) rather than loaded from src url? Also the url doesn't seem to get formed correctly: img...
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 blogs have started to appear with ways to do this. One way that is appropriate to add additional functionality to your VCL...
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 TClientDataSet and a TDataSource on a form. Load some data into the dataset such as biolife.xml (Right click ClientDataSet1,...