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

Rapid SQL XE6 / 8.7.5 is Now Available

Author: Embarcadero USA Rapid SQL XE6 version 8.7.5 is now available. Embarcadero Rapid 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…
Delphi

Using existing ClientDataSet data in FDMemTable

Author: Davide Rubbiani For today’s #DelphiWeek post, I thought I would highlight how you can use existing ClientDataSet (.cds) data in FDMemTable. With this approach, you can also save existing .cds data as JSON, for example. In this tutorial, I am going to create a new…
News

Beginning Joins with SQL

Author: mahdy M7244 Introduction When we are talking about relational database, we are usually talking about many different tables and the relationships between them. We define relationships with various keys like primary key, foreign key, etc. When we have to retrieve data…