A directory of resources inthe field of technical communication.


38 found. Page 1 of 2.

About this Site | Advanced Search | Localization | Site Maps

1 2  NEXT PAGE »

SQL is a standard language for querying and modifying data and managing databases. Many databases support SQL with proprietary extensions to the standard language. The core of SQL is formed by a command language that allows the retrieval, insertion, updating, and deletion of data.



Access a MySQL Database Behind Firewalls with the LibMyWitch Control

Till now there was no efficient way to embed the access to the MySQL database into a VB application.

Richter, Dirk. VBMySQL.com (2004). Articles>Information Design>Databases>SQL


Review: Bosworth's Web of Data

In a Thursday morning keynote at the MySQL Users Conference 2005, Google's Adam Bosworth advocated an open model for data. Although he was not referring to open source, he expanded upon the example by explaining that customers like open source software because of the transparency.

Steinberg, Daniel H. O'Reilly and Associates (2005). Articles>Reviews>Information Design>SQL


Build Custom Templates for Your Data-Driven Web Sites

Most developers dread dealing with HTML tables and cells to build their Web sites. For one thing, tables make it difficult to modify the site later or to change its appearance. Discover some basic techniques for writing Web sites that you can later re-skin by using templates during the site's initial creation. Also, learn why you should use data-driven techniques for your own Web sites.

Ramirez, Ken. IBM (2008). Articles>Web Design>Databases>SQL


Building a Database-Driven Web Site Using PHP and MySQL

A hands-on look at what's involved in building a database-driven Web site. We'll be using two new tools for this: the PHP scripting language and the MySQL relational database.

Yank, Kevin. MySQL (2004). Articles>Web Design>Server Side Includes>SQL


Building a SQL Server 2005 Integration Services Package Using Visual Studio 2005

A comprehensive start from scratch and step-by-step approach to learn this important procedure. This illustrated article is your guide to SSIS designing.

Krishnaswamy, Jayaram. ASPAlliance (2006). Articles>Information Design>Web Design>SQL


Connecting the MySQL GUI Tools to a Remote Server through a Firewall  (link broken)

A large percentage of MySQL users are using MySQL on a web server hosted by an ISP. Most hosting providers block port 3306 (the MySQL server port) at the firewall, preventing outside access to MySQL. This is an important security practice and you should be very concerned if your ISP does not block port 3306. In this article I will demonstrate how to connect the MySQL GUI tools, including MySQL Administrator and MySQL Query Browser, to a remote server using SSH port forwarding. This article will be written with the assumption that the reader is using Microsoft Windows, but the principles presented will be applicable to Linux users.

Hillyer, Mike. VBMySQL.com (2004). Articles>Information Design>Databases>SQL


Database Templates with MySQL

Once you've built several MySQL databases, you'll learn some shortcuts to database design. Why stop there? Take this trick a step further and put together a generic database with a set of empty, standard tables. With a well-designed MySQL template, you can quickly assemble the basics of any database as needed. A template also allows you to focus on the more interesting aspects of a database project.

Dyer, Russell. O'Reilly and Associates (2004). Articles>Information Design>Databases>SQL


Databases: Step-by-Step Guides to Using Databases

This detailed, inclusive database tutorial is designed for beginners and those ready to dive in. Easy-to-understand definitions, real-world anecdotes, and concrete examples set this site apart from the others.

GeekGirl's. Design>Information Design>Databases>SQL


Deployment of the MobiLink Synchronization Model Wizard in SQL Anywhere 10

This builds on the previous article, 'MobiLink Synchronization Wizard in SQL Anywhere 10.' The new Deployment Wizard in SQL Anywhere Server 10.0 makes it painless to deploy the model, a task which was script based and terse.

Krishnaswamy, Jayaram. DevShed (2006). Articles>Computing>Databases>SQL


eRuby: Using Ruby and MySQL for Dynamic Web Pages  (link broken)

In a previous tutorial you learned how to get started using the Ruby language as a web scripting language by embedding it in HTML. You need some type of database connectivity to do the cool dynamic stuff. So here is a tutorial written by Markus Jais on how to connect to a MySQL database using Ruby. I will be updating and editing this tutorial to include more windows instructions where applicable.

Jais, Markus. Hiveminds (2002). Articles>Web Design>Databases>SQL


Everything You Wanted to Know About SQL Injection

If you are a CMS user or web developer then you should know what SQL injection attacks are and how to protect your web applications against them. Hackers are using more SQL based attacks, getting smarter about how to attack a website and using better tools. You have to get a good understanding of how their attacks work if you are going to choose the right software and keep your website secure. Here I will review several types of SQL injection attacks and how they occur. Then take a look at what web developers and end users can do to prevent them.

McDade, Carl. Hiveminds (2006). Articles>Web Design>Databases>SQL


Generating and Hosting a SQL Server Reporting Services Report Using SQL Server 2005 Business Intelligence Development Studio

A step-by-step must read article on SQL 2005 Reporting Services which creates a report and hosts it on an intranet server.

Krishnaswamy, Jayaram. ASPAlliance (2006). Articles>Information Design>Databases>SQL


How They Hack Your Website: Overview of Common Techniques  (link broken)

We hear the same terms bandied about whenever a popular site gets hacked. You know… SQL Injection, cross site scripting, that kind of thing. But what do these things mean? Is hacking really as inaccessible as many of us imagine; a nefarious, impossibly technical twilight world forever beyond our ken? Not really.

Conroy, John. CMSwire (2008). Articles>Web Design>Security>SQL


An Introduction to Database Normalization  (link broken)

When users ask for advice about their database applications, one of the first things I try to help them with is the normalization of their table structure. Normalization is the process of removing redundant data from your tables in order to improve storage efficiency, data integrity and scalability. This improvement is balanced against an increase in complexity and potential performance losses from the joining of the normalized tables at query-time.

Hillyer, Mike. MySQL (2004). Articles>Information Design>Databases>SQL


Introduction to Databases for Web Developers

Unlike previous versions of data warehouses (people and books), that might be considered the australopithecines of the database lineage, libraries crossed over into the modern-day species.

Extropia. Design>Web Design>Databases>SQL


Managing Hierarchical Data in MySQL  (link broken)

Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a flat list. Hierarchical data has a parent-child relationship that is not naturally represented in a relational database table.

Hillyer, Mike. VBMySQL.com (2005). Articles>Information Design>Databases>SQL


Microsoft Access Queries with Oracle SQL Developer 1.2 Tool  (link broken)

This article by Jayaram Krishnswamy shows how you can install the Oracle SQL Developer 1.2 and connect to an MS Access database. This article will cover the steps right from downloading and installing the Oracle SQL Developer, to connecting to a MS Access database, and using the SQL interface along with a few sample queries.

Krishnaswamy, Jayaram. Packt (2007). Articles>Information Design>Databases>SQL


Microsoft SQL Server 2008: Installation Made Easy

The article discusses the precaution thta one can take in installing the Microsoft SQL 2008 Sever (Developer Edition). Links to downloading a sample database with how-to note is also provided. Some of the initial problem solving in cleaning up the .NET miscellanea is discussed in this blog at : http://hodentek.blogspot.com/2008/01/you-were-cleaning-up-net-framework.html

Krishnaswamy, Jayaram. Packt (2008). Articles>Software>Databases>SQL


Microsoft Word 2007's Mail Merge with a SQL Anywhere 10 Database

SQL Anywhere 10 database and Microsoft Word 2007 are the latest software from the respective companies. This step-by-step tutorial not only shows how you can merge a mail document from customer information in a Sql Anywhere 10 database, it also shows how you may work with the database. If you are a office worker using 'Office' products this is a must article for you.

Krishnaswamy, Jayaram. OfficeUsers.org (2007). (Afrikaans) Articles>Software>Databases>SQL


Migrating from Microsoft SQL Server and Access to MySQL

In this article I will cover the basics of migrating an application from an Access or SQL Server database to MySQL. We'll start with various reasons why you should (or should not) migrate your existing Access or SQL Server database to MySQL, then cover the planning stages of an application migration. Next we will look at the tools and methods for migrating your actual data from Access/MSSQL to MySQL, followed by some general guidelines for modifying your client application from a Microsoft database to MySQL. Finally, we'll look at some considerations to make when deploying your new MySQL database and application.

Hillyer, Mike. MySQL (2007). Articles>Information Design>Databases>SQL


Migrating from MS SQL Server 2008 to EnterpriseDB

With many database vendor products in the market and data intensive applications using them, it is often required to port the application to use the data or, migrate the data so that the application can use it. Migration of data is therefore one of the realities of the IT Industry. Some of the author's previous articles on migration can be found at the link.

Krishnaswamy, Jayaram. Packt (2009). Articles>Information Design>Databases>SQL


Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2  (link broken)

Business needs often necessitate data migration from a smaller, less secure database to a higher end, faster database server with a more reliable availability. A typical scenario is the migration of data from a desktop sized database such as MS Access or Fox Pro to any other higher end database servers such as MS SQL Server, Oracle, DB2 or SQL Anywhere Server. Oracle SQL Developer 1.2 with this latest version is sometimes called the Migration version as it supports migrating data from three vendors (MySQL, SQL Server and MS Access) to an Oracle database. In fact, it has been designed to migrate from more than one version of MS Access. This feature was not available in the version 1.1 of this tool.

Krishnaswamy, Jayaram. Packt (2007). Articles>Information Design>Databases>SQL


MobiLink Synchronization Wizard in SQL Anywhere 10

MobiLink is a technology that can help multiple databases synchronized, a key requirement for mobile access to data. The article shows you how to create a model that can be deployed to access data on a SLQ 2005 Server remotely with a SQL Anyhwhere database. A forth coming article descibes the deployment details.

Krishnaswamy, Jayaram. ASP Free (2006). Articles>Information Design>Databases>SQL


Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps  (link broken)

This tutorial shows how SQL Server 2005 can be migrated to SQL Server 2008 quite easily by manually detaching the database from SQL Server 2005 and attaching it to SQL Server 2008. This is a much easier process than the 'Copy Database Wizard' which has two procedures one of which is the same as the manual process but carried out under the guidance of a wizard and the other which does not require the stopping of the Source server.

Krishnaswamy, Jayaram. Packt (2008). Articles>Information Design>Databases>SQL


MySQL Tutorial  (link broken)

Released in January 1998, MySQL is an open source relational database management system (RDBMS). It's based around the Structured Query Language (SQL), and is best for managing the content of the database as opposed to transactions, as MySQL does not support COMMIT or ROLLBACK. One of the biggest drawbacks of MySQL is it's lack of support for referential integrity, no stored procedures, no triggers, and no sub-queries. MySQL is free, and may be downloaded from download section at MySQL.

Lemon, Gez. Juicy Studio. Articles>Information Design>Databases>SQL



Follow us on: TwitterFacebookRSSPost about us on: TwitterFacebookDeliciousRSSStumbleUpon