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 configuration…
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…
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…
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 MVP Nirav Kaku from India.
All you…
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…
Author: Brian Alexakis
Download Project Files
Download the project files.
How to Deploy a Custom True Type Font
First create a new Multi Device Application in either C++ or Object Pascal.
Save the project to a folder on your filesystem.
From the FontAwesome downloaded…
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…
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…
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…
