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 May 2017
How Do You Approach a Performance Problem?
We all see performance problems on a regular basis. Some look to hardware first, some look to logical design. We all turn to IDERA and other tools. Our next #SQLChat will take place on Wednesday, June 28 at 11 AM CT with William Wolf (@sqlwarewolf). William will be discussing triaging performance issues including methodologies for best practice and best results. This #SQLChat will allow members from the SQL community...
16 May 2017
Discover 10 Lesser-known Capabilities of SQL Diagnostic Manager
Introduction This blog post describes ten lesser-known features of SQL Diagnostic Manager with links to short how-to videos and additional resources. Learn how to add custom counters and custom SQL scripts, capture deadlocks, integrate with SCOM, monitor application transactions, query waits, tempdb contention and virtualization metrics, and setup actionable responses, baselines, and custom dashboards. #1 Monitor...
12 May 2017
Monitor Microsoft Azure SQL Server Performance and Availability
Are you using Microsoft Azure SQL Server in your application? You can use IDERA Uptime Cloud Monitor to monitor your Microsoft Azure SQL Server performance. Prerequisites Uptime Cloud Monitor from IDERA offers a SAAS based out-of-the-box monitoring ...
12 May 2017
Announcing General Availability of SQL Compliance Manager 5.4
We are pleased to announce the general availability of SQL Compliance Manager 5.4. 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 customer improvements and the following new features: What's New in SQL Compliance Manager? Support for Extended Events Users will be able to select...
8 May 2017
Database Migration Made Easy
One rare task that many DBAs fear is that of a database migration, say from Oracle to SQL Server as an example. There are many reasons for this discomfort – including overall complexity and possible lack of experience with the new database platform. That’s why possessing robust multi-platform DBA tools like DBArtisan are popular – for DBAs managing many different database types. But can DBArtisan also...
3 May 2017
May the 4th Be With You!
Do. Or do not. There is no try. May the 4th is National Star Wars Day and IDERA is excited to celebrate. Keep your database universe Safe with the Force. With IDERA’s SQL Safe Backup, you can automate backups across all your SQL Servers and recover data from backups without restoring. This tool will also help you backup faster and save space via dynamic compression with encryption. The newest version of SQL...
2 May 2017
Attend our Virtual Conference to Win Big!
Be a part of history and attend IDERA’s first Virtual Conference! IDERA Live is our first Virtual Conference designed to educate and inform users of any level in a fun, engaging atmosphere. Join some of the industry’s top speakers to guide you through compelling content and the biggest issues present in the IT world. You can expect top-notch training, industry tips and techniques, networking, and more! ...
27 Apr 2017
Configuring custom ports to a SQL Server Instance
Back in February 22nd 2017, I posted a blog about " Where is SQL Server Configuration Manager ". And, if you ever want to manage your SQL Server ports, this is the application we need to accomplished that tasks. As every SQL Server Administrator every knows, the default port is 1433, which in most cases can be left alone. But, you could change the default port to something different. Try to give it different...
26 Apr 2017
The best problem is no problem.
Making time to tune Oracle, scripting maintenance, allows Oracle DBAs to be truly proactive and deliver the best possible performance to application users.
25 Apr 2017
Combine PowerShell and SQL Diagnostic Manager to Automate SQL Server Monitoring
Run new and existing PowerShell scripts with SQL Diagnostic Manager and utilize the vast power of PowerShell via the customizable monitoring environment. Run scripts to automatically react to problems detected by the monitoring environment, deploy and manage the monitoring environment via cmdlets, connect existing scripts to the monitoring environment to automate their execution, and avoid writing certain scripts in the...
24 Apr 2017
How to run an application under an account of a different domain
Not too long ago, I came across a scenario where a user needed to launch an application (e.g. SQL Server Management Studio) to access SQL Server, not such an unusual scenario. The catch was that the user was running the application from his personal laptop, which was not part of the domain on which the SQL instance resided on. The other catch was that the SQL instance was not configured for SQL Server Authentication....
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...