SQL (Structured Query Language)
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 ...
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 ...
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 ...
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 ...
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 ...