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
9 Mar 2017
Win a New Backpack in our April #SQLChat!
It's that time again! Participate in our April #SQLChat for your chance to win a new Herschel Supply Co. Backpack! Our next #SQLChat will take place Wednesday, April 5 at 11 AM CT with Jim Donahoe (@SQLFlipFlopsDBA). Jim will be leading a discussion on Career Satisfaction within the DBA space. What made you decide to become a data professional? What’s the difference between career and personal satisfaction...
8 Mar 2017
Fixing Database Performance Problems
There is no such thing as the perfect database. No matter how hard the DBA may try, something outside the planned norms will eventually occur and then performance will suffer. The good news is this means job stability for the DBA. But all kidding aside, what is one to do when database performance tanks and users are up in arms? There is a recommended approach – and it’s actually obvious once you realize that...
6 Mar 2017
How To Maximize AWS Cloud Reliability and Availability
What Happened? “ Typo blamed for Amazon’s Internet-crippling outage! ” and similar news headlines alerted to the five-hour service disruption that Amazon Web Services (AWS) suffered in its US-East-1 region in Northern Virginia on Tuesday, February 28, 2017. The outage affected its Simple Storage Service (S3) file storage. It also affected some other services in the area such as its S3 management console...
3 Mar 2017
Database Administrators and the Cloud
There’s no fighting progress. Decades ago database administrators managed and controlled everything – the OS, network, storage and database. Times have changed and DBAs have had to evolve (i.e. accept) well established principles of economics, namely specialization. Thus we have network administrators, storage administrators, virtualization administrators and database administrators. While it’s rarely...
3 Mar 2017
Databases will be Virtualized
I have written a book about Optimizing Oracle on VMware , plus have published papers and given presentations regarding the same. These basically all espouse essentially the same fundamental belief – that database virtualization is here to stay, and is rapidly moving towards mainstream (if not there already). But a couple legitimate questions or concerns are always brought up (and they are good questions). I’m...
3 Mar 2017
What’s Your Favorite Version of Oracle
I thought I’d write a quick blog this time and ask/think about what’s your favorite version of Oracle. Of course the proper answer is probably whatever version is mainstream right now – so maybe 11g R2. But what if you could enter Mr. Peabody’s “ Way Back ” time machine and once again live in any time you so desired. Then what version of Oracle would that be? Now don’t laugh...
1 Mar 2017
A Closer Look At SQL Safe's Backup File Deletion
One of SQL Safe's frequently used feature is the ability to automatically delete backups older than a certain time period. This feature, however, is often misunderstood in how it works under the covers. I'd like to take a closer look at this feature in hopes that it'll allow you to make better decisions when configuring your backup policy in SQL Safe. The option that I'll be talking about can be found...
24 Feb 2017
Uptime Infrastructure Monitor 7.8 now available. Download today!
We are pleased to announce the general availability of Uptime Infrastructure Monitor 7.8. Existing users may upgrade to this version through the Uptime Support Portal . New users may download the trial version from the Idera Website . In Uptime...
22 Feb 2017
Where is SQL Server Configuration Manager?
Well, I needed to make some configuration changes to my SQL Server instances I have installed on my developer machine but I notice I couldn't find the "SQL Server Configuration Manager". So, doing some search for this component I found the following Microsoft link: https://msdn.microsoft.com/en-us/library/ms174212.aspx This component is no longer available on your Windows application menu and I don't...
17 Feb 2017
Speaking at the Annual IOUG Collaborate Conference
I’ll be speaking at the annual IOUG Collaborate Conference in Las Vegas April 3 rd and 5 th . To quote their website: The Independent Oracle Users Group (IOUG), the Oracle Applications Users Group (OAUG) and Quest International Users Group (Quest) present COLLABORATE 17: Technology and Applications Forum for the Oracle Community. As an educational conference, COLLABORATE 17 helps users of the full family of Oracle...
17 Feb 2017
Speaking at the Annual Hotsos Symposium
I’ll be speaking at the annual Hotsos Symposium in Dallas TX February 27 th and 28 th . To quote their website: Hotsos is the best conference in the Americas devoted to Oracle system performance. The combination of topic focus, small audience size, and large speaker list make the Hotsos Conference an unsurpassed networking opportunity. The Hotsos Symposium reaches for a new technical high with presentations...
16 Feb 2017
Golden Nugget: Working with The Repository Security Center
ER/Studio Repository is a server-side model management system that solves the day-to-day challenges of modeling in a team environment, where model collaboration, versioning, security and component reuse are vital. The ER/Studio Repository allows multiple users to be extremely productive while collaborating on data and business process modeling projects with real-time concurrent access that allows team members to share...
14 Feb 2017
DB Tools Running Slow with Oracle
Often people will write or call to express that some database tool like DBArtisan or Rapid SQL seems generally sluggish or that some screens may appear to lock up, taking as long to refresh as the refresh cycle, when accessing Oracle 10g, 11g, or 12c databases. They are often especially frustrated since this problem did not occur with Oracle versions prior to 10g. So what is DBArtisan doing that’s wrong (i.e. is...
14 Feb 2017
SQL Diagnostic Manager 10.2 Beta
Some of you have already volunteered to participate in the SQL Diagnostic Manager 10.2 beta. For more information about how to add your name to our list of beta contributors, see the end of this posting. In the meantime, as we prepare to begin the be...
13 Feb 2017
Let’s Discuss Migrating to the Cloud!
It’s that time again! Our next #SQLChat will take place Wednesday, March 15 at 11 AM CT with Mike Fal . Mike will be leading a discussion on how to migrate to the cloud. Whether your company is considering Azure, Amazon Web Services, the Google Cloud, or any of the other providers, you will need a cloud strategy. However, with the cloud comes a different way of thinking. Mike will discuss the different options...
2 Feb 2017
Why Explain Plans May No Longer Matter
For far too long, database administrators and developers have focused on explain plans for tuning SQL statements that perform poorly. But with Oracle 11g and 12c , explain plans can quite possibly become a thing of the past. Furthermore, 12c can perform the entire tuning process automatically – with minimal time spent during the initial SQL development and maybe 1/10 th the effort spent addressing any problematic...
2 Feb 2017
BI Manager 2.2 Released
We are pleased to announce the general availability of SQL BI Manager 2.2 . Existing users may access through the IDERA Customer Portal . New Users may download the trial version from the IDERA Website . New Product Capabilities Historical Monitoring of SSAS Queries (MDX/DAX) This enhanced monitoring feature allows the user to turn on continuous logging of queries being executed on the SSAS instance. It allows users...
31 Jan 2017
Become a Community Member to Score a New Duck!
Still don’t have a Hippie Duck? They are back for a limited time only! The first 100 people to make a new account on the IDERA community will receive a free, limited-edition Hippie Duck! To get your duck, you must first join the community by creating an account here . Once that is done, you will want to fill out this form to receive your super hip duck! The IDERA community is a free resource for industry...
27 Jan 2017
erwin Announces DM 9.7 - Why All the Fanfare?
You may have seen erwin's recent press release contents announcing DM 9.7 on January 23rd, containing a number of new (to erwin) capabilities. We would like to commend our brethren for following the trail that ER/Studio blazed over 2 years ago, recognizing the importance of NoSQL platforms in particular. NoSQL is now mainstream and integral to the data architecture of organizations in all industry sectors. Thus, we...
25 Jan 2017
Review our Products for Free Swag!
Do you think strongly of our products? Have you had a good experience with a certain tool? We want to hear about it! Through February, those that write a review on IT Central Station of either SQL Diagnostic Manager Pro or ER/Studio Enterprise Team Edition will get special IDERA swag delivered their way! Please email email@example.com with a link pointing to your review and your gift will be on its way. Don’t...
24 Jan 2017
Saving Changes to Database Tables in SSMS
Let say you just build a new SQL Server and, while designing some tables in a databases, you realized there are changes, or adding, to some fields as requirements will sometimes change. So, when complete your tables field(s) changes, and when you save the changes, you ended up getting a popup error " Saving changes is not permitted. ...". If this was changes done to a production system, then this popup message...
23 Jan 2017
How Can SQL Workload Analysis Help You?
To find the key points of how SQL Workload Analysis can help you, look for the ducks throughout this blog post! What Is SQL Workload Analysis? It is an add-on to SQL Diagnostic Manager and a component of the IDERA Dashboard. This dashboard is the central portal for several tools from IDERA. These tools include tools for security, backup, business intelligence, and inventory management. Figure 1: In the IDERA Dashboard...
16 Jan 2017
What Did We Learn in Our January #SQLChat?
IDERA hosted a Twitter Chat with Rie Irish ( @IrishSQL ) on Wednesday, January 11 at 11 AM CT. Participants discussed how to create a disaster recovery plan by defining what a disaster could be, who their stakeholders are, and how they test their plan. This #SQLChat created lots of conversation on Twitter, with over 257 tweets generated with the hashtag #SQLChat. Also, congrats to David Maxwell (@dmmaxwell), winner...
15 Jan 2017
We Don’t Need No Stinking Modeling Tool
You’ll have to forgive me for spoofing the famous movie line “We don’t need no stinking badges” (Treasure of the Sierra Madre, 1948 and Blazing Saddles, 1974), it just seemed quite apropos. I was discussing data modeling needs recently with a potential customer – and like many shops I visit, they saw no need for data modeling. That their DBAs, data administrators and application architects...
15 Jan 2017
Oracle Parallel Query Abuse
Oracle’s Parallel Query Option (PQO) is a fantastic tool. But much like any good tool, it can very easily be used in the wrong situation or simply abused. In those cases, PQO can actually make database performance much worse. Let’s examine some common misuses or misperceptions regarding optimal and efficient PQO usage. PQO make sense universally on any SMP or multi-processer database server. Not...