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
18 Apr 2017
Why Should A Data Modeler Care About Business Processes?
Data Modelers are responsible for creating and maintaining conceptual, logical and physical data models. These data models are used to define the data requirements that support the business goals. Data modelers work closely with business stakeholders and users of the information systems. Business stakeholders want to see how the data is used in their business processes at a high level. They frequently get lost in the...
17 Apr 2017
What are Business Processes??
Business Processes are a set of tasks or activities that help an organization to define and communicate their goals, optimize their resources and improve productivity. Business Processes allow stakeholders to see: How the processes map to business goals and requirements How work gets accomplished How the processes throughout the organization interact with each other How value is created for the organization...
13 Apr 2017
Is your SQL drawing a blank? It's NULL a surprise!
The title of this post is a play on words, but very appropriate. We are going to discuss the inconsistent results, as well as performance implications of queries processing records with NULLS, or situations where we are expecting NULLS, but the records really contain blank values. Before we do that, a bit of trivia - what is the origin of the phrase "drawing a blank." The phrase is believed to come from...
11 Apr 2017
April #SQLChat Findings
Jim Donahoe ( @SQLFlipFlopsDBA ) hosted a #SQLChat on Wednesday, April 5 over Career Satisfaction within the SQL Space. This was a busy conversation with over 268 tweets generated with the hashtag #SQLChat. What did we learn? Not everyone needs fancy degrees or certifications to be a successful data professional. In fact, most of our Twitter Chat participants were accidental DBAs. To be a DBA,...
10 Apr 2017
Working with Glossaries in Team Server
Working with Glossaries in Team Server So Why Business Glossaries? A typical way of structuring glossaries is aligning glossaries to different areas of a business, focusing on terminology important to that business area. Also, structuring the glossaries in a hierarchy results in an overall corporate business glossary. [Definition of a Glossary] Glossaries are collections of terms, such as "Human Resources"...
6 Apr 2017
Announcing SQL Doctor 3.6 General Availability
We are pleased to announce the general availability of SQL Doctor 3.6. 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 small customer improvements and the following new features: What's New in SQL Doctor 3.6? Support for Cloud Environments Connect to SQL Server as deployed as an on-premise...
31 Mar 2017
Uptime Cloud Monitor - Monitor MySQL Performance and Availability
Are you using MySQL database in your application? You can use IDERA Uptime Cloud Monitor (UCM) to monitor your MySQL database performance. As an illustration, you can configure and receive alerts for the following scenarios: Performance: alert if the MySQL performance is poor. If the slow_queries value is significantly above its normal range, that would imply that the MySQL server is under heavy load. Bytes_received...
30 Mar 2017
Azure SQL Database - What a DBA Needs to Know
Moving your databases to "the cloud" won't eliminate the DBA job - but it will change it. Microsoft Azure SQL Database, in particular, has automated certain tasks the DBA used to be responsible for, and added new features that developers have embraced. Join Jes Borland ( @grrl_geek ) on Wednesday, May 24 at 11 AM CT to learn what features are available in Azure SQL Database. Participants will discuss their...
28 Mar 2017
World Backup Day on Friday, March 31, 2017
World Backup Day is a day for everyone to learn about the increasing role of data in our lives and how important regular backups are. This day is not only a day for backing up data, but it is also a day to discuss the massive task of preserving the increasingly digital heritage and cultural works for future generations. Apparently, the previous year produced more than 2.5 quintillion bytes or 2.5 exabytes of data. Moreover...
20 Mar 2017
Win a YETI on Twitter!
Happy First Day of Spring! Warmer weather is among us and to celebrate we are giving away a YETI Tundra 35 valued at $299.99. (photo taken from YETI.com ) To win all you have to do is: Follow us on Twitter ( @Idera_Software ) Reply to our tweet @Idera_Software and let us know where you and your IDERA duck would take your YETI this spring Sound easy? It is! This contest is open now until March 31.
16 Mar 2017
Announcing SQL Safe 8.4 General Availability
We are pleased to announce the general availability of SQL Safe 8.4, IDERA's premier backup tool. 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 a number of bug fixes and the following new features: What's New in SQL Safe 8.4? Embedded SQL Virtual Database Technology SQL Safe Backup...
15 Mar 2017
Keep Track of Database Performance with Uptime Infrastructure Monitor
Uptime Infrastructure Monitor Uptime Infrastructure Monitor (UIM) is an enterprise tool that provides a unified view for Information Technology systems monitoring. Although comprehensive and scalable, UIM is also easy to use and deploys in minutes. Through proactive, comprehensive, and integrated monitoring, reporting, and alerting, UIM gives complete visibility and control over the availability, performance, and capacity...
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...