Featured Blog
Understanding and Managing High Memory Usage in SQL Server
Embrace the Future of Data Architecture: Make the Switch to ER/Studio
Sometimes you need to face the inevitable: the tool selected years ago is not the one you need for the future. Have you been struggling with...
Converting A List of Identifiers into SQL Statements
If I had a nickel for every time someone gave me a list of identifiers and asked me to pull a result set for them I would be a very wealthy man....
Integrating Data from Multiple Sources: Making Sense of Conformable Data – by David Loshin, Knowledge Integrity
This is the third post in this series. Read the previous post. In my last post, the discussion focused on the ability to infer metadata about...
Working with StylesData in your FireUI applications
I have been getting some questions recently on how to identify and access style elements using StylesData. StylesData is defined by the style and...
Resurrection of SQL with Big Data and Hadoop
Did you really think that SQL was going away? Attend this session to learn how SQL is a vital part of the next generation of data environments. Find...
Overlapping Filter Application?
How do overlapping filters get handled by Compliance Manager. For example, I want a general filter that brings in anything from domainuser1 for all...
The Future of ER/Studio: A Roadmap Outlook
Customers often ask us what we plan to do for future releases of ER/Studio. Many times we hold that information close, and only provide information...
The Top Productivity Solution for DBAs
Why has Monster Energy drink become standard operating equipment for DBAs? Join us for a hard-hitting look at the state-of-the-union for DBAs, what...
Managing Database Security and Compliance
When managing database security and compliance, the DBA can't take a chance on anything falling through the cracks. In this session, you'll...
The DBA and Developer Career Tips eBook
The DBA and Developer Career Tips eBook Author:Pinal Dave Like in any profession, DBAs and developers face competition in the workforce for job...
What You Know but Don't Know
How To Know What You Don’t Know - Path to the DBA World As a new DBA to a company it can be overwhelming and sometimes confusing on knowing where to...
Integrating Data from Multiple Sources: Inferring Source Metadata – by David Loshin, Knowledge Integrity
This is the second post in this series. Read the previous post and the next post. In my last post, we began to review the data element...
Congratulations You're a DBA…Now What?!
This is a guest article by SQL Server MVP Mike Walsh (www.straightpathsql.com | www.linchpinpeople.com), based on an Embarcadero sponsored webinar...
Solving Performance Problems on Oracle DB
DBAs and database developers regularly spend a lot of time tracking down and resolving performance issues on the database servers they are...
Bind Variables and Application Performance
Not many people are familiar with Bind Variables or how they can be used. Find out how bind variables can be used effectively to make your SQL...
Integrating Data from Multiple Sources: The Challenge of Data Element Conformance – by David Loshin
This is the first post in this series. Read the next post. The continued fascination with expanding an organization’s analytics capabilities often...
Achieving Database Schema Compliance at a UK Finance Institute
The requirement to maintain and prove schema compliance within the organization's database inventory continues to expand. The key objective is...
Updating SQL Elements health check intervals
Periodically when I am speaking to users of SQL Elements I receive a request related to changing the interval at which health checks are run for...
Solving Common DBA Tasks at a Leading German Bank with DB PowerStudio
A leading German bank uses DBArtisan to manage hundreds of databases in their organization. This case study will show how many common DBA tasks are...
True Type Font Iconography for Android and iOS Apps
. Download Project Files Download the project files. How to Deploy a Custom True Type Font First create a new Multi Device Application in...
Beginning Joins with SQL
Introduction When we are talking about relational database, we are usually talking about many different tables and the relationships between them....
Documenting Your Data Landscape For The Organization
When it comes to making informed decisions, data is the most critical asset an organization possesses. In this session, you'll see how to create...
How to centrally manage enterprise data definitions in your data mangement projects?
One of the key issues in a Data Warehouse, Master Data Management or BI project is the lack of a centralized and easily accessible Data Definition...
Getting Physical – Using automation to build robust, high-fidelity schemas from your logical models
High-fidelity database schemas capture essential business rules and help ensure data quality, but can be very time-consuming to produce and...
Top 3 Development Environments for PostgreSQL
PostgreSQL is an object-relational database management system (ORDBMS) supporting extensibility and standards-compliance. Just like any...
The Intrinsic Value of Data Modeling
Maybe you're using Visio, Excel, or a proprietary tool with limited functionality to create a data model. Perhaps you are expanding your job...
How do I get INSERT/UPDATE/DELETE, Table Data Editor and Import to work with Hive?
How do I get INSERT, UPDATE, DELETE, the Table Data Editor and Import to work with Hive? Response Jonathan Powers over 8 years ago With Aqua Data...
Taming the Wild West of Data
Prior to joining Embarcadero, Ron was a consultant who used ER/Studio as well as a variety of other data modeling suites throughout his career....
Knowing Your Storage Basics – 2 Life Lessons
In the software world, it is often the case where everyone wants to learn and master everything. The problem with this approach is that we land into...
Data Governance Trends
The volume of data continues to increase and is coming from more data sources. With more data comes increased opportunity, but also increased risk...