Announcing the General Availability of IDERA SQL Safe Backup 9.3
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
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. No matter where the data resides, whether in a relational, cloud, document store, or an Excel source, Aqua Data Studio...
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 host Chris Hyde (@ChrisHyde325) on Wednesday, November 28 at 11 AM CT for a community discussion on Data Analysis....
Learn more about SQL Server statistics
Statistics, or “stats,” are fundamental components of SQL Server performance, but vastly under-appreciated and misunderstood. They are at the core of query optimization and can have a tremendous effect on query plan selection. The query optimizer uses...
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 --> Under the Snowflake Help Menu, Click on the Download hyperlink. Next choose ODBC and download the appropriate ODBC Driver....
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 changes we’ve made!) and updated the component icons. In RAD Studio 10.3, we have a number of further UI upgrades we’re...
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 “data model”) which aids communication – saving time during development, saving money on support, and improving...
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 security while maintaining database performance. That is, the trade-off consists of three axes: Performance, security,...
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 the performance of databases. Moreover, the locking process is often complicated. Deadlocks occur when concurrent...
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 have grown, changed, and multiplied. Instead of just relational, SQL database systems, we now use NoSQL databases and...
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 be followed for any company who wishes to collect data on California residents. Some of the law may be adapted before...
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 network traffic, keep mobile data costs down and speed up your development time by syncing only the changes you subscribe to....
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 resources if you know where to look. Enroll in free, or inexpensive, Online Courses: I love taking classes from...
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 the real-time monitoring, SQL Diagnostic Manager for MySQL offers several different ways of identifying poorly performing...
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 these casualties? Start out by designing your application with mobile in mind. You can’t just replicate your desktop...
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 everyone is familiar with the paradoxical adage in English, “The more things change, the more they stay the...
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 ER/Studio Macros in the product. Auto Create Data Dictionary - This macro will enable one to kickstart your Data...
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 of blogs posts on UI design. How To Design a Great UI A practical approach to taking a mockup or first cut of...
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 OVERVIEW page, which is the initial page, gives you a high-level view of your environment. You get a quick view of 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 expert. In Part 1, we looked at some basic principles of UI design, a typical UI design workflow, what it means for a UI to...
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 6th-9th at the Washington State Convention Center in Seattle, Washington. The exhibit hall will be open from...