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
20 Oct 2017
Using Business Processes for Data Governance
Business Processes can be a huge asset for you when you are trying to define your Data Governance Policies. While they aren't specifically a data governance tool they can help you and your organization to identify areas where you should be engaging processes to implement the regulatory guidelines. Some regulatory guidelines (like GDPR which goes into affect May 25, 2018) state that you must define your business processes...
20 Oct 2017
Database Performance Evolution
Imagine that you’re the lead DBA managing a high profile, mission critical production database whose application processes $20 million per hour. The database schema design is complex with approximately 1,000 tables and 1,500 indexes. Moreover the application code and its SQL statements were written by many different developers over the years with varying SQL programming skills. In short it’s your typical DBA...
18 Oct 2017
HIPAA Compliance for Data Professionals
While medical facilities are most at risk for a HIPAA violation, most organizations in the United States have to comply with the law and can be hit with civil and criminal penalties. Participate in our next Twitter Chat on November 29 at 11 AM CT with host K. Brian Kelley ( @kbriankelley ) as he leads a community discussion on meeting HIPAA compliance with your databases. What challenges are you having? What can you...
12 Oct 2017
New Free Tool: SQL Data Profiler
IDERA released a new free tool, SQL Data Profiler , designed to provide quick visibility into data patterns contained in SQL Server databases. Its intuitive user interface simplifies exploring patterns in data by streamlining and automating the process. Quickly view a summary of the data in selected database tables and columns, and receive recommendations based on the data in the columns. With the free tool, profile...
5 Oct 2017
Announcing SQL Safe 8.4.2 (patch release) General Availability
We are pleased to announce the general availability of SQL Safe 8.4.2, 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, most of which will improve the user experience within the SQL Safe Web Console. For a more detailed list of bug fixes, please...
2 Oct 2017
Data Governance Questions You Should Be Asking
October is National Cybersecurity Awareness Month. Many large data breaches have topped news headlines. With all of this great conversation taking place, it's a perfect opportunity for technical stakeholders and business stakeholders to come together and review their Data Governance Policies. There are 5 Pillars in Data Governance: Data Quality Data Definitions Data Lineage Data Modeling Data Access...
28 Sep 2017
SQL Workload Analysis 1.6.1 General Availability
We are pleased to announce the general availability of SQL Workload Analysis 1.6.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 includes the following features: What’s New in Workload Analysis 1.6.1? Top Stored Procedure/Batch Drilldown . Identify which Stored Procedures are consuming the most...
27 Sep 2017
Automatic Alert Response
We'd like to know if you've automated alert response. Script execution on a particular condition can improve availability and enhance DBA productivity. Click on this blog title "Automatic Alert Response" to take the poll. How To Configure Automatic Alert Response in Precise
26 Sep 2017
October #SQLChat - Adult Learning
IT is a fast moving profession. If you aren't keeping up you are falling behind. Participate in our next #SQLChat on Wednesday, October 18 at 11 AM CT with Kenneth Fisher ( @sqlstudent144 ). Kenneth will be leading a discussion on learning within your career space. What’s the new shiny thing that SQL professionals should be learning? Linux? Python? DevOps? What are your favorite methods of learning? What...
26 Sep 2017
Announcing the general availability of Uptime Infrastructure Monitor 7.8.3
IDERA is pleased to announce the general availability of Uptime Infrastructure Monitor 7.8.3 . Existing users may upgrade to this latest version via the online downloads . New users may download the trial version from the IDERA Web...
18 Sep 2017
WE'LL SEE YOU AT PASS SUMMIT 2017!
It’s that time of year again! IDERA is excited to see everyone at PASS Summit 2017! This year’s summit will take place from November 1 st -3 rd at the Washington State Convention Center in Seattle, Washington. The exhibit hall will be open from Wednesday (November 1) to Friday (November 3). IDERA will be located at booth 112. Come check us out! What to expect this year at the summit: More than 5,000...
5 Sep 2017
Instantly Access Data in Backup Files to Improve Database Continuity
SQL Server databases are often repositories for large volumes of business-critical data. As the sizes of databases grow, restore operations become time-consuming. Database professionals need to access data in backup files quickly to reduce recovery time and increase application and business availability. Learn how to instantly access your data in backup files via several conventional and advanced recovery capabilities...
4 Sep 2017
IDERA ER/Studio Repository Database Setup and Ports - Part 1 - SQL Server
Howdy! In this latest blog post, I will be covering the Database setup one would need for our IDERA ER/Studio Repository. Pre-requisites: SQL Server 2012-2016 (Standard and Above) SQL Server Configuration Manager Enable TCP Ports The default port is 1433. You may add your custom Port. View Article here.. Enable Repository Ports in your Windows Firewall View Article here.. H ere are the list of ports that...
31 Aug 2017
How to Tune the Performance of SQL Server, Azure SQL Database and Amazon RDS
SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance information, analyze it, and determine the resolution in minutes rather than hours. Leverage proven industry best practices endorsed by Most Valuable Professionals (MVPs) to analyze the performance and to provide recommendations. Target some of the most common areas of performance...
30 Aug 2017
Tell Me A Data Story - Part Two
Our new 2 minute video, "Tell Me A Data Story - Part Two" tells the story of a growing business that realizes that things are quickly getting out of hand. In the video, we look at how a business can use Business Process Models to identify places where they can have increased growth and data captured. (Please visit the site to view this video) Understanding the Concepts in this Video Business Stakeholders...
30 Aug 2017
IDERA’s Hurricane Harvey Relief Efforts
As many of you know, Houston is currently experiencing catastrophic flooding. Houston has a special place in our hearts as it is the home of IDERA Headquarters and many of our employees and valued customers reside there. To help with recovery efforts, we will send you a free “Texas Duck” with a $10 donation made to Houston Pets Alive. And, as a thank you, IDERA has agreed to match donations up to $15,000...
29 Aug 2017
IDERA WILL BE AT MICROSOFT IGNITE 2017!
For the first time, IDERA will be exhibiting at Microsoft Ignite! We are so excited to be a part of this event, taking place from September 25 th -29 th at the Orange County Convention Center in Orlando, Florida. The exhibit hall will be open from Monday (September 25) to Thursday (September 28). IDERA will be located at booth 2215. Come by and say hi and enter to win one of 3 Apple watches! Please register for Ignite...
28 Aug 2017
Tell Me A Data Story - Part One
Our new 2 1/2 minute video, "Tell Me A Data Story - Part One" tells the story of a small business who realizes that they need to implement a new software solution in order to meet the growing demands on their business. In the video, we look at how a Data Modeler can work to help businesses turn their visions for their software into a reality. (Please visit the site to view this video) Understanding the...
23 Aug 2017
Will the Traditional DBA Role be Eliminated with Cloud?
The cloud is all the buzz lately. New features like Automatic Tuning and Active Geo-replication are now being offered by AzureDB with the majority of their package offerings. Automatic Tuning is a free service! How can a traditional DBA compete with such things? Join us for our next #SQLChat on Wednesday, September 13 with Jim Donahoe ( @SQLFlipFlopsDBA ) as he leads a discussion on the state of the DBA. This #SQLChat...
20 Aug 2017
New Book - Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability
I've teamed up with two world class Oracle ACE Directors to create a new book - Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability . This book will cover every tool and technique DBAs should be aware of for performance and scalability testing of their Oracle 12c databases whether on premise or in the cloud.
17 Aug 2017
How to Ensure That Databases Are Backed Up On a Regular Basis
Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases. Determine which databases are not backed up within the last specified number of days.Display the last backup time stamp for each database. Display the last backup time stamp for each database. Drill down into the complete backup history for a specific database. Display...
17 Aug 2017
Announcing the General Availability of DB PowerStudio 16.6.1
IDERA is pleased to announce the general availability of DB PowerStudio 16.6.1 . Existing users may upgrade to this latest version via the online downloads . New users may download the trial version from the IDERA Website . DB Optimizer 16.6.1 substantially improves SQL rewrite speed and reliability via a superior new data dictionary lookup and caching mechanism. Moreover, DB Optimizer also removes the requirement that...
15 Aug 2017
Got PostgreSQL? Monitor with Uptime Cloud Monitor
Use IDERA Uptime Cloud Monitor (UCM) to monitor your PostgreSQL database for availability and performance. Prerequisites Uptime Cloud Monitor from IDERA offers a SAAS based out-of-the-box solution for monitoring PostgreSQL for performance and availability. If you are not familiar with the concept of custom metrics as used in Uptime Cloud Monitor, please go through Custom Metrics information once before continuing...
15 Aug 2017
How to Analyze the Health of Database Indexes
To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases. For this purpose, display these statistics of indexes: The percentage of rows modified since statistics were last updated. The percentage of updates to the total number of times the index is accessed. The columns affected by the statistic. Whether the index is clustered or disabled...
14 Aug 2017
Use SQL Safe Backup's Monitor Only Policies with customized backup operations
In my previous blog post , I wrote about how customized backup/restore solutions can be accomplished through the use of SQL Safe Backup's command line interface (CLI) and/or extended stored procedures (XSPs). I'm certain that some SQL Safe Backup users have customized their own backup jobs through the use of the CLI and XSPs. In this post, I'd like to extend on that subject a bit and talk about monitoring...