How to Connect to an Unresponsive SQL Server: Direct Admin Connection
When SQL Server stops responding but is still, the first impulse is to reboot SQL Server. This may stop the symptom, but will not tell you anything to help you prevent the cause. 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 ...
Build Relational Databases in Seven Steps
Many web applications revolve around a relational database. So to create a good application design, you should always create a good database design. Database design is a step-by-step process. 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 ...
Introduction to Variables in PHP
Computer programs usually work with some form of data. This article is an introduction to variables in PHP. More ...
Program a Visual Basic MySQL Database
In my previous article we used MySQLGUI for executing SQL queries on our example database. In this article I show you how to program a simple MySQL database browser using Visual Basic. I assume that you already know how to program a simple Visual Basic .EXE project. 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 ...
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 ...
Run PHP From Flash Key With Server2go
Do you want to learn (or teach) PHP and / or MySQL, but don't want to install a web server + PHP + database on your PC? Server2go is a neat little application that you can put on a USB flash drive and run your PHP MySQL webpages from there. 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 ...
