Creating backups and restoring them is crucial for maintaining the integrity and availability of data in Microsoft SQL Server. Here's a set of...
Database Backup and Restores Drills in SQL Server
read more
Anil M
FluidShell – A Primer – SQL Server Edition
Welcome to this first of three blog posts that would cover the basics of getting practical usage of Aqua Data Studio's FluidShell. Introduction:...
Snowflake Magic! with Aqua Data Studio
Howdy, y'all! Happy Thursday! Today we will be exploring the exciting world of Cloud Data warehouses and my personal favorite,...
Aqua Data Studio does the Magic Again! Salesforce Connectivity!
Howdy, y'all! I am here again with another cool Aqua Data Studio blog. I would like to credit this blog post to my colleague for setting...
Build your Queries Fast with the Query Builder
Howdy, folks! Welcome to another fun-filled blog post on Aqua Data Studio. Let's face it, building queries may not be everyone's cup of...
Amazon Redshift Magic with Aqua Data Studio
Howdy! Welcome to another blog post on Aqua Data Studio! This time we will diving into the wonderful world of Amazon Redshift!...
Aqua Data Studio – From Database to Excel to Data Source – A Primer
Howdy! Welcome to a series of blogs on Aqua Data Studio - The leading universal database IDE and productivity tool on the planet! In this quick...
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 -->...
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...
Azure MySQL Database as a Service – The next best thing to an Azure Database as a Service Addon
Azure MySQL...
Data Lineage – The Power to Connect the Dots in ER/Studio
Howdy! Ever considered or wanted to know how Data would move around the organization? Data Lineage is a key driver that ensures on connecting the...
Connecting to PostgreSQL and MySQL via ODBC to IDERA’s ER/Studio Data Architect
Howdy! Introduction: In this blog post, we will show you how easy it is to connect to MySQL and PostgreSQL via ODBC. As you are aware we can reverse...
Setting up ER/Studio in the Google Cloud Platform – Part I – Setup
Hi All, In this blog post we will be going through on how to setting up IDERA's ER/Studio Repository Database Setup in The Google Cloud. In Part...
Troubleshooting Common Cloud Database Connectivity Issues
Howdy! And wishing Y'all a Very Happy and Prosperous 2018! In this very first blog of 2018, I'm excited to be writing this series on...
IDERA ER/Studio Repository Database Setup and Ports – Part 1 – SQL Server
Howdy! In this latest blog post, I will be covering the Database setup one would need for our IDERA ER/Studio Repository. ...
Logical to Physical Data Modeling
In the last article we learned how to create a data model from scratch using ER/Studio Data Architect. In part II we will explore about how to...
Setting up an Apache Web Server in Debian using Google Cloud
Setting up an Apache Web Server in Debian using Google Cloud Howdy! In the...
Setting up a Linux VM using Google Cloud
Howdy! In this blog post, I will be showing you all on how to setup a new Linux VM in Google Cloud. If you are new to Google Cloud, I would...
Tutorial : Setting up ER/Studio Repository with Microsoft SQL Server in Amazon Web Services
Howdy! In this series, we will explore on how easy it is to setup our Model Repository in the Amazon Web Services Cloud Environment....
Working with Glossaries in Team Server
Working with Glossaries in Team Server So Why Business Glossaries? A typical way of structuring glossaries is aligning glossaries to...
Golden Nugget: Working with The Repository Security Center
ER/Studio Repository is a server-side model management system that solves the day-to-day challenges of modeling in a team environment, where model...
Golden Nugget : Naming Standards Templates
Howdy! Today we will be exploring a feature called Naming Standards Template. In a Naming Standards Template you can define standards for...
ER/Studio Model Repository Database Sizing Guide for Oracle Database
Howdy! In a previous article, I showcased on how to implement table statistics and Index Re-orgs in SQL Server for the Model...
Setup ER/Studio Repository with Microsoft SQL Server in Amazon Web Services
Howdy! In this series, we will explore on how easy it is to setup our Model Repository in the Amazon Web Services Cloud...