This is part of a series of guest posts by Dan Hotka. Hi! This week I want to show how Rapid SQL can improve your coding productivity and technique...
Rapid SQL Code Templates by Dan Hotka
read more
blog
What Are SQL Elements Health Checks?
I have recently received a number of questions regarding Health Checks in SQL Elements, what are they, how often do they run, and what do I do with...
New Free Tool – SQL Update Statistics is available now!
Table statistics maintenance is an important part of overall SQL Server administration. DBAs understand a common cause of query performance problems...
Monitoring Disk Queue Length
Recently, I wrote a blog post about performance counters and why the threshold depends (Performance Counters: Why It Depends). In this post, I...
Executing Explain Plans Using Rapid SQL by Dan Hotka
This is a guest post from Dan Hotka, Oracle ACE Director. Learn more at his webinar Explain Plan Tips and Techniques. Hi! My name is Dan Hotka. I am...
SQL Heatmap is here – Idera’s newest free tool
Idera strives to bring helpful tools to the market for DBAs and Developers to complete daily tasks and a variety of these are free. Today we...
Seven Deadly Sins of Database Design
If you don’t get the data right, nothing else matters. However, the business focus on applications often overshadows the priority for a...
Quickly grouping events in SQL XEvent Profiler
As you may know, Idera has a number of free tools for SQL Server and we’re always coming out with new ones. Earlier this year we debuted SQL...
Survey: Oracle in your environment
A recent survey indicated a significant number of our customers use Oracle in their environment. Please help us better understand how we can help...
Precise for web shows only a location of All
You may notice that in Activity tab in Precise for web your location data only shows a Location Name for All. Although Precise is designed to show...
Survey: What database platforms are you using?
We are always looking for feedback to ensure we produce products that make your job easier. We’d very much appreciate if you’d take this short...
DBAs and Dinosaurs
You have to admit that title is catchier than yet another “Death of the DBA” blog. And that was exactly the direction I was headed until I ran a...
SQL diagnostic manager Secrets: Configuring Alerts
There are a lot of features in SQL diagnostic manager. In this series, I plan to let you know about features that many users never find. In...
Time for an Upgrade?
I don’t know about you, but deciding when to pull the trigger on an upgrade is not that easy for me. What is to be upgraded usually doesn’t...
Get Better Integration with SCOM using SQLdm SCOM Management Pack
It’s an age old problem in IT, one IT department has one standard and tools they use to manage their systems. Another IT department has another...
Survey: Idera’s new SQL Server job management solution
We are currently working on a new SQL Server agent job monitoring and management tool, to become available later this year. This first release will...
Achieve Better Automation with Idera’s SQL Diagnostic Manager
A seasoned SQL Server DBA has many skills, expertise and knowledge. Unfortunately, this also means that his/her time is always on demand by many...
Best Practices for Deployment of SQL Compliance Manager
So maybe you downloaded a trial of SQL Compliance Manager and want to play around with it. Or perhaps you already purchased licenses and want to...
AWS cost saving tip: Delete unused EBS volumes
Organizing EBS volumes and deleting detached volumes on a regular basis to can help decrease AWS spend. See how easy it is to identify, tag,...
Counter calculations in SQL Diagnostic Manager
Probably the three most common questions I get about counters in SQL Diagnostic Manager are: “How can I prevent alerting on temporary noise...
Most Popular FAQs for SQL Doctor
SQL Doctor is one of the most popular products in the Idera portfolio and as such we get a variety of questions from users on how it works, where do...
New SQLyog and MONyog coming – please upgrade soon!
We are about to release upgrades to both SQLyog and MONyog with an important fix: linked libraries possibly vulnerable to the 'Heartbleed'...
Five tiny features of SQL Diagnostic Manager you may not know about
SQL Diagnostic Manager has been around for a long time, and many of you have been using it for years. For today’s topic I thought it might be fun to...
Idera SQL XEvent Profiler – a free tool for XEvent monitoring
The Extended Events technology added to SQL Server in SQL 2008 and expanded upon greatly in SQL 2012 is a powerful mechanism for monitoring activity...