We had a lot of great entries in our RAD Studio 10.3 Rio t-shirt design contest. The top 10 most popular designers, based on community vote, and 10...
Blog
Five database administration mistakes that can cost you your job
Everyone makes mistakes. Database administrators are no exception to that rule. When database administrators make mistakes, they are often the ones...
Announcing SQL Admin Toolset 1.9.2 General Availability
We are pleased to announce the general availability of SQL Admin Toolset 1.9.2. Existing users may upgrade to this version through the IDERA...
SQL Performance, Part 1: Relational Optimization
Application developers must code efficient SQL and understand how to optimize SQL in order to develop efficient applications. But it is not just the...
New in RAD Studio 10.3: Options Dialog Improvements
In RAD Studio 10.3, we’re making a number of great improvements to the user interface and usability. Concretely, that’s not just looks: we are...
Announcing SQL Inventory Manager 2.5 General Availability
We are pleased to announce the general availability of SQL Inventory Manager 2.5. Existing users may upgrade to this version through the IDERA...
Android Z-Order, Native Controls, and 10.3 Rio
Before 10.3 Rio when you used a a platform-native control, like TWebBrowser or TMediaPlayer, you were not able to put other controls on top of them....
Seven steps to alert effectively
Automated alerts are essential to performance monitoring. Automated alerts enable spotting issues in infrastructures, identifying their causes, and...
Introducing IDERA SQL DM Performance Insights for Azure Data Studio
IDERA is pleased to announce the introduction of IDERA SQL DM Performance Insights, a Microsoft Azure Data Studio (ADS) extension which displays key...
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...