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
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...
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...
17 May 2017
How Do You Approach a Performance Problem?
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...
16 May 2017
Discover 10 Lesser-known Capabilities of SQL Diagnostic Manager
Introduction This blog post describes ten lesser-known features of SQL Diagnostic Manager with links to short how-to videos and additional resources. Learn how to add custom counters and custom SQL scripts, capture deadlocks, integrate with SCOM, monitor application transactions, query waits, tempdb contention and virtualization metrics, and setup actionable responses, baselines, and custom dashboards. #1 Monitor...
12 May 2017
Monitor Microsoft Azure SQL Server Performance and Availability
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 ...
12 May 2017
Announcing General Availability of SQL Compliance Manager 5.4
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...
8 May 2017
Database Migration Made Easy
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...
3 May 2017
May the 4th Be With You!
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...
2 May 2017
Attend our Virtual Conference to Win Big!
Be a part of history and attend IDERA’s first Virtual Conference! IDERA Live is our first Virtual Conference designed to educate and inform users of any level in a fun, engaging atmosphere. Join some of the industry’s top speakers to guide you through compelling content and the biggest issues present in the IT world. You can expect top-notch training, industry tips and techniques, networking, and more! ...
27 Apr 2017
Configuring custom ports to a SQL Server Instance
Back in February 22nd 2017, I posted a blog about " Where is SQL Server Configuration Manager ". And, if you ever want to manage your SQL Server ports, this is the application we need to accomplished that tasks. As every SQL Server Administrator every knows, the default port is 1433, which in most cases can be left alone. But, you could change the default port to something different. Try to give it different...
26 Apr 2017
The best problem is no problem.
Making time to tune Oracle, scripting maintenance, allows Oracle DBAs to be truly proactive and deliver the best possible performance to application users.
25 Apr 2017
Combine PowerShell and SQL Diagnostic Manager to Automate SQL Server Monitoring
Run new and existing PowerShell scripts with SQL Diagnostic Manager and utilize the vast power of PowerShell via the customizable monitoring environment. Run scripts to automatically react to problems detected by the monitoring environment, deploy and manage the monitoring environment via cmdlets, connect existing scripts to the monitoring environment to automate their execution, and avoid writing certain scripts in the...
24 Apr 2017
How to run an application under an account of a different domain
Not too long ago, I came across a scenario where a user needed to launch an application (e.g. SQL Server Management Studio) to access SQL Server, not such an unusual scenario. The catch was that the user was running the application from his personal laptop, which was not part of the domain on which the SQL instance resided on. The other catch was that the SQL instance was not configured for SQL Server Authentication....