Blog

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

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

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

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

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

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

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

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

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

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

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

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

We all see performance problems on a regular basis. Some look to hardware first, some look to logical design. We all turn to IDERA and other tools. Our next #SQLChat will take place on Wednesday, June 28 at 11 AM CT with William Wolf (@sqlwarewolf). William will be discussing triaging performance issues including methodologies for best practice and best results. This #SQLChat will allow members from the SQL community...

Are you using Microsoft Azure SQL Server in your application? You can use IDERA Uptime Cloud Monitor to monitor your Microsoft Azure SQL Server performance. Prerequisites Uptime Cloud Monitor from IDERA offers a SAAS based out-of-the-box monitoring ...

We are pleased to announce the general availability of SQL Compliance Manager 5.4. 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 various customer improvements and the following new features: What's New in SQL Compliance Manager? Support for Extended Events Users will be able to select...

One rare task that many DBAs fear is that of a database migration, say from Oracle to SQL Server as an example. There are many reasons for this discomfort – including overall complexity and possible lack of experience with the new database platform. That’s why possessing robust multi-platform DBA tools like DBArtisan are popular – for DBAs managing many different database types. But can DBArtisan also...

Do. Or do not. There is no try. May the 4th is National Star Wars Day and IDERA is excited to celebrate. Keep your database universe Safe with the Force. With IDERA’s SQL Safe Backup, you can automate backups across all your SQL Servers and recover data from backups without restoring. This tool will also help you backup faster and save space via dynamic compression with encryption. The newest version of SQL...