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 by using the max degree of parallelism option. DMV – sys.dm_os_nodes provides information about CPU node…
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 India. All you need to do is add a custom header in the Response beforedispatching the result on the DataSnap…
Read more
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…
News

SQL Server Tip: Optimizer Using Index Scan and Not Seek!

Author: Timur T7253 Introduction Other than coding, the next biggest task for developers is to troubleshoot problems in their environments. Developers in the SQL world mostly face problems around error messages, getting required output via T-SQL query, and unpredictable performance of queries. The Problem One fine day somewhere in the world one developer was troubleshooting a performance problem…
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…
News

OpenSSL and HTTPS Support for iOS Devices

Author: Brian Alexakis For the iOS Device target platform, which does not support dynamic libraries, you need a static version of these library files (libcrypto.a and libssl.a). To obtain these library files, do either of the following: Download the pre-compiled libraries from Github. Build these libraries from sources. Download the sources from Github and follow the steps described in Tutorial…
Read more