Gettting Started With MySQL Database
MySQL is a powerful relational database management system. The fact that MySQL is used by many major organizations such as Yahoo, NASA and the U.S. Census Bureau proves that it can outperform the big name database management systems. 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 ...
Introduction to Variables in PHP
Computer programs usually work with some form of data. This article is an introduction to variables in PHP. More ...
Entity-Relationship Diagrams
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 ...
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 ...
What is an Entity Relationship Diagram?
Entity Relationship diagram is simply a graphical concept which shows the flow of information input and output. Entity relationship diagram has three main components, entity, attribute, and relationship. 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 ...
A Free Windows Graphical Interface to MySQL
In my previous article "Gettting Started With MySQL Database" we installed MySQL on Windows and worked with it using MySQL monitor in a DOS window. In this article, rather than work with a DOS window, we will use a free Windows Graphical Interface to MySQL. 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 ...
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 ...
