Announcing the General Availability of IDERA SQL Compliance Manager 7.0
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
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,...
Understanding SQL Server Statistics
Donabel Santos (twitter (@sqlbelle) | blog) – April 25, 2011 “Statistics provides tools that you need in order to react intelligently to information you hear or read” – David Lane, 2003 Identify out-of-date SQL Server statistics with...
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 Object to Window->CREATE and it takes 4 minutes. Why is it fast to execute, but slow to execute edit? Response Niels...
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 few MySQL servers only. Now after evaluation they are planning the deployment and users that want to monitor a large...
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 far I have been unsuccessful in getting it to work. I get Invalid Credentials when I try to test the configuration without...
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 to prepare for a career. There have been numerous articles, blog posts, conference talks, videos, white papers and...