Featured Blog
ERS 19.3.3 GA
Announcing the GA of SQL Enterprise Job Manager 2.4
We’re excited to announce the release of SQL Enterprise Job Manager 2.4 SQL Enterprise Job Manager is an industry leading monitoring, scheduling and...
Announcing the General Availability of SQL Secure 4.1
We are pleased to announce the general availability of SQL Secure 4.1 SQL Secure is the industry-leading, state of the art auditing and security...
Infor Compass JDBC Driver / Infor Compass JDBC Driver.ionapi
Does anyone have an example of setting up a ADS server using the Infor Compass JDBC Driver and their oAuth file(Infor Compass JDBC Driver.ionapi)?...
Communication Link failure
I'm using the latest version of Aqua Data studio and have created a connection to a remote MySQL server. Everything was fine a week or so...
Incorporating compound IF THEN ELSE ELSE statements using query builder functions?
Haven't tried this before, but I'm trying to idiot proof a set of query's and make the held values understandable by the end user while utilizing...
SQLDM – Add Tags and Friendly Names to Alert Responses Variables
We are managing SQL for multiple customers and the server names are often not clearly descriptive. Therefore we use the Tags as the customer...
Announcing the Release of SQL Safe Backup 9.1
We’re excited to announce the release of SQL Safe Backup 9.1 SQL Safe Backup provides the industry's shortest time from starting a SQL Server backup...
Use better tools for SQL Server backup
Not knowing what tools are available There are several tools that come with SQL Server that can be used for backup processing, such as SQL Server...
Migrating and Upgrading Diagnostic Manager
So we are trying to do 2 things with the least amount of moving parts... We have dm 10.4 and want to move to 11.1 as well as move the whole thing to...
Business Glossary Best Practices: The Do’s and Don’ts
An understanding of business glossary best practices - such as what goes into a business glossary and what should not - is a vital factor in...
Improve your management for SQL Server backup
Inconsistent backup plans While it is hard enough to manage SQL Server, you find that having inconsistent backup plans from server to server will...
Four differentiators of ER/Studio Data Architect
Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models,...
Improve your performance for SQL Server backups
Writing directly to tape A lot of third–party backup tools have agents that allow you to write directly to tape. This was great in the old days when...
The Value of Objects
This is a reprint of an article published earlier this year in my premium PowerShell newsletter, Behind the PowerShell Pipeline. This is a sample of...
sql file results to file
I have an sql file with 2500+ select statements. I want to run this file and have the results sent to a single file. These points are what I have...
Support Citrix
Is it possible to install Aqua data studio on a Citrix machine? If so, which type of licence key is needed? Response Thomas Conrad 4 months ago ADS...
Run ER Modeler without Data Studio?
Is there a way to launch ER Modeler without Data Studio, e.g. go straight to ER Modeler? Using Data Studio 22.1.3 Response Thomas Conrad 4 months...
Improve your knowledge for SQL Server backups
Not understanding options Another big problem is people not being aware of the different options that are available using T-SQL commands and using...
Improve your testing and scheduling for SQL Server backups
Testing Not using restore verify option The last thing you want is to discover that your backup is not good when trying to restore it. A restore...
Announcing the Release of SQL Safe Backup 9.0
We’re excited to announce the release of SQL Safe Backup 9.0 SQL Safe Backup provides the industry's shortest time from starting a SQL Server...
SQL Diagnostic Manager versus other SQL Server performance monitoring tools
As a seasoned SQL Server database administrator or developer, you already know that there is an abundance of tools you can use to collect server and...
Tune SQL queries for SQL Server
Writing and tuning SQL code are two different things. There are many ways to write code so that it does the intended function. But there are also...
Idera Dashboard – increase number of characters in ConnectionPassword column in Common.RegisteredProducts
Hi, please consider changing the length of the ConnectionPassword column in the IderaDashboardRepository.Common.RegisteredProducts table. Currently...
View wait stats for SQL Server
There are several things that could cause performance issues for a query. You can identify these by breaking down the processing time for a query...
View query metrics for SQL Serve
There are many things that can cause slowdowns in SQL Server, such as resources like disk, memory, and network. But the one place where database...
Analyze deadlocking for SQL Server
Deadlocking is a common problem that can occur in an SQL Server database. This is like blocking. But instead of being blocked forever, SQL Server...
Analyze blocking for SQL Server
Blocking is a normal activity that occurs in SQL Server and it does that to control data integrity and make sure only one resource can change a set...
Bringing the Development World under the Data Management Umbrella
We have Data at Rest, Data in Transit, and Data in Use. Data in Use has been covered pretty well by Data Architecture and Data Governance teams....
Why ER/Studio Data Architect is the best data modeling tool
Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models,...
See the entire SQL Server environment
There are many advantages of using SQL Diagnostic Manager over building your own tools and one of these is the enterprise management view of all...