Embarcadero® DBArtisan® 2016 is a revolutionary, team-enabled database administration solution using integrated performance analytics and team sharing capabilities to maximize availability, performance, security and collaboration across multiple DBMSs. DBArtisan is the essential DBA toolset to dramatically lower costs and save time by leveraging performance insights to identify issues and pinpoint resolutions. DB Team Server (Included) Work Smarter. Get Team-Enabled. With DBA teams struggli...

Howdy! In this final installment, I will be covering on how to ensure optimum model repository performance for IBM DB2. [Update Statistics] RUNSTATS command Updates statistics in the system catalog about the characteristics of a table and/or associated indexes, or statistical views. These characteristics include number of records, number of pages, and average record length. The optimizer uses these statistics when determining access paths to the data. Collect statistics on the table ...

Howdy!  In a previous article, I showcased on how to implement table statistics and Index Re-orgs in SQL Server for the Model Repository. In today's blog post, I will be showing on how to update table statistics on the ERSRepo Schema for an Oracle database/schema. [Tip 1] It is highly recommended to create a schema for the ER/Studio Model Repository. [Gather Statistics in Oracle] exec dbms_stats.gather_schema_stats( -ownname          => ...

ER/Studio Database Sizing Guide - Best Practices Howdy! In this blog post, let us shed some light on how to better leverage Capacity planning and Database Sizing for ER/Studio's Repository Database. I will be covering each individual Database Platform per blog post. In today's series, I will be covering Microsoft SQL Server: For Microsoft SQL Server Database:  Perform the following steps: After approx a month or so of repository activity,  1) Run sp_updatestats to update table ...

Howdy! In this series, we will explore  on how easy it is to setup our Model Repository in the Amazon Web Services Cloud Environment. Now I will not be going through setting up an AWS EC2 instance etc. However, I will guide you through the steps you would need in order to successfully setup the Repository. [Step 1 --> Choosing the Correct Virtual Machine from the Gallery] My personal fav is the SQL Server 2008R2 with Windows 2008 R2. You are free to choose amongst other popular...

Howdy! In this series, we will explore  on how easy it is to setup our Model Repository in the Microsoft Azure Cloud. Now I will not be going through setting up an Azure VM etc. However, I will guide you through the steps you would need in order to successfully setup the Repository. [Step 1 --> Choosing the Correct Virtual Machine from the Gallery] My personal fav is the SQL Server 2008R2 with Windows 2008 R2. You are free to choose amongst other popular ones. Once you have chosen ...

Howdy! Welcome to the next installment of the series. In today's series, we will explore the options for Oracle Client Setup needed for ER/Studio.  Install the clients needed for your environments. Reboot after installation.  [Verifying Environment Variables] 1) Navigate to the Environment Variables Path.  For more information on how to do it, check this article. http://www.computerhope.com/issues/ch000549.htm  Navigate to the PATH variable section and make sure that ...

In this blog post, I will be covering how easy it is for one to setup Oracle, in order to successfully work with Embarcadero's leading Enterprise Data Modeling Tool, ER/Studio. [Pre-requisites] Oracle Database 32 / 64 bit Server Edition ER/Studio Data Architect 32 / bit  DBMS Client versions for the necessary ER/Studio product installed (if on a separate machine) You may download the above software from the following location http://www.oracle.com/technetwork/database/enterprise-e...

 Yes, you read that right! Data is indeed The new Bacon!! We have been hearing about it all over the place.   So Rich in Information and still if done right cooked to Perfection! With Embarcadero's leading Data Modeling and Management tools! We know our audience! and have been doing this for decades! With the newest kid on the block of our enterprise offerings,  check out ER/Studio Enterprise Team Edition. ER/Studio Enterprise Team edition provides the fastest, easiest, and m...

ER/Studio Enterprise Team edition provides the fastest, easiest, and most collaborative way for data management professionals to build and maintain enterprise-scale data models and metadata repositories. Built-in facilities automate routine modeling tasks so users can analyze and optimize database and data warehouse designs faster than ever. Model change management provides the ability to create and track tasks associated with data models in order to enable data architects to ensure their model...