In RAD Studio XE7, we introduced the FireUI Multi-Device Designer. FireUI makes it easy to create user interfaces across multiple devices using a...
Blog
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...
Server Change Over
I am looking to upgrade my up.time server from a virtual Windows Server 2008 R2 running mysql to a physical Windows Server 2012 R2 running sql...
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...
Upgrade Errors with 8.5
Hi, I’m new to SQLdm. I’ve been tasked to upgrade from 8.01 to 8.5. During the upgrade process I get an error stating that it...
Bluetooth LE support in RAD Studio XE7
RAD Studio XE7's integrated wireless support (Bluetooth and Wifi) works with thousands of consumer and industry specific devices. RAD...
Metadata Overview, by Ron Huizenga
What is Metadata? The term “Metadata” arises frequently when discussing Data Architecture. In short, it is “data about data.” However,...
Granting Namespace Rights to DM Service Account
community.idera.com/.../Granting-Namespace-Rights-to-Service-Account-for-SQldm-Web-Console-Services.docx Useful document describing how to grant...
SQL Server – Server Node Reports for Troubleshooting
This is a guest post from Pinal Dave. For many DBAs, restless nights start when end users complain that the application using SQL Server is too...
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...
Solution: How to register SQL2014 in Defrag if it does not support this version?
I have registered SQL 2008, SQL2012 in my Defrag to monitor them. Then I tried to register SQL Server 2014 instance too. Defrag cannot register it...
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...
[PAClient Error] Error: E2820 Could not find program… zipalign.exe
This error message can occur when trying to deploy a mobile application to Android if you recently updated the Android SDK version that is being...
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...
Mobile User Interface Design: Navigation Drawer
Drawer menus are very popular since they allow you to take advantage of more screen real estate when building your app. The main application menu is...
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...