Delphi - Records

What are records? Records are a useful and distinguishing feature of delphi. They provide a very neat way of having named data structures - groups of data fields. Unlike arrays, a record may contain different types of data. Records are fixed in size - the definition of a record must contain fixed length fields. We are allowed to have strings, but either their length must be specified (for example a : String[20]), or a pointer to the string is stored in the record. In this case, the record cannot be used to write the string to a file....

Read More

Developing Facebook Fan Page Requires Effort and Creativity

At this point of time, each and every individual is aware about Facebook. Promoting your products as well as services have become very necessary in today's business scenario and for that Facebook is one of the finest platforms. Either you must already be having a Facebook Fan Page for your business, or you must be planning to create a new one. Nowadays, it has become really very important to make use of these social networking sites to their fullest prospective. Moreover, setting up a Fan Page is not just the only activity; it must be customized...

Read More

SQL Server - OLE DB Deprecated :(

As you may already know, the SQL Native Client OLE DB provider is being deprecated. This doesn't affect other OLE DB providers or the OLE DB API. Also, the SSIS OLE DB components are not being deprecated. In SQL Server 2012 SSIS, you can continue to use OLE DB connections and will need to for components such as the Lookup transformation and the Slowly Changing Dimension transformation that require OLE DB. In the post-Denali release, you’ll be able to upgrade and continue to operate these packages without needing to do additional work to explicitly...

Read More

SQL Server - Result paganation in sql server

A lot of SQL Server database users at some time faced a big obstacle, especially web sites programmers when need to read data from the database in case of a partial data was a fairly large size. After a long and arduous journey made in the search for the best method that can solve the problem very haunting, I've experimenting with dozens of ways that were not satisfactory at first, especially if the data is very large size. In fact,i did't...

Read More

PHP -MySQLCrank

MySQLCrank Provides a number of functions to make it easier to work with MySQL databases, without using a lot of mysqli_xxxx functions, making it easier to switch to a different database. Supports SELECT, INSERT, UPDATE, and DELETE queries only, first because of security reasons, second - other queries are just not really needed for web development.  Using MySqli_ extension (as described in php.net): The mysqli extension, or...

Read More

SQL Server - Table Partitioning technique

Technical concept : partitioning in simple word is spreads your data in multi file groups , file groups it's physical files on your Hard drive . Usage: This technique is used heavily in case of very large tables which are hard to get rid of this data on a regular basis, so it would be difficult to work out on the tables of millions of data that are used only when needed. Therefore stems need to provide a mechanism to keep all the data available,...

Read More

PHP - Steps to increase the efficiency of PHP code

If you're a developer, it is necessary for you to improve your script in the development process itself early. Following the best practices while coding your PHP script is a good starting point to write PHP code optimization as well. This tutorial provides few tips to optimize PHP code from a developer point of view. 1. Use Native PHP Functions As much as possible, try to use the functions of the original PHP instead of writing your own functions to achieve your goal. For example, you can use range (b, k) to get of alphabets ranging from...

Read More

PHP - prevent SQL injection in PHP

What is SQL injection ?  Many web developers are unaware of how SQL queries can be tampered with, and assume that an SQL query is a trusted command. It means that SQL queries are able to circumvent access controls, thereby bypassing standard authentication and authorization checks, and sometimes SQL queries even may allow access to host operating system level commands.  Direct SQL Command Injection is a technique where an attacker...

Read More