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
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...
4 Jan 2017
Storage Performance Optimization, I/O Efficiency
Improve Storage Performance
4 Jan 2017
How to Run PowerShell Scripts with Uptime Infrastructure Monitor
Introduction Microsoft PowerShell is an automation platform and scripting language for Windows and Windows Server that allows you to simplify the management of your systems. Unlike other text-based shells, PowerShell harnesses the power of the .NET Framework. PowerShell also provides rich objects and an extensive set of built-in functionality for taking control of your Windows environments. Combine PowerShell and...
24 Dec 2016
Comparing Database Virtual Machine Platforms
Oracle technologists, database architects, database administrators, and senior database application developers are all very curious people by nature – even more curious than most people. So naturally database oriented issues evoke debates similar to “tastes great, less filling” from the famous beer commercial. You might be surprised by the scope and passion of such database debates. One area getting...
24 Dec 2016
Virtualized Storage: Where have all my disks gone?
In the good old days most DBA’s could walk into their computing center and point to their database server and its disks. Furthermore, many DBA’s could also point to specific disks and state which database objects they housed. In fact database object placement and separation was a key tuning consideration back in the day. Oh my how times have changed. At first all database servers utilized direct attached...
22 Dec 2016
Run Book, Run!!!
How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains how to execute all your jobs and SSIS packages. In addition, I preference mine with all key elements someone might need, like where passwords are stored, architectures, backup times, where are backups stored, etc… then dig into the job steps. The purpose of this document is so that someone...
19 Dec 2016
Workload Analysis for SAP HANA General Availability
We are delighted to announce the general availability of Workload Analysis for SAP HANA. Workload Analysis for SAP HANA provides a granular breakdown of SAP HANA metrics with easy drill-down for isolating problems quickly. It delivers valuable real-time and historical data to tune SQL statements. Its dashboard displays trending database activity and top resource utilization to identify problems and develop resolutions...
16 Dec 2016
How Do You Create a Disaster Recovery Plan?
Get 2017 on a healthy start and participate in our January #SQLChat! Our next Twitter Chat will take place Wednesday, January 11th at 11 AM CT with Rie Irish ( @IrishSQL ). Rie will be leading a discussion on how to create your own disaster recovery plan. Having a plan to recover your business when disaster strikes is very important. This #SQLChat will help you learn how to build this plan by defining what a disaster...
15 Dec 2016
Annoying T-SQL Script error "Incorrect syntax near ' '."
I'm hoping you'll find this post useful as finally got my issue solved but kept me going in circle. As I'm use to integrate my T-SQL scripts into my PowerShell scripts, but first I need to verify that everything is working as expected. Well, I ended up getting this annoying error every time I executed a valid SQL script: " Msg 102, Level 15, State 1, Line 4 Incorrect syntax near ' '. "...
14 Dec 2016
DB2 Monitoring and Optimization - Index Recommendations & Modeling
This blog post explores a strategy for improving processing efficiency within IBM’s DB2 on LUW. The Precise product line is designed for monitoring and improvement. An idle database has static resource consumption and little contention. As resources are consumed, shortages develop resulting in waits, locks, contention, sub-optimal performance, and a ringing phone with users complaining. By tracking SQL statements...
13 Dec 2016
Golden Nugget : Naming Standards Templates
Howdy! Today we will be exploring a feature called Naming Standards Template. In a Naming Standards Template you can define standards for character case, or add prefixes/suffixes to make the object types more easily recognizable. The Naming Standards Templates is comprised of an abbreviation list used to automatically convert logical to physical names and vice versa, and options for a given model that define case...
2 Dec 2016
Flashback to the Rescue
Face it, we’ve all been there – that moment when we’ve done something a wee bit too fast and then realize we probably shouldn’t have done it. Then we often generally say something like “stupid database” or “stupid TOAD’ or “stupid whatever. But there are ways to recover without having to go hat in hand to the DBA and beg forgiveness and obtain a recovery. More recent...