SQL (Structured Query Language)
An entity-relationship (ER) model represents the structure of a database, where data equates to entities (or objects) that are linked by relationships expressing dependencies and requirements. More ...
Conversion of Access Database Systems to Visual Basic Dot NET and SQL Server
Microsoft will continue supporting VBA for many years to come, but the programming emphasis
is rapidly changing in favour of Visual Basic.Net and SQL Server. 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 ...
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 ...
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 ...
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 ...
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 ...