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.
#25352
Securing a MySQL Server on Windows
Windows servers can be difficulty to keep secure. The intent of this article is to list the steps that an administrator can take to properly secure a MySQL installation on Windows. While the procedures listed are written for Windows users, the principles contained herein will be of benefit to users of Linux and Unix as well.
Hillyer, Mike. MySQL (2005). Design>Information Design>Security>SQL
#27057
A function is a special type of command word in the SQL99 command set. In effect, functions are one-word commands that return a single value. The value of a function can be determined by input parameters, as with a function that averages a list of database values. But many functions do not use any type of input parameter.
Kline, Kevin and Daniel Kline. O'Reilly and Associates (2001). Articles>Information Design>Databases>SQL
#30648
Review: SQL Server Integration Services Using Visual Studio
Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides you with the basic knowledge that you should have before you move on to more advanced ETL [Extraction, Transformation, and Loading]. The book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. This guide provides the building blocks describing each block by way of an example as well as describing the nuts and bolts that bind the blocks. A majority of SSIS tasks are covered in this book and they are described fully in the summary of table contents section. You start building packages right from Chapter 2 and continue on to Chapter 20 gathering and building upon your knowledge in each step.
Krishnaswamy, Jayaram. Packt (2007). Articles>Reviews>Databases>SQL
#27058
Even if the vast number of end users leads to high calculation loads outside the database, you can generally throw hardware at the application load (the load outside the database, that is), hanging as many application servers as necessary off the single central database.
Tow, Dan. O'Reilly and Associates (2001). Articles>Information Design>Databases>SQL
#22404
Synchronize MySQL Data Using SQLyog Job Agent
As MySQL developers, we are often required to keep two databases in complete sync with one another.
Chand, Karam. SitePoint (2004). Design>Information Design>Databases>SQL
#21221
Protect your data from crashes and the confusion of multiple user requests with a transaction-capable database.
Greenspan, Jay. Webmonkey (2002). Design>Web Design>Databases>SQL
#29299
VB.NET Application with SQL Anywhere 10 Database
This article by Jayaram Krishnswamy shows how you can develop a VB.NET 2.0 application using the integration features provided by the SQL Anywhere database. The SQL Anywhere tools are directly accessible without going out of the Visual Studio 2.O IDE. The article describes a window application with two examples developed with this easy to use integration interface.
Krishnaswamy, Jayaram. Packt (2007). Articles>Information Design>Databases>SQL
#25341
An online resource for people developing database-driven web applications using Visual Basic and MySQL.
Hillyer, Mike. VBMySQL.com (2005). Articles>Web Design>Databases>SQL
#30681
Web Enabling Data on a SQL Anywhere Server using a Native Web Service
Exposing server data to intranet/internet, an attractive and much needed method has become possible due to the native web services, services that can be created on the database itself to which HTTP or Soap requests can be made. SQL Anywhere server, even in version 9.0 [present version SQL Anywhere 10] possessed this built-in capability of being able to expose data on the database server to HTTP requests.
Krishnaswamy, Jayaram. Code Project, The (2008). Articles>Documentation>Databases>SQL
#30115
Working With External Data Sources in FileMaker Pro 9
FileMaker 9 opens up ODBC data in a revolutionary way, via the new feature External SQL Data Source. You can work with external data in your FileMaker Pro solutions as if it is FileMaker Pro data.
Stars, Jonathan. FileMaker Advisor (2007). Articles>Information Design>Databases>SQL
#32535
How They Hack Your Website: Overview of Common Techniques
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
#34151
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
