Video
:
Compare Models and Make Decisions with ER/Studio Data Architect
Learn how to use IDERA’s ER/Studio Data Architect to compare the logical models of a source database with the target while consoli...
Video
:
Document a Database with a Logical Model with ER/Studio Data Architect
Discover the steps to documenting a database with a logical model using IDERA’s ER/Studio Data Architect.
Video
:
Reverse Engineering a Database with ER/Studio Data Architect
This video demonstrates how to reverse engineer an existing database using IDERA’s ER/Studio Data Architect.
Video
:
Document a Database with ER/Studio Data Architect
Learn how to document a database using IDERA’s ER/Studio Data Architect, including taking a tour around a logical and physical model.
Video
:
Consolidate Some Databases with ER/Studio Data Architect
In this video, discover how IDERA’s ER/Studio Data Architect can be used to consolidate some databases.
Whitepaper
:
The Complications of Cybersecurity in the Cloud
This whitepaper describes the complications of cybersecurity in the cloud, security risks of cloud computing, shared security resp...
Webcast
: 
Geek Sync -
Neutralize Troublesome SQL Server Indexes
Pinal Dave shares scripts for various difficult scenarios which you can apply to your server right away to easily improve performance.
Webcast
:
Geek Sync -
Data in the Cloud: Understanding Amazon Database Services with Visual Models
IDERA and Henry Nirsberger show you how conceptual data models for Amazon database services can clarify confusion and accelerate a...
Whitepaper
:
What You Need to Know About Compliance Audits
This whitepaper will discuss the reasons that compliance is important and outline the steps required for organizations to respond ...
Case Study
:
Global Financial Services Organization Turns to ER/Studio for High-Performance Data Modeling
A large federal agency had more than 10,000 databases spread across 300+ SQL Servers, this federal agency’s IT services support cr...
Whitepaper
:
Are You Aware of These Database Risks?
Knowing about database security threats and risks is the first step in developing best practices around database security that off...
Whitepaper
:
How to Handle the Complexities of Regulatory Compliance
Concerns over how data is used has spawned regulations intended to give people more control over their sensitive data. This means ...
Video
:
Change Management with ER/Studio Data Architect
In this video, learn how to manage change in development and production environments using IDERA’s ER/Studio Data Architect.
Video
:
Create and Deploy Database Design with ER/Studio Data Architect
Learn how to create and deploy database design with IDERA’s ER/Studio Data Architect in this video.
Webcast
:
Geek Sync -
Faster Transactions: Query Tuning for Data Manipulation
Jeff Iannucci discusses common pitfalls for any SQL professional who is manipulating large sets of data and what techniques you ca...
Datasheet
:
IDERA’s Solutions for MySQL and MariaDB
In this document, learn how IDERA’s portfolio of products can help data and database professionals with development, administratio...
Solution Brief
:
Tune the Performance of SQL Server, Azure SQL Database and Amazon RDS
Diagnose and provide the cure for what ails SQL Server on-premises, in the cloud, and as a managed cloud database with SQL Doctor.
Video
:
Build a Logical Data Model with ER/Studio Data Architect
In this video, learn how to build a logical data model using IDERA’s ER/Studio Data Architect.
Solution Brief
:
Find and Fix SQL Server Deadlocks
Monitor, alert, diagnose, and report on deadlocks with SQL Diagnostic Manager for SQL Server to prevent the rollback of transactio...
Video
:
Design a New Database with ER/Studio Data Architect
Learn the steps on how to use IDERA’s ER/Studio Data Architect to design a new database in this overview video.
Webcast
:
Geek Sync -
Becoming a Better Data Modeler: Part 2 (Faulty Design Patterns)
IDERA and Steve Hoberman help you become a better data modeler by exploring a series of faulty design patterns and demonstrating h...
Webcast
:
Geek Sync -
MySQL Performance Tuning via Query Tuning
IDERA and Pinal Dave discuss performance tuning tricks that DBAs must know to improve their MySQL performance.
Solution Brief
:
Monitor Always On availability groups with SQL Diagnostic Manager for SQL Server
Ensure that SQL Server on Always On availability groups is running smoothly by monitoring their availability, health, and performa...
Solution Brief
:
Plan future capacity with SQL Diagnostic Manager for SQL Server
Review the design, configuration, and other essential resources to ensure that new SQL Servers are performing optimally by plannin...
Whitepaper
:
SQL Syntax and Query Performance
Learn about some syntax and query principles that you can follow that should help you produce good SQL most of the time and give y...
Whitepaper
:
How to Become a Database Administrator for MySQL
Do you want to become a database administrator (DBA) for MySQL? Read this whitepaper to learn what the job may look like, what ski...
Whitepaper
:
Top Metrics to Monitor in MySQL Databases
The secret to knowing what adjustments to make to the MySQL database is to perform regular monitoring, track the most useful metri...
Whitepaper
:
A User-centric, Collaborative, Holistic Philosophy of Tuning the Application Stack
Do not wait until the environment is showing distress to implement the plan to optimize the performance of applications. Learn in ...
Whitepaper
:
Detect Baseline Anomalies
This whitepaper explains what baselines are and how to detect baselines anomalies to find and fix SQL performance problems before ...
Whitepaper
:
Azure SQL Hyperscale
Azure SQL Hyperscale is a new database as a service (DBaaS) offering from Microsoft. Learn about its characteristics and architect...