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 ...
Language Integrated Queries (LINQ) and Visual Basic
LINQ is a better version of SQL - it is a part of ADO.NET and is integrated with VB.NET. LINQ now has the long missing option of using Visual Basic functionality in the data selection process. 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 ...
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 ...
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 ...
Introduction to Variables in PHP
Computer programs usually work with some form of data. This article is an introduction to variables in PHP. 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 ...
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 ...
SQL 2012 Data Tools
Data Tools (SSDT) is a tool set designed for use by Microsoft with SQL Server and SQL Azure to facilitate database design. Features include business intelligence (BI) tools, rapid data discovery, and data warehousing, among others. 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 ...
