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...
Blog
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...
FireMonkey Styles, Part 2: Creating a custom style for TSwitch
Holiday Time Resources
Have a little free time over the holidays while providing coverage for work, or like to brush up on technical information? In addition to the many...
OpenSSL and HTTPS Support for iOS Devices
For the iOS Device target platform, which does not support dynamic libraries, you need a static version of these library files (libcrypto.a and...
Automating Data Modeling Tasks
Finding ways to automate common tasks can make your data modeling more productive. By investing a little bit of time initially, you can save time...
Proof of Concepts made Easy with The Cloud
As a Solutions Architect, there are times when you actually need to replicate customer scenarios, often becomes a challenge, unless you have your...
Data Modeling for Agile Environments
Agile Development has always been at the forefront of new ways of developing software. So why should Data Modeling be left behind? In this short...
Consistent Data in Distributed Systems
This is a video replay from the DataU online conference. Data types that are not consistent across multiple systems where data movement occurs could...
Integrated cross-platform SQL IDE for increased database development efficiency
Have you ever wanted a SQL IDE that would help you code SQL for multiple platforms using a Single IDE? Now you can! with Embarcadero's RapidSQL...
2 Ways to identify that we have a bad plan in SQL Server
SQL Server is a complex RDBMS with a lot of capabilities in it. I am sure most of us have just scratched the surface when it comes to working with...
3 soft skills that you want to have in an interview
It was couple of years back that my friend had written this article on my blog - Interview Questions and Answers – Perspectives of an Author. I know...
Top 3 Sample Databases for PostgreSQL
If a developer is attempting to learn a new process or test some code, it’s best to utilize a test environment such as a sandbox rather than the...