We are pleased to announce the general availability of SQL Secure 4.2 SQL Secure is the industry-leading, state of the art auditing and security...
Blog
Automatic Corrective Action
Precise offers script execution as a response action to an alert. This post provides an introduction to configuring automatic corrective...
SQL Server Security: Always Encrypted
Always Encrypted (AE) is a feature Microsoft introduced to SQL Server 2016. This post will provide an overview of AE and talk about how it can be...
What is Logical Data Modeling?
Logical data modeling is the second of the three stages of data modeling and one of three types of data model. The three types of data model -...
Macros – How to schedule an automatic reverse-engineer from a database into a data model?
This blog post describes how you can run a macro to reverse engineer a database and call it from the Windows Task Scheduler.
ER/Studio 19.3 General Availability
We are pleased to announce the general availability (GA) of IDERA ER/Studio 19.3 ER/Studio 19.3 delivers support for Google BigQuery. This allows...
How to automate nested JSON Data Extraction in 10 Simple Steps
If you’ve ever worked with data stored in JSON files, you probably know that extracting data from nested JSON files for processing can be...
Announcing the General Availability of SQL Workload Analysis 1.7.1
We’re excited to announce the release of SQL Workload Analysis 1.7.1 Problematic SQL queries can severely reduce the performance of SQL...
SQL Diagnostic Manager 12.0 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 12.0. Existing users may upgrade to this version through the Idera...
Improve your recovery for SQL Server backup
Not having a good recovery process One big part of your backup process needs to include the recovery procedures. You should have a rehearsed...
Announcing General Availability of DB PowerStudio, version 18.2
IDERA’s DB PowerStudio provides a powerful cross-platform toolset for database development, tuning and database management. What's new in DB...
Is ER/Studio Data Architect really 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,...
Announcing the General Availability of Aqua Data Studio, Version 22.2!
Aqua Data Studio is the industry leading multi-platform Database Integrated Development Environment (IDE) with Visual Analytics. Data and...
Announcing General Availability of SQL Inventory Manager 2.6.3
We’re excited to announce the release of SQL Inventory Manager 2.6.3 Database administrators need a simple, efficient way to discover, document, and...
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...
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...
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...
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...