Featured Blog
Empowering Law Firms: How SQL Server and Idera Tools Safeguard Legal Data
ER/Studio MetaWizard Does The Magic!
Often times you would hear about moving objects from one Data Modeling platform to another for various reasons. Embarcadero's Meta-Wizard...
Agent vs. Agentless Monitoring
With a unified IT monitoring solution like up.time one of the more popular discusses we have with users is agent versus agentless monitoring. In...
Service Broker Gone Wild: Dealing With sysxmitqueue Bloat
Have you ever been surprised by suddenly finding out that one of your databases has grown way beyond your expectations? Hopefully, this isn’t...
New SQL Suites available now!
Today Idera announces a set of three exciting new bundles in addition to its existing popular SQL Management Suite (formerly called SQL Suite)....
Team DBA and Collaboration
In previous blog posts I have explored the relevance of the DBA position itself in business and the unique ways that SQL Server DBAs tend to...
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...