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…
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…
RAD Studio XE8 provides you with the tools to rapidly design, build, and deploy connected apps that deliver innovative IoT solutions.
The new Beacon component makes it easy to add proximity awareness to your applications.
Two beacon formats are available: iBeacon and…
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…
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: jpro51
Working on universal applications has its own challenges. Often I have seen developers resort to unwanted conversions inside the database based on application needs. I am a firm supporter that databases are not the place to play with date and time conversions.
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 Model
Task 1
1) Launch ER/Studio Data Architect
2) Open the last created model
3) We shall now be generating a Physical Model to an…
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…
Author: Mério C11139
My “RAD in Action: Build Modern Apps with Enterprise Mobility Services” webinar is happening right now. During my 50 minutes session I’m demonstrating using DataSnap framework for building multi-tier database application with FireDAC…
Author: Wayne S8181
Monday, July 14, 2014: Lesson 3 – Accessing Local Storage and Data
In this lesson, we explore local storage covering a range of options including using INI files and local document storage. This lesson will also show how to use FireDAC database access components to connect to and use local SQLite, InterBase IBLite and IBToGo. You will understand the core concepts when…
