Featured Blog
Empowering Law Firms: How SQL Server and Idera Tools Safeguard Legal Data
November #SQLChat – Let’s Talk About Data Analysis!
A solid data analysis process and capable tools are key components of a strong data professional's skill set. Join IDERA (@Idera_Software) and...
Learn more about SQL Server statistics
Statistics, or “stats,” are fundamental components of SQL Server performance, but vastly under-appreciated and misunderstood. They are...
Reverse Engineer SnowFlake from IDERA ER/Studio
Howdy! In this short and concise blog post, I am really excited to be sharing on how to reverse engineer from ER/Studio via ODBC. Step 1 -->...
New in 10.3: IDE UI Improvements in the Main Window
In recent RAD Studio releases, we’ve paid a lot of attention to the IDE’s user interface. In 10.2.2, we added a dark theme (one of the most popular...
Data Architecture: The Foundation for Enterprise Architecture and Governance
"Data modeling is all about understanding the data within our organizations and then representing this data in a precise visual (the...
How to balance database security versus database performance
The security of any database can be improved. However, that likely degrades the performance of the database. The cost increases to improve database...
How to Find and Fix SQL Server Deadlocks
Introduction Locking is required for concurrent operations of relational databases to prevent data inconsistency and loss. However, locking impairs...
Data Modeling Still Important in a Big Data, Analytics World
As more organizations embrace big data and analytics to gain insight from extremely large data sets the tools and systems that we use to manage data...
GDPR vs CCPA – A Quick Look
On June 28th, 2018, California enacted the California Consumer Privacy Act (CCPA). It will go into effect on January 1, 2020. Guidelines must...
Webinar Replay: Simplify Data Change Tracking with InterBase
On October 17, I did an InterBase webinar on using Change Views to simplify data change tracking. Change Views allows you to reduce your...
Level Up Your UI Design Skills
You’re short on time, and cash, so where can you go to learn new skills to improve your app UIs? There are a ton of free, or nearly free, on-demand...
How to Monitor the Performance of MySQL and MariaDB Databases – Part 3
This is the third part of a three-part series of blog posts. Read also the first part and second part. Analyze Queries In addition to...
Touch-Friendly Navigation for Mobile Apps
Over 20% of users abandon an application after using it the first time (per Localytics). How can you design your mobile app to avoid being one of...
DBA Paradox – Plus ca change, plus c’est la meme chose
The quote comes from Jean-Baptiste Karr. And while some may not be familiar with the source and that original language version, almost...
These are a few of my Favorite Macros!
Howdy! ER/Studio Users, Prospective Users and Data Modeling Enthusiasts.. In this short blog post , I would like to list out some of my Favorite...
Embarcadero Releases AppAnalytics Server Source Code
What is AppAnalytics? A few years ago, Embarcadero introduced the AppAnalytics technology, a simple and effective way to add in-app analytics to VCL...
Dave’s Thoughts on UI Design – Index
I'm a big proponent of practical, usable UIs that are easy to understand and pleasant to look at. As an ongoing series, there are a number...
How to Monitor the Performance of MySQL and MariaDB Databases – Part 2
This is the second part of a three-part series of blog posts. Read also the first part. Click here to view the third part. Get Overview The...
How To Design a Great UI – Part 3
Welcome back! This is the third post on a series on practical UI design, an approach to creating usable, good-looking UIs when you are not a UX...
We’ll See You at PASS Summit 2018!
It’s that time of year again! IDERA is excited to see everyone at PASS Summit 2018! This year’s summit will take place from November...
C++ Libraries in GetIt: MurmurHash 3
An ongoing project we have is to ensure more popular, well-known C++ libraries are updated to work with C++Builder, and available to you from within...
How to Set Up MySQL 8 Cluster Replication
In the Setting up Basic Master-Slave Replication in MySQL 8 blog, we went through the process of setting up two MySQL servers on the same box for...
The Delphi Compiler and UTF-8 Encoded Source Code Files With no BOM
Last week a (large) customer sent me an email indicating he was experiencing issues when compiling the same project on different machines. Turned...
How to Monitor the Performance of MySQL and MariaDB Databases – Part 1
This is the first part of a three-part series of blog posts. Click here to view the second part. Overview SQL Diagnostic Manager for...
How To Design a Great UI – Part 2
Welcome back! Last time, we discussed a typical UX design flow, and how to tackle this if you do not have access to a UX designer. We also looked at...
Save this Page: All the Patches Since the Last Release
How can you be sure you’ve applied the latest updates for your RAD Studio, Delphi, or C++Builder version? After installing the IDE, there may be...
What’s New and Updated in GetIt for October 2018
GetIt is the package manager built into RAD Studio, Delphi, and C++Builder. It includes 214 packages in 8 different categories. 38 Library packages...
How to Build Effective Data Visualizations
A tool like Aqua Data Studio provides a rich canvas for creating data visualizations. While these charts, graphs, etc. can be eye candy, without...
Photos of September Delphi Events: London and Utrecht
Delphi User Group Meeting, London A couple of weeks ago I was in London for personal reasons and teamed up with the UK Developers Group to attend...
Announcing SQL Safe Backup 8.5.1 General Availability
We are pleased to announce the general availability of SQL Safe Backup 8.5.1. Existing users may upgrade to this version through the IDERA Customer...