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 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 firstname.lastname@example.org 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...
15 Jan 2017
Oracle Dynamic Scripting
Ever wanted to perform some operation against all the objects in a schema? For example a one-time management task to turn off parallel for all tables and indexes. Another example might be an on-going task to disable and later enable triggers and referential integrity to speed up a recurring data load job. These types of tasks are not uncommon, however many people don’t know how to leverage dynamic SQL scripting...
15 Jan 2017
How Data Modeling Can Save Money
It’s not uncommon to discover databases that have simply evolved over time rather than having been built according to some overall design or “master plan” . And there seem to be no shortage of answers as to why this occurs. Sometimes DBA’s are just far too busy with a myriad of other tasks. Sometimes developers are under the gun for deliverables so quickly that there’s just not time. Or my...
15 Jan 2017
Data Modeling Remains Relevant
There are those who think that data modeling has become very passé’ these days. The belief is that because data modeling theory is over thirty years old and that since some data modeling tools have been around 10-20 years that somehow data modeling is now no longer relevant. Nothing could be further from the truth. In fact data modeling may now be more necessary than ever before. While there are other...
15 Jan 2017
Data Proximity for Data Warehousing Performance
Data Warehousing DBA’s usually work with huge tables, often possessing hundreds of millions or even billions of rows. And occasionally, these DBA’s might need to perform maintenance that requires either recreating the entire huge table or some of its partitions. For example, the DBA might need to drop an unnecessary column or simply desire to de-fragment that table or some of its partitions (i.e. reduce the...
12 Jan 2017
Why Database Backup Compression Is Better Than Deduplication
I often run into situations where DBAs are having discussions with their Storage Administrator around not compressing database backups so that they can get better deduplication from storage devices like EMC Data Domain. The Storage Administrator has been telling them not to compress their backups. I will tell you why this can be a bad idea. What is deduplication? Appliances like EMC Data Domain sit between the server...
11 Jan 2017
February #SQLChat - Planning Ahead with Andy Yun
New Year, New Topics, New #SQLChat Hosts! Our next #SQLChat will take place February 8 at 11 AM CT with Andy Yun ( @SQLBek ) . Andy will lead a conversation on Planning Ahead - including how to plan for your server and technical issues as well as personal career needs. In this Twitter Chat, participants will discuss everything from how to plan for software deployments and a new database, to what you plan or anticipate...
11 Jan 2017
Happy National Rubber Ducky Day!
Our favorite holiday is almost here! National Rubber Ducky Day is Friday, January 13. To help celebrate this holiday we are sending you our newest IDERA duck for free! Take our personality quiz to find out which IDERA duck you would be, and share your results with all of your friends. Enter your email address at the end of the quiz so we can contact you and obtain your mailing address, and your new, limited edition...
10 Jan 2017
The Value of Data Modeling
How do you convince your management that data models are worth the time and effort they require? You may be dealing with challenges around the value your company places on their data compared to how that data is actually managed. It can be difficult to assign a dollar amount and calculate a return on investment, but this is often what the business stakeholders need to see in order to justify and validate the use of data...
6 Jan 2017
2017: A New Year with new projects?
2017: A New Year with new projects? I’m not big into new year’s resolutions. Too often they are just words that we never act on. When you stop and think about it, the dawning of a new year is just another day on the calendar: December 31 turns into January 1. Big deal, right? While we as individuals may scoff at new year’s resolutions, IT shops across the world make plans for the new year, building...
6 Jan 2017
Isolation Levels 101: Concurrency Issues
The other day I had a client complaining about slowness, queries erroring out, blocking and processes stopping; you know the usual complaints. So, like any other DBA I pulled out my handy dandy toolbox of queries to determine exactly what was going on with the server. Upon reviewing their current running sessions, I noticed that the Isolation Level for a simple UPDATE transaction was “Serializable” and all...