IDERA is pleased to announce the introduction of IDERA SQL DM Performance Insights, a Microsoft Azure Data Studio (ADS) extension which displays key...
Blog
Introducing the 2018-2019 Class of IDERA ACEs!
Introducing the 2018-2019 Class of IDERA ACEs! We are excited to introduce our 2018-2019 class of IDERA ACEs! This program helps active members of...
Aqua Data Studio's Powerful Data Grid
One of the most overlooked powerful features in Aqua Data Studio is the Data Grid. The data grid can double your productivity with Data Management....
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...