Blog

As we end our Improving the Daily Life of a Database Developer blog series, we outline how to manipulate data for visual analytics.  Be sure to check out our previous post, Comparing Data Sets and Object Scripts. Within database teams, dat...

Microsoft’s PowerShell is a task-based command-line shell and scripting language. It is an automation platform and scripting language that simplifies the management of Windows and Linux environments. It is designed primarily for system administ...

We are pleased to announce the availability of the ER/Studio Data Architect 18.0.1 patch release ER/Studio 18.0.1  Data Architect corrects an error when connecting to SQL Server using windows credentials when reverse engineering a database (issu...

Last week, we discussed Generating and Executing Object SQL Scripts, and you can view that post here.  In week 5 of our Improving the Daily Life of a Database Developer blog series, we compare data sets and object scripts.   Having created...

There are several regulations out there that tell you how you should be handling your data.  Some organizations are held accountable to multiple different regulations at the same time. Some of these regulations may be in conflict with another. H...

IDERA’s #SQLChat is back! Join IDERA (@Idera_Software) and host Leslie Andrews (@landrews5807) on Wednesday May 29 at 11AM CT for Designing Data Warehouses: Using the Power of the Data you have. Leslie will be leading the chat on different...

Data is more important than ever to business success. As data demands continue to skyrocket, many database administrators are given responsibilities that fall outside their job function. The accidental database administrators are becoming more preval...

In week 4 of our Improving the Daily Life of a Database Developer blog series, we discuss the common task of generating and executing object scripts. If you missed it, you can read the previous post on Creating High-Quality and Easily Editable SQL. ...

Backing up SQL Server databases is one of the most critical tasks that database administrators perform in their SQL Server environments every day. The backup process is so essential that it usually requires distinct processes, checklists, and multipl...

Modern application development teams are aligned to deliver software using agile methodologies and a DevOps approach. Agile and DevOps are not the same thing, but they work well together to improve the application development process enabling quicker...

May 1st is traditionally celebrated as “May Day” to welcome the return of spring. In Central Texas, we often get a lot of rain in the spring, sometimes with hail or tornados, but we’re glad to avoid the late snowfall seen in other a...

In week 3 of our Improving the Daily Life of a Database Developer blog series, we detail how to create high quality SQL code that is easy to edit. If you missed it, you can read the previous post on Navigating the Database. Creating, editing, and ru...

In many organizations today, Microsoft SQL Server supports applications that are critical to organizations where downtime and poor performance has an immediate impact on organizational productivity. As a result, ensuring SQL Server performance and av...

Like most data professionals, my day is pretty busy.  Because of this I really like shortcuts.  In this post, I’ll talk about a series of shortcuts I use every day that don’t seem to be very well known in the community.&nbs...

"Res ipsa loquitor" means it speaks for itself.  End-user transaction monitoring is Precise's specialty.  This screen shows a list of the slowest transactions in descending order, an over-time graph, and an application tier stacked bar grap...

Next in our Improving the Daily Life of a Database Developer blog series: now that you’ve successfully connected to your database, we will focus on helping you navigating through it. If you missed it, you can read the previous post on Connectin...

Howdy, y'all! Happy Thursday!  Today we will be exploring the exciting world of Cloud Data warehouses and my personal favorite, Snowflake from snowflake computing - http://www.snowflakecomputing.com. We shall learn how to connect to Snowfl...

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 it up internally for me to post.  We will be exploring on how to connect to a Salesforce instance usin...

Welcome to our new blog series, Improving the Daily Life of a Database Developer. This series will examine several of the most common database development tasks, and describe how to accomplish them quickly and productively through a single integrated...

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 tea.  Today we shall explore the Query Builder within the tool. The Query Builder allows creating Multi-Datab...

Howdy folks!  Today we will be taking a look on how to create a simple Data model using IDERA's Flagship Data Modeling tool, IDERA ER/Studio Data Architect. The purpose of reverse engineering a database is to help you better understand the unde...

The Embarcadero Enterprise License Center (ELC) software, previously known as AppWave, is a server-based application that allows users of Embarcadero products, including DB PowerStudio and ER/Studio, to manage their own licenses, rather than using th...

Howdy!  Welcome to another blog post on Aqua Data Studio! This time we will diving into the wonderful world of Amazon Redshift! Pre-Requisites  Aqua Data Studio  An AWS account with Redshift already configured and ready to go Configu...

Companies are expanding their systems beyond relational databases to incorporate big data and cloud deployments, creating hybrid configurations. Database professionals have the challenges of managing multiple data sources and developing queries again...