SQL Syntax in Rapid SQL by Dan Hotka

SQL Syntax in Rapid SQL by Dan Hotka

Abstract: Guest blog post from Dan Hotka, Oracle ACE Hi! Wouldn’t it be handy to have some Oracle documentation such as SQL syntax right at your fingertips when using an IDE tool such as Rapid SQL? Well, the answer is yes…you can have SQL syntax with the click of your...

3 Leadership Tips defining Success

Every individual has their own set of leaders they look up to in their daily life. I am sure each and every one reading this blog post has a number of leaders who have influenced the way they run their business or even life. Be it in Politics or in social circles –...

Solution for the EditorLineends.ttr issue

During the month of August 2014, Microsoft issued a security patch for Windows (http://support.microsoft.com/kb/2993651). This update had an impact on past versions of our development tools, including RAD Studio, Delphi, and C++Builder from version 2007 to version...

Designing App Navigation with TMultiView

Designing App Navigation with TMultiView

In RAD Studio XE7, we introduced a new smart menu component called TMultiView. With TMultiView, it is really easy to create app navigation that automatically adjusts itself depending on form factor, orientation and target platform using our new behavior services....

Preparing for Data Centric Interviews by Pinal Dave

Preparing for Data Centric Interviews by Pinal Dave

These days the fundamentals of taking an interview have not changed much. The more experienced you are, the greater the likelihood of getting into multiple rounds of interviews. If you have been in the industry for close to a decade, when do you start preparing for...

Performance Improvements with SQL Server 2014

Whenever there is new model of any vehicle launched in the market, it is expected it should have some enhancements or new features which would make it superior from previous model. If the features are appealing, generally customers are positive and forthcoming to pay...

Rapid SQL Code Templates by Dan Hotka

Rapid SQL Code Templates by Dan Hotka

This is part of a series of guest posts by Dan Hotka. Hi! This week I want to show how Rapid SQL can improve your coding productivity and technique by using its templates. A template saves me from having to look up the exact syntax. To use, simply put your cursor on...

What Are SQL Elements Health Checks?

What Are SQL Elements Health Checks?

I have recently received a number of questions regarding Health Checks in SQL Elements, what are they, how often do they run, and what do I do with them? Health checks are a great way to get a holistic view of the performance, availability and other critical issues on...

New Free Tool – SQL Update Statistics is available now!

New Free Tool – SQL Update Statistics is available now!

Table statistics maintenance is an important part of overall SQL Server administration. DBAs understand a common cause of query performance problems come from rapidly changing data. By design, databases have an option to auto update statistics, but when data is...

Bluetooth LE support in RAD Studio XE7

Bluetooth LE support in RAD Studio XE7

RAD Studio XE7's integrated wireless support (Bluetooth and Wifi) works with thousands of consumer and industry specific devices. RAD Studio's approach makes it easy to integrate virtually any device into the app user experience, and even support multiple...

Metadata Overview, by Ron Huizenga

What is Metadata? The term “Metadata” arises frequently when discussing Data Architecture.  In short, it is “data about data.”  However, interpretation can be rather ambiguous, since it is used in different contexts.  The most common context is known as...