Monitoring & Performance
Security & Compliance
Backup & Administration
Data Modeling and Architecture
SQL Development and Tuning
Uptime Cloud Monitor
Uptime Infrastructure Monitor
Ask the Experts
PowerTips Reference Library
Free Tool Forums
sql diagnostic manager
Blog - Post List
By view count
By comment count
5 Sep 2017
Instantly Access Data in Backup Files to Improve Database Continuity
SQL Server databases are often repositories for large volumes of business-critical data. As the sizes of databases grow, restore operations become time-consuming. Database professionals need to access data in backup files quickly to reduce recovery time and increase application and business availability. Learn how to instantly access your data in backup files via several conventional and advanced recovery capabilities...
4 Sep 2017
IDERA ER/Studio Repository Database Setup and Ports - Part 1 - SQL Server
Howdy! In this latest blog post, I will be covering the Database setup one would need for our IDERA ER/Studio Repository. Pre-requisites: SQL Server 2012-2016 (Standard and Above) SQL Server Configuration Manager Enable TCP Ports The default port is 1433. You may add your custom Port. View Article here.. Enable Repository Ports in your Windows Firewall View Article here.. H ere are the list of ports that...
31 Aug 2017
How to Tune the Performance of SQL Server, Azure SQL Database and Amazon RDS
SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance information, analyze it, and determine the resolution in minutes rather than hours. Leverage proven industry best practices endorsed by Most Valuable Professionals (MVPs) to analyze the performance and to provide recommendations. Target some of the most common areas of performance...
30 Aug 2017
Tell Me A Data Story - Part Two
Our new 2 minute video, "Tell Me A Data Story - Part Two" tells the story of a growing business that realizes that things are quickly getting out of hand. In the video, we look at how a business can use Business Process Models to identify places where they can have increased growth and data captured. www.youtube.com/watch Understanding the Concepts in this Video Business Stakeholders can use ER/Studio Business...
30 Aug 2017
IDERA’s Hurricane Harvey Relief Efforts
As many of you know, Houston is currently experiencing catastrophic flooding. Houston has a special place in our hearts as it is the home of IDERA Headquarters and many of our employees and valued customers reside there. To help with recovery efforts, we will send you a free “Texas Duck” with a $10 donation made to Houston Pets Alive. And, as a thank you, IDERA has agreed to match donations up to $15,000. Here...
29 Aug 2017
IDERA WILL BE AT MICROSOFT IGNITE 2017!
For the first time, IDERA will be exhibiting at Microsoft Ignite! We are so excited to be a part of this event, taking place from September 25 th -29 th at the Orange County Convention Center in Orlando, Florida. The exhibit hall will be open from Monday (September 25) to Thursday (September 28). IDERA will be located at booth 2215. Come by and say hi and enter to win one of 3 Apple watches! Please register for Ignite...
28 Aug 2017
Tell Me A Data Story - Part One
Our new 2 1/2 minute video, "Tell Me A Data Story - Part One" tells the story of a small business who realizes that they need to implement a new software solution in order to meet the growing demands on their business. In the video, we look at how a Data Modeler can work to help businesses turn their visions for their software into a reality. www.youtube.com/watch Understanding the Concepts in this Video ...
23 Aug 2017
Will the Traditional DBA Role be Eliminated with Cloud?
The cloud is all the buzz lately. New features like Automatic Tuning and Active Geo-replication are now being offered by AzureDB with the majority of their package offerings. Automatic Tuning is a free service! How can a traditional DBA compete with such things? Join us for our next #SQLChat on Wednesday, September 13 with Jim Donahoe ( @SQLFlipFlopsDBA ) as he leads a discussion on the state of the DBA. This #SQLChat...
20 Aug 2017
New Book - Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability
I've teamed up with two world class Oracle ACE Directors to create a new book - Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability . This book will cover every tool and technique DBAs should be aware of for performance and scalability testing of their Oracle 12c databases whether on premise or in the cloud.
17 Aug 2017
How to Ensure That Databases Are Backed Up On a Regular Basis
Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases. Determine which databases are not backed up within the last specified number of days.Display the last backup time stamp for each database. Display the last backup time stamp for each database. Drill down into the complete backup history for a specific database. Display...
17 Aug 2017
Announcing the General Availability of DB PowerStudio 16.6.1
IDERA is pleased to announce the general availability of DB PowerStudio 16.6.1 . Existing users may upgrade to this latest version via the online downloads . New users may download the trial version from the IDERA Website . DB Optimizer 16.6.1 substantially improves SQL rewrite speed and reliability via a superior new data dictionary lookup and caching mechanism. Moreover, DB Optimizer also removes the requirement...
15 Aug 2017
Got PostgreSQL? Monitor with Uptime Cloud Monitor
Use IDERA Uptime Cloud Monitor (UCM) to monitor your PostgreSQL database for availability and performance. Prerequisites Uptime Cloud Monitor from IDERA offers a SAAS based out-of-the-box solution for monitoring PostgreSQL for performance and availability. If you are not familiar with the concept of custom metrics as used in Uptime Cloud Monitor, please go through Custom Metrics information once before continuing...
15 Aug 2017
How to Analyze the Health of Database Indexes
To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases. For this purpose, display these statistics of indexes: The percentage of rows modified since statistics were last updated. The percentage of updates to the total number of times the index is accessed. The columns affected by the statistic. Whether the index is clustered or disabled...
14 Aug 2017
Use SQL Safe Backup's Monitor Only Policies with customized backup operations
In my previous blog post , I wrote about how customized backup/restore solutions can be accomplished through the use of SQL Safe Backup's command line interface (CLI) and/or extended stored procedures (XSPs). I'm certain that some SQL Safe Backup users have customized their own backup jobs through the use of the CLI and XSPs. In this post, I'd like to extend on that subject a bit and talk about monitoring those customized...
10 Aug 2017
How to Migrate Databases and Data Files
Do you need to: Move databases from one instance to another (for example, to move a performance-intensive database to a faster hard drive to speed up performance)? Copy databases from one instance to another or on the same instance. Migrate databases while preserving the associated data files and maintaining the associated logins. Relocate the data files for a database to a different storage device while keeping...
10 Aug 2017
ER/Studio 17 General Availability
We are pleased to announce the general availability (GA) of IDERA ER/Studio 17.0 ER/Studio 17.0 delivers significant new business process modeling capabilities in the Business Architect component. Performance and quality improvements have been made throughout the suite, as well as platform enhancements. What’s New in ER/Studio 17.0? Business and Enterprise Architecture The new release of ER/Studio Business...
10 Aug 2017
SQL Diagnostic Manager 10.2.1 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 10.2.1. Existing users may upgrade to this version through the Idera Customer Portal . New users may download the trial version from the Idera Website . This release includes the following features: What’s New in Diagnostic Manager 10.2.1? This release adds the capability previously added in SQL Diagnostic Manager 10.2 to the browser interface...
9 Aug 2017
How to Ensure that Databases Do Not Have Fragmented Indexes
Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes. View the fragmentation level of indexes.Filter the results by Filter the results by server, database, and table. Sort indexes based on the fragmentation level, size, and name. Hide small and disabled indexes. Reorganize or rebuild indexes. With the Quick Reindex tool of SQL Admin...
7 Aug 2017
Guilty Until Proven Innocent
Take Oracle, SQL, Sybase, and DB2 performance to the next level
7 Aug 2017
Logical to Physical Data Modeling
In the last article we learned how to create a data model from scratch using ER/Studio Data Architect. In part II we will explore about how to convert a Logical Data Model into a Physical Data Model. Section 1: Generating a Physical Data Model Task 1 1) Launch ER/Studio Data Architect 2) Open the last created model 3) We shall now be generating a Physical Model to an actual Database Schema to SQL Server 2016...
4 Aug 2017
New patch releases available for ER/Studio 16.5.0 (2016+) and also ER/Studio Team Server 16.1.x (2016)
For customers using ER/Studio 16.5.0 (2016+), the 16.5.1 patch release is now available. This patch contains a number of performance improvements and bug fixes for ER/Studio Team Server 16.5.0 , particularly for model publishing and viewing. It also contains several minor bug fixes for ER/Studio Data Architect 16.5.0 (2016+). For users of ER/Studio Team Server 16.1.x, w (2016) we have also created a 16.1.6 patch...
2 Aug 2017
How to Monitor the Health of Database Instances
Determine the health of instances by collecting real-time statistics (including backup devices, databases, error logs, locks, logins, performance counters, processes, and agent errors). With the Server Statistics tool of SQL Admin Toolset , display a comprehensive list of real-time statistics for instances of SQL Server. This is how easy it is: Connect to one or more instances. Display the statistics of the...
28 Jul 2017
Monitor Microsoft SQL Server Performance and Availability with Uptime Cloud Monitor
Are you using Microsoft SQL Server? Use IDERA Uptime Cloud Monitor to monitor your Microsoft SQL Server performance. Prerequisites Uptime Cloud Monitor from IDERA (UCM) offers a SAAS based out-of-the-box solution for monitoring Microsoft SQL Server for performance and availability. If you are not familiar with the concept of custom metrics as used in Uptime Cloud Monitor, please go through Custom Metrics information...
27 Jul 2017
SQL Inventory Manager 2.4 General Availability
We are pleased to announce the general availability of SQL Inventory Manager 2.4. Existing users may access through the Idera Customer Portal . New users may download the trial version from the Idera Website . What's new is version 2.4? SQL Inventory Manager 2.4 delivers a number of user improvements to help database administrators assess, manage and report on complex SQL server environments. New reporting...
27 Jul 2017
Become an IDERA ACE Today!
Applications for the 2017 IDERA ACEs are now open! The search has begun for the 2017 IDERA ACEs. Do you have a passion in helping the community and sharing your knowledge? Then apply today! We help the IDERA ACEs pursue their passion by sponsoring travel to select events, offering guidance for soft skill training, and providing access to our extensive portfolio of database lifecycle management products. This...