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
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...
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...
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...
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...
17 Jul 2017
Setting up an Apache Web Server in Debian using Google Cloud
Setting up an Apache Web Server in Debian using Google Cloud Howdy! In the previous tutorial, we showed you all how easy it was to setup a Linux Distribution in the Google Cloud. Well, today we will be using that very same VM and installing the Apache Web Server and testing it out. Launch your instance and login to the SSH Prompt Now run the following command in the Linux Shell sudo apt-get update You...
14 Jul 2017
Database Execution Plans Can Lie
Quote: Do not put your faith in what statistics say until you have carefully considered what they do not say. ~William W. Watt. I started this blog with that quote because I find that database execution plans can sometimes behave very much like statistics – you need to question what they really say. For example many DBA’s and SQL developers live by the rule “ the lower the cost of an execution plan...
14 Jul 2017
Fireproof Your DBA Career in our Next Twitter Chat!
Is your DBA career fireproof? Let’s discuss the things that can get you fired and make sure you’re not doing them. Our next #SQLChat will take place on Wednesday, August 23rd at 11 AM CT with Robert Davis (@SQLSoldier). There are things that many DBAs do (or fail to do) for which they can and should be fired. This #SQLChat will help you fireproof your job security and make you a master at making sure...
11 Jul 2017
Setting up a Linux VM using Google Cloud
Howdy! In this blog post, I will be showing you all on how to setup a new Linux VM in Google Cloud. If you are new to Google Cloud, I would highly suggest viewing this video https://www.youtube.com/watch?v=uiy456tEUww In your project click on the Compute Engine in the navigation bar. Click on VM Instances Click on the create button We will be using a Debian Distribution Give your instance a name and...
11 Jul 2017
Go Mobile with Uptime Cloud Monitor
Uptime Cloud Monitor provides essential monitoring capabilities, giving you everything you need to identify and react to cloud infrastructure and application issues. Now you can monitor servers and websites in real-time and receive push alert notifications any time, any place with our updated iPhone and Android apps available for download on iTunes App Store and Google Play. The iOS Mobile App for UCM has been updated...
29 Jun 2017
Which Database is Best?
I’m often asked by people “Which database is best?” That’s an extremely subjective question which nonetheless can be answered objectively. If by best they mean which database I prefer, then the answer is obviously Oracle. I’ve spent over 30 years working with Oracle databases. I’m an Oracle ACE, routinely speak at Oracle events, and have written 10 books mostly on Oracle database...
26 Jun 2017
What is BPMN?
IDERA's ER/Studio Business Architect allows you to draw both Conceptual Models and Business Process Models. Business Process Models use the BPMN standard. The first version of BPMN was released in May of 2004. Since then organizations have been using this notation to help to identify their business processes. In case you are unfamiliar with BPMN, here is a 3 ½ minute BPMN primer that explains what BPMN...
26 Jun 2017
Ducky Indices Part II
Oracle Standard Edition Performance
23 Jun 2017
Database Continuous Delivery - It’s Not as Scary As You Think
Database continuous delivery can be a scary topic for database administrators. This requires the DBA to start trusting tools & processes, and that’s like pulling whitening from a bull ox. However daunting, this is becoming a hot new buzz term in-conjunction with “devops”. Join John Morehouse (@sqlrus) for a Twitter Chat on Wednesday July 19th at 11 AM CT to get more information about database...
22 Jun 2017
How to Secure Your Data in the Cloud
What happened? On Monday, June 12, 2017, a security researcher discovered that sensitive personal data of nearly all the 200 million registered voters from the USA was left exposed to the Internet. How did this happen? The owner stored the data on a publicly accessible cloud server -- Amazon Simple Storage Service (S3) object storage -- without any protection against public access. Consequently, anyone with an Internet...
20 Jun 2017
Monitor MongoDB with Uptime Cloud Monitor
Are you using MongoDB? If so, you can use IDERA Uptime Cloud Monitor (UCM) to monitor your MongoDB for availability and performance. Prerequisites Uptime Cloud Monitor from IDERA offers a SAAS based out-of-the-box solution for monitoring a MongoDB instance for availability and performance. If you are not familiar with the concept of custom metrics as used in Uptime Cloud Monitor, please go through Custom Metrics information...
20 Jun 2017
Smell Like Flowers With Ducky Indices
Optimal Oracle Index Performance