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
News

Logical to Physical Data Modeling

Author: Cosmin G6814 In the last article we learned how to create a data model from scratch using ER/Studio Data Architect. In part II we will explore about how to convert a Logical Data Model into a Physical Data Model. Section 1: Generating a Physical Data…
News

3 Cool SQL Server TSQL Snippets for Productivity

Author: Tim DelChiaro Nobody would want to shy away from some help. This is second to human nature and we never try totalk it out explicitly. When at work, if we can surely get help from our colleagues when it comes to driving the deadlines and completing it ahead of time. Keeping things till the last moment will only bring our heart rate higher and the anxiety to finish will sometimes make…
Read more
News

Delphi (C++Builder) Android Mobile Client DataSnap Server

Author: Vsevolod L1433 Преамбула DataSnap – платформа создания многозвенных приложений. Её история достаточно продолжительна, начиная с совсем ранних версий Delphi. Роль и значимость этой технологии/платформы изменялась в течение…
Read more