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…
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: 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…
Simple Database and Data access in Delphi XE5 for iOS and Android
September 18, 2013
Author: Blaise Þ
With the release of Delphi XE5 for iOS and Android developers now have several options for connecting to databases and data both on the devices themselves as well as via our DataSnap multi-tier technology; REST application services, REST, SOAP, and XML (TXMLDocument). You can directly use SQLite, InterBase IBLite/IBToGo in your iOS and Android applications via the FireDAC…
Author: Michael K22532
JSON support has been introduced in Delphi 2010 as a part of DBExpress database driver architecture, but of course JSON support is not limited to just database applications. JSON is similar to XML as both are text-based data interchange formats.
Delphi…
