blog
Big Data the BuzzWord by Pinal Dave
The talk of the town these days is around Big Data if you are in a data-related domain. Most of the top CIOs are trying to get onto this bandwagon...
5 Things Developers Must Know for Working with their Databases
This article by Pinal Dave looks at some of the developer traits that one must keep in mind while working with databases Being in the databases...
Auto Replace in Rapid SQL by Dan Hotka
Hi! Dan Hotka here with more knowledge about Rapid SQL. I’ll address the auto replace feature of this tool and how you can use this feature to...
Rapid SQL Query Builder Tips and Techniques by Dan Hotka
Hi! Don’t you just love a good SQL query builder? I found this tool in Rapid SQL easy to learn and easy to produce the SQL I desired. You start it...
SQL Traffic Accelerator as a DB performance tool
We get questions from time to time from folks asking what SQL Traffic Accelerator does for DBAs since it sounds like a network monitoring tool....
Mission Impossible? Effective Database Backup Strategies
Mission Impossible? Effective Database Backup Strategies Organizations use multiple strategies when working with backups. An effective restore...
Enterprise Data Confusion – Did We Bring This Onto Ourselves? – authored by David Loshin, Knowledge Integrity, Inc.
This is the first in a series of six posts from David Loshin. Read his next post. A few years back, I had the opportunity to work with...
SQL Syntax in Rapid SQL by Dan Hotka
Abstract: Guest blog post from Dan Hotka, Oracle ACE Hi! Wouldn’t it be handy to have some Oracle documentation such as SQL syntax right at your...
3 Leadership Tips defining Success
Every individual has their own set of leaders they look up to in their daily life. I am sure each and every one reading this blog post has a number...
SQL diagnostic manager Secrets: When is a report more than a report?
SQL diagnostic manager provides many different views of the data it collects. This lets you explore all available data when diagnosing tricky...
Preparing for Data Centric Interviews by Pinal Dave
These days the fundamentals of taking an interview have not changed much. The more experienced you are, the greater the likelihood of getting into...
Performance Improvements with SQL Server 2014
Whenever there is new model of any vehicle launched in the market, it is expected it should have some enhancements or new features which would make...
Rapid SQL Code Templates by Dan Hotka
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...
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...