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
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...
27 Jun 2017
The Dimensional Model Plan
This article is written by Ryan Casey of AIM Report Writing . While working in Michigan (Ann Arbor), I needed to explain how, or where to start a star schema dimensional model. A previous employee had created a data warehouse in third normal form. He had also started working on a data mart intended to de-normalize the 3NF data warehouse. I had been asked by a team of dba's, app dev, data scientists, and middle managers...
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
19 Jun 2017
SQL Diagnostic Manager 10.2 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 10.2. 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? Time-based drilldown in SQL Diagnostic Manager. Select any time range on any graph to zoom in for...
19 Jun 2017
Customized Solutions Using SQL Safe Backup's XSPs
During my days as a Technical Support Engineer here at IDERA, I’d occasionally encounter a customer trying to do something that’s not directly available in the SQL Safe Management Console and/or the SQL Safe Web Console. Some of these things that were possible through the use of SQL Safe Backup’s Extended Stored Procedures (XSPs) and/or SQL Safe Backup’s Command Line Interface (CLI). Let’s...
15 Jun 2017
Announcing General Availability of DB Power Studio 16.6
We are pleased to announce the general availability of DB PowerStudio 16.6 . Existing users may upgrade to this latest version via the online downloads . New users may download the trial version from the IDERA Website . DB PowerStudio combines four innovative products ( DBArtisan , Rapid SQL , DB Change Manager and DB Optimizer ) to help database professionals build and maintain mission-critical database systems, streamline...
12 Jun 2017
Join the Team - Talk Back
Those of you who have endured a product roadmap session with me know that the insight into our direction comes with a price. That price is me badgering you about your own plans and priorities, how you plan to use any suggestions you make, whether you agree with our current direction, what you would do differently or prioritize lower, etc., etc., etc. If that sounds needy and neurotic, then I am communicating accurately...
12 Jun 2017
Getting the Most from Your Software Vendor
This topic is relevant to more than just Idera and it comes from experience working for and with multiple software vendors in multiple industries. The simple realization is that certain customers seem to know how to gain advantages beyond the purchases and products they own. So I am revealing the secrets that those select few have discovered on their own. The thought of revealing software vendor secrets makes me feel...
10 Jun 2017
Modeling Graph Data Stores in ER/Studio
Modeling Background Enterprise data environments have become increasingly complex due to a proliferation of different technologies and data platforms. A given organization may have hundreds of different data stores including multiple relational database platforms, document stores and a variety of NoSQL platforms. The rate of adoption for NoSQL varies greatly. Many organizations have had remarkable success, while others...
8 Jun 2017
History of the IDERA Duck
We know what you’re all thinking - what’s the deal with the Rubber Ducks? If you’ve attended a conference we've sponsored, or downloaded a trial off an IDERA email blast, chances are you’ve received an IDERA duck in the mail. Overall, we’ve had over 26 different types of IDERA ducks. Named “Quacky,” these ducks are a special member of our IDERA family and bring a little...
7 Jun 2017
Oracle In-Memory Speed Demon
Since the dawn of database technology the Achilles heel or key limiting factor has been disk IO. In order to address this issue traditional spinning disk drive vendors historically offered 10K and even 15K RPM models. But more speed was needed. Then came Solid State Disks or SSDs, where depending upon the underlying technology (SLC vs. MLC vs. TLC) the speed increase vs. spinning disk was from between 10X to 100X. However...
1 Jun 2017
Isolation Level 101 -- Part 2: SQL Server Solution to Concurrency Issues
SQL Server Solution to Concurrency In my previous post ( Isolation Levels 101: Concurrency Issues ), I discussed Concurrency Problems that can sometimes happen during execution of statements. In Part 2, I am going to discuss how SQL Server uses locks t...
30 May 2017
Tutorial : Setting up ER/Studio Repository with Microsoft SQL Server in Amazon Web Services
Howdy! In this series, we will explore on how easy it is to setup our Model Repository in the Amazon Web Services Cloud Environment. Now I will not be going through setting up an AWS EC2 instance etc. However, I will guide you through the steps you would need in order to successfully setup the Repository. [Step 1 --> Choosing the Correct Virtual Machine from the Gallery] My personal fav is the SQL Server...
23 May 2017
Big Data is a Big Deal
Data is proliferating at an accelerated rate, with all the mobile and desktop apps, social media, online purchasing, and consumer loyalty programs available today. All of these data sources have not just changed the way we operate on a day-to-day basis, but it has immensely increased the volume, velocity, and variety of data being created. Faced with this growing trend, data professionals now often have to look beyond...
19 May 2017
Announcing General Availability of SQL Secure 3.1
We are pleased to announce the general availability of SQL Secure 3.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 of SQL Secure offers new, robust cloud functionality for the Microsoft Azure ecosystem and hybrid cloud environments, as well as adding several significant new security checks which are relevant...