Blog

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...

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.

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 that...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...