PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide
This book teaches how to develop dynamic Web sites with PHP and MySQL. The information is presented in a step-by-step approach. The focus is on real-world, practical examples. More ...
Use Perfmon and SQL Profiler Together to Troubleshoot SQL Server Performance Issues
A great technique for troubleshooting SQL Server performance issues is to use Perfmon and SQL Profiler together. Each tool give you insight into what is happening with your database server, but combined they can narrow down your performance issue to specific events or statements. More ...
Working With Numbers in PHP
One of the most important things to consider in using arithmetic operators is operator precedence, that is, the order in which the operations are performed. More ...
Microsoft SQL Azure - Microsoft Takes SQL Databases to the Clouds
SQL Azure provides data storage in the cloud, much like Amazon S3 and many Google Apps. One of the big advantages for SQL Azure is that relational queries can be made against data stored in the cloud, regardless of whether they are structured. More ...
Creating Webpages with PHP
This article is an introduction to the PHP server-side scripting language where you learn how to create webpages with PHP. More ...
The Entity-Relationship Model
After you have a data model that meets the organizations business requirements, the easiest way to transform that model into a relational database is to first transform that model into an entity-relationship model. More ...
Introduction to SQL Database Design
A Database is the storage of data in what are called tables. Without knowing what kind of data you are planning on storing, you will not know how to create the tables. More ...
Introduction to SQL (Structured Query Language)
IBM developed its relational database management system by creating a language initially named SEQUEL (Structured English Query Language). However IBM's legal department found a possible copyright issue with the name SEQUEL. So they decided to drop the vowels and call the language SQL. More ...
Working With Strings in PHP
Computer programs usually work with some form of data. One of the most common forms of data used in PHP is a text character or an array of text characters. An array of text characters is called a string. More ...
Database Administration
This is the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices and proven solutions for any database platform or environment, this text fully reflects the field?s latest realities and challenges. More ...
