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…
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 application, but you could also use this approach with an existing application. Create a new Multi-Device Application…
Read more
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 from more than one table, we have to use Joins. In this article we will be discussing how we can code joins effectively and…
Read more