Home
Videos uploaded by user “IDERA Software”
Introduction to Data Modeling with ER/Studio
 
58:55
Designing data models can be a challenge for those who are unfamiliar or out of practice with the process and procedures. If you are new to data modeling, recently purchased ER/Studio, or just need a refresher on data modeling techniques and tasks, this webinar is for you! If you already know what you’re doing, then invite your new hires and your DBAs to attend. This highly-technical session will explore the ER/Studio Data Architect tool in-depth and will also provide an introduction to ER/Studio Team Server. Join Anil Mahadev for this walk-through that encompasses how-to’s and best practices for: + Data modeling – performing a variety of tasks such as reverse and forward engineering, creating and editing models, applying naming standards and using macros + Model repository – storing and managing models with version control, check-in/check-out and named releases + Enterprise visibility – accessing and sharing models and metadata in a web-based interface for both technical and non-technical users About the Presenter: Anil Mahadev is a Solutions Architect and Database Professional at IDERA Software. He participates as a Cloud and Database Evangelist and an active community member in leading Database User Groups and Conferences world-wide.
Views: 10689 IDERA Software
Overview of SQL Safe Backup
 
06:03
IDERA SQL Safe Backup provides a high-performance backup and recovery solution for SQL Server. It reduces backup time by up to 50% over native backups and reduces backup disk space by up to 95%. It also enables automated backups of entire SQL Server infrastructures and ensures compliance with the backup and recovery policies of organizations. It turns backup files into virtual databases to query and modify data as if they were real databases without restoring. From tens of local SQL Servers to hundreds of global SQL Servers, it is the only backup and recovery solution that scales to meet the challenge. You can download a free trial here: http://ow.ly/h2Hd30einkf
Views: 441 IDERA Software
Getting Started with Rapid SQL
 
03:51
This video looks at some of the basic features of Rapid SQL
Views: 2490 IDERA Software
Why Use SQL Diagnostic Manager?
 
01:46
Quickly learn the benefits Idera's SQL Diagnostic Manager can bring to your SQL Server environment.
Views: 2025 IDERA Software
Who is IDERA?
 
02:11
IDERA empowers database and IT professionals to design, monitor & manage data systems with complete confidence.
Views: 280 IDERA Software
SQL Diagnostic Manager: How to use the history browser
 
02:42
Using SQL Diagnostic Manager's history browser http://idera.com http://www.idera.com/productssolution... Get 24x7 SQL performance monitoring, alerting and diagnostics with SQL Diagnostic Manager. Features include: -Performance monitoring for physical and virtual SQL Servers *Learn More -Deep query analysis to identify excessive waits and resource consumption -History browsing to find and troubleshoot past issues -Adaptive & automated alerting with 100+ pre-defined and configurable alerts -Capacity planning to see database growth trends and minimize server sprawl -NEW - SCOM management pack for integration with System Center
Views: 515 IDERA Software
What is BPMN?
 
03:24
Views: 651 IDERA Software
ER/Studio Data Architect - Reverse Engineering a Database
 
01:53
https://www.idera.com/er-studio-enterprise-data-modeling-and-architecture-tools?utm_source=youtube&utm_medium=social&utm_campaign=productinfo&utm_content=ERA
Views: 1148 IDERA Software
How to Reconcile Differences Between Models and Databases in ER/Studio
 
02:30
Learn more about ER/Studio and try it free at https://www.idera.com/er-studio-data-architect-software?utm_source=youtube&utm_medium=social&utm_campaign=producttrial&utm_content=erstudio Use the Compare & Merge utility in ER/Studio Data Architect to easily identify differences between the physical model and the database, create an Alter script to move changes to the database, and run the script against the database to implement the changes. Then ER/Studio Data Architect can move changes made in the physical model to the relevant database, ensuring consistency between the two, and providing peace of mind for you.
Views: 211 IDERA Software
Why Use SQL Safe Backup?
 
01:52
Quickly learn the benefits Idera's SQL Safe Backup can bring to your SQL Server environment.
Views: 539 IDERA Software
IDERA SQL Diagnostic Manager
 
00:59
Monitor your SQL Servers 24/7 with SQL Diagnostic Manager. IDERA SQL Diagnostic Manager is the industry leading tool for DBAs that need real-time monitoring and performance alerts for their SQL Server instances. SQL Diagnostic Manager's comprehensive capabilities ensure that you are always in the know. No surprises, no headaches. Learn more here: http://ow.ly/j44k309KQYC
Views: 12986 IDERA Software
Rapid SQL - Register a datasource
 
01:42
The first steps in Rapid SQL, registering a datasource.
Views: 1135 IDERA Software
ER/Studio Support for Hadoop Hive
 
05:31
You can view the updated version of this video here: https://www.idera.com/resourcecentral/videos/hadoop-hive-data-modeling-erstudio-data-architect?utm_source=youtube&utm_medium=social&utm_campaign=video&utm_content=hadoophive-datamodeling or https://www.youtube.com/watch?v=XhijKE0YVlk&list=PL7C31BvsvMgBChkW5ZsURcQ_8sSFeTi4J Since data stored in Hadoop is almost always used for analytics, and because of its immense volume and wide variety, the need for data modeling has never been greater. Watch this short video to learn how ER/Studio will allow you to easily create dimensional models and important metadata for Hadoop Hive.
Views: 606 IDERA Software
IDERA SQL Diagnostic Manager Overview
 
10:48
IDERA SQL Diagnostic Manager is a robust performance monitoring, alerting and diagnostics solution for Microsoft SQL Server. It proactively notifies of health, performance, and availability problems via a desktop console, a web console add-on, and mobile device. It minimizes costly server downtime with agent-less, real-time monitoring and customizable alerting for quick diagnosis and remediation. Learn more and download a free trial here: http://ow.ly/tAmh30ldSib
Views: 408 IDERA Software
Why Glossaries?
 
02:34
A short video explaining the benefits of a business glossary.
Views: 382 IDERA Software
Agile, Automated, Aware: How to Model for Success
 
01:09:55
Watch the companion webinar at: http://forms.embarcadero.com/AgileAutomatedAware Data management teams face some tough challenges these days. Organizations need business-driven visibility that enables understanding and awareness of enterprise data assets – without worrying about definitions and change management. But with information architectures evolving, serving up accurately defined, reusable data can become a complex issue. In this episode of The Briefing Room hosted by the Bloor Group, veteran analyst David Loshin explains the importance of agile, automated workflows in today’s enterprise data architectures. Ron Huizenga of IDERA discusses how the ER/Studio suite approaches data modeling and management from a modern architecture standpoint. He explains that unifying the way information is represented can not only eliminate the need for costly workarounds, but also foster collaboration between data architects, developers and business users. Learn more about data modeling and data architecture with ER/Studio at http://www.idera.com/er-studio-enterprise-data-modeling-and-architecture-tools
Views: 1063 IDERA Software
Maximiza El Rendimiento De Tu Ambiente De SQL Server
 
01:04:12
Aprenda a encontrar de forma eficaz las consultas problemáticas para así poder optimizar el rendimiento de SQL Server. Como encontrar las consultas de ejecución deficientes, cómo obtener sugerencias de una consulta, como visualizar el plan de ejecución, optimización de su servidor y mucho más. · Encontrar consultas pesadas y frecuentes · Sugerencias optimización de las consultas · Visualización del plan de ejecución · Identificación de eliminación o consolidación de índices duplicados · Visualice el espacio de registro de transacciones (log space) · Determinar el uso y la contención del tempdb · Determinar la asignación de uso de memoria e identificar áreas de memoria
Views: 3809 IDERA Software
Create and Use Submodels with ER/Studio Data Architect
 
03:10
IDERA ER/Studio Data Architect is a powerful data modeling tool that enables companies to discover, document, and re-use data assets. With round-trip database support, data architects have the power to easily reverse-engineer, analyze, and optimize existing databases from diverse platforms. Comprehensive model management and collaboration capabilities simplify building and maintaining complex enterprise data models in the repository. Learn more here: http://ow.ly/WuU430le2Fy
Views: 244 IDERA Software
An Overview of IDERA SQL Doctor
 
07:13
IDERA SQL Doctor diagnoses and provides the cure for what ails SQL Server on-premise, in the cloud, and as a managed cloud database. Collect SQL Server performance information, analyze it, and determine the resolution in minutes rather than hours. Leverage proven industry best practices endorsed by SQL Server MVPs to analyze the performance and to provide recommendations. Target some of the most common areas of performance problems, such as queries, server configuration, security, database objects, memory, wait statistics, query plans, and much more. You can download a free trial here: http://ow.ly/KT2K30e7n0p
Views: 225 IDERA Software
IDERA ER/Studio
 
01:10
Build better data models for your enterprise architecture with IDERA's ER/Studio. ER/Studio Data Architect includes all the features you need to create and manage logical and physical data models, including detailed compare and merge capability, naming standards, data dictionaries, and extensive platform support. ER/Studio Data Architect Professional also includes the shared model repository for model change management and version control with branch and merge support. If you’re looking for the next level of collaboration with business glossaries and metadata, check out ER/Studio Enterprise Team Edition Read more: http://ow.ly/6xiC309KS4W
Views: 11344 IDERA Software
IDERA SQL Compliance Manager
 
01:09
Easily satisfy SQL Server audits with IDERA's SQL Compliance Manager. Keeping an eye on SQL servers shouldn’t bring down your SQL enterprise. Using SQL Compliance Manager maintains a watchful eye on SQL servers without performance impact implications. More info: http://ow.ly/gwEO309KSAL
Views: 5706 IDERA Software
SQL Diagnostic Manager: Introduction to SCOM Management Pack
 
03:24
SQL Diagnostic Manager now integrates with SCOM. See how. http://idera.com http://www.idera.com/productssolution... Get 24x7 SQL performance monitoring, alerting and diagnostics with SQL Diagnostic Manager. Features include: -Performance monitoring for physical and virtual SQL Servers *Learn More -Deep query analysis to identify excessive waits and resource consumption -History browsing to find and troubleshoot past issues -Adaptive & automated alerting with 100+ pre-defined and configurable alerts -Capacity planning to see database growth trends and minimize server sprawl -NEW - SCOM management pack for integration with System Center
Views: 1252 IDERA Software
(Español) SQL Diagnostic Manager: How to Add Servers
 
03:47
http://idera.com http://www.idera.com/productssolution... Get 24x7 SQL performance monitoring, alerting and diagnostics with SQL Diagnostic Manager. Features include: -Performance monitoring for physical and virtual SQL Servers *Learn More -Deep query analysis to identify excessive waits and resource consumption -History browsing to find and troubleshoot past issues -Adaptive & automated alerting with 100+ pre-defined and configurable alerts -Capacity planning to see database growth trends and minimize server sprawl -NEW - SCOM management pack for integration with System Center
Views: 376 IDERA Software
Team Server API - Overview
 
03:22
The Team Server REST Application Programming Interface (API) allows one application to talk to another application directly and securely.
Views: 152 IDERA Software
IDERA Precise for Databases
 
01:08
Performance intelligence from click to storage. Precise empowers IT to automatically detect, diagnose, and resolve performance issues for a diverse range of system clients – including Oracle, SAP, PeopleSoft, and Sybase – before any problems ever occur. More info: http://ow.ly/mGbX309KSNz
Views: 1551 IDERA Software
Make your ER/Studio Model Easier to Understand with Submodels
 
03:10
Learn more about ER/Studio and try it free at https://www.idera.com/er-studio-data-architect-software?utm_source=youtube&utm_medium=social&utm_campaign=producttrial&utm_content=erstudio Navigating and managing a logical model that has grown too complex may feel like an uphill battle, but our tips will send you coasting through the challenge: Simply create submodels to break out specific areas of a model into a subset for easier visibility, with a selection of configurations. For example, segment the model by focusing on subject areas such as Production or Sales. Then you can create multiple levels of submodels as nested submodels. With submodels, you can easily organize a logical model into smaller units, making it easier to manage and navigate large models. Hold the keys for ruling your database kingdom with a free trial of ER/Studio Data Architect.
Views: 282 IDERA Software
IDERA SQL Compliance Manager v5.5 - New Features
 
02:51
Discover the highlights and new features of the SQL Compliance Manager v5.5 release. This video will show highlights of our installer redesign, support for SQL Server 2017, new settings available in the console, new and updated regulatory guidelines, sensitive column datasets, and more. Download a free trial here: http://ow.ly/Y4fI30kMI4Q
Views: 221 IDERA Software
DBArtisan Feature Look
 
05:38
https://www.idera.com/dbartisan-database-administration-solution?utm_source=youtube&utm_medium=social&utm_campaign=productinfo&utm_content=dbartisan
Views: 864 IDERA Software
Using Business Processes for Data Governance
 
07:21
Learn why it is important to create business process models for data governance. Learn more about ER/Studio and download a FREE trial here: http://ow.ly/LBAo30g1318
Views: 255 IDERA Software
SQL Query Tuner Overview
 
16:34
SQL Query Tuner is an automated SQL query optimization tool that maximizes database and application performance by quickly discovering, diagnosing, and optimizing poor-performing SQL queries. It empowers database administrators and database developers to eliminate performance bottlenecks by graphically profiling critical metrics inside the database, relating resource utilization to specific queries, and helping to tune problematic SQL queries visually. SQL Query Tuner is an add-on to SQL Diagnostic Manager. Learn more and download a free trial here: http://ow.ly/mSEu30ljU94
Views: 284 IDERA Software
5 Key Features of SQL Diagnostic Manager
 
01:07:45
IDERA SQL Diagnostic Manager is a powerful performance monitoring and diagnostics solution that proactively alerts administrators to health, performance, or availability problems within their SQL Server environment. SQL Diagnostic Manager allows DBAs to discover potential and existing problems, analyze the state of their SQL Server enterprise, and generate reports. Learn more here: http://ow.ly/bDUZ30le3as
Views: 422 IDERA Software
Why Use SQL Secure?
 
02:11
Quickly learn the benefits Idera's SQL Secure can bring to your SQL Server environment.
Views: 163 IDERA Software
Geek Sync: Consolidating Indexes in SQL Server
 
02:00
View the full webcast on demand: http://bit.ly/1Qg5XC8 Join us in a Geek Sync with special guest Microsoft Certified Master Kendra Little to learn why duplicate indexes can be a big problem for your performance and maintenance. Kendra will show you three different index consolidation scenarios, and how you can measure the pros and cons of different consolidation options. You'll leave the webcast with a new knowledge of how and why you should periodically consolidate indexes in SQL Server.
Views: 148 IDERA Software
Precise for DB2 Overview
 
06:52
Precise for DB2 proactively monitors, analyzes, and tunes IBM DB2 databases to keep your DB2 UDB-based applications available and performing at peak efficiency. Precise for DB2 captures, measures, and correlates performance metrics from all crucial system components. These metrics give DBAs a complete view of application performance and helps improve end-user response time while maximizing the return on technology investment. Learn more here: http://ow.ly/N91n30jixmr
Views: 25 IDERA Software
ER/Studio Provides Context for Enterprise Models and Metadata
 
01:25
ER/Studio provides a single view across enterprise data sources, with the ability to forward and reverse-engineer databases, and create code to update changes from your model directly into your database. ER/Studio collaboration capabilities are also robust, allowing teams to contribute to enterprise glossary contents, defining consistent terms and descriptions for entities and objects with specific parameters and attributes.
Views: 128 IDERA Software
Overview of SQL Diagnostic Manager for MySQL
 
11:54
IDERA SQL Diagnostic Manager for MySQL is an agentless monitoring application for MySQL or MariaDB. It proactively identifies issues affecting database performance. It reduces downtime, tightens security, and improves the performance of MySQL or MariaDB. It is easy to setup and includes more than 600 monitors and advisors that continuously check the health status of MySQL or MariaDB. Learn more and download a free trial here: http://ow.ly/YvNh30lxDlH
Views: 649 IDERA Software
Migrate ERwin Data Models to ER/Studio Data Architect
 
03:44
You can easily migrate data models from ERwin Data Modeler to ER/Studio Data Architect using the integrated model import bridges through the ‘Import External Metadata’ wizard. This short video shows how quickly this can be done with accurate results.
Views: 330 IDERA Software
SQL Diagnostic Manager: TempDB
 
02:40
Examining TempDB in SQL Diagnostic Manager http://idera.com http://www.idera.com/productssolution... Get 24x7 SQL performance monitoring, alerting and diagnostics with SQL Diagnostic Manager. Features include: -Performance monitoring for physical and virtual SQL Servers *Learn More -Deep query analysis to identify excessive waits and resource consumption -History browsing to find and troubleshoot past issues -Adaptive & automated alerting with 100+ pre-defined and configurable alerts -Capacity planning to see database growth trends and minimize server sprawl -NEW - SCOM management pack for integration with System Center
Views: 756 IDERA Software
ER/Studio Team Server - Glossary Tool Tip
 
02:46
A quick look at adding Glossary Tool Tip to ER/Studio Team Server.
Views: 128 IDERA Software
Demystifying Macros with ER/Studio
 
01:00:28
Many data professionals want to simplify their routine or repetitive tasks in a data modeling tool but may not know quite how to do it. ER/Studio Data Architect includes a large selection of macros that can automate and simplify specific tasks and provides the ability to create and save custom macros for repeated use. In this session, Stanley Chan will show you all about macros in ER/Studio, including: + What macros are and how to use them + How to use the integrated editing tools in ER/Studio to create macros and event handlers + A demonstration of built-in and commonly requested macros This is a detailed technical session for those who want to understand and implement macros in their ER/Studio data modeling environment. About the presenter: Stanley Chan is a software consultant for IDERA specializing in ER/Studio. He has been supporting database tools for over 10 years, serving as a software consultant, a technical account manager and a technical support representative. Learn more about ER/Studio: https://www.idera.com/er-studio-data-architect-software?utm_source=youtube&utm_medium=social&utm_campaign=producttrial&utm_content=erstudio
Views: 407 IDERA Software
An Overview Of IDERA SQL Workload Analysis
 
02:53
SQL Workload Analysis focuses on wait state and application transaction monitoring and analysis by continuously sampling queries and plans. It significantly upgrades the wait state analysis capabilities. Combine the operational monitoring from SQL Diagnostic Manager and transactional monitoring with SQL Workload Analysis to view instance properties and alerts, receive prescriptive recommendations for operational diagnosis, analyze workloads for transactional diagnosis, and arrive at a comprehensive root cause analysis.
Views: 392 IDERA Software
IDERA SQL BI Manager Overview
 
05:35
IDERA SQL BI Manager provides agentless monitoring of the servers and services for SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Integration Services. Get insight into over 140 metrics including OS counters, service performance counters, and system availability. Learn more and download a free trial here: http://ow.ly/Alnd30ldRlu
Views: 38 IDERA Software
Precise For SQL Server Overview
 
10:38
Precise for SQL Server is designed specifically to keep your SQL Server database environment available and performing at peak efficiency. It captures, measures, and analyzes performance metrics from all critical system components and helps you detect and correct the root causes of problems before end users are affected. Precise for SQL Server provides high-level visibility across multiple SQL Server instances and provides alerting to problems, reports on collected data, and maintains a warehouse of SQL Server database performance information. Request a demo here: http://ow.ly/DzuC30jizJ6
Views: 94 IDERA Software