News

Setting up Oracle for Embarcadero ER/Studio - Part 2

Author: Anil TexasCowboy 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…
Read more
News

Adding a [FixedLength] Attribute in Code-First Entity Framework

Author: Craig Stuntz In Code First Entity Framework models, you can define the length of a string field with StringLengthAttribute, but you have to write code in OnModelCreating to indicate a CHAR/NCHAR fixed length field: public class MyEntity { [Key] public int Id { get; set; } [StringLength(2)] public string FixedLengthColumn { get; set; } } public partial class MyContext…
Read more
News

10 Quick Tips & Tricks for SQL Server Developers

Author: Embarcadero USA Here are 10 quick SQL Server tips and tricks for database developers compiled by SQL Server expert Pinal Dave. For inefficient query plans: Check for issues with bad cardinality estimates. The maximum degree of parallelism can be limited server-wide…
News

3 things you Need to Know About SQL Server Sequence

Author: Tamarian D2278 As we traverse through different versions of SQL Server, there are new enhancements that always make us learn for newer techniques. One such addition to SQL Server 2012 is called as Sequences. Sequences are just like a running number like Identity but are not attached to any table. In a nutshell, sequences generate a number which can be used anywhere agnostic of the…
Read more
News

Rapid SQL XE6 / 8.7.5 is Now Available

Author: Embarcadero USA Rapid SQL XE6 version 8.7.5 is now available. EmbarcaderoRapid SQL is the integrated SQL development environment for IBM DB2, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Sybase and Teradata database systems. Rapid SQL is your fast path to…
News

CORS on DataSnap REST Server

Cross-origin resource sharing (CORS) is a mechanism that enables resources to be shared across domains. Typically this isn’t allowed to prevent security issues. To enable on your DataSnap REST server you can use the following code per MVPNirav Kakufrom…
News

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 different controls can have different elements. To identify and access the style elements in code that you want to change programmatically, you first need to set the style properties for each item at design time. You can then view the structure for those…
Read more