Having a unique identifier (UID) to identify a customer across multiple databases is an important—and frequently overlooked—concept. In the traditional world of direct marketing, a combination of name and address, and sometimes telephone number, is normally used to uniquely identify each customer. But because of the likelihood of misspelling names and transposing numbers, this approach […]
Information Process
A merchant site that accepts electronic payments must include the following processing functions: (1) promotion; (2) welcoming; (3) payment; and (4) back-office.
Promotion
Successful implementation of a merchant site depends on a variety of factors, including site promotion. This can be done through fliers sent to the client or through fidelity programs. The promotion server can […]
The arguments in favor of the Internet sound, at a decade interval, like an echo of those that were previously formulated in praise of the Minitel. This passion for information technology is displayed in a context where ambitious growth rates are not physically sustainable, due to market saturation in rich countries, the progressive depletion of […]
The proliferation of incompatible payment systems creates difficulties for all concerned — users, service suppliers, financial institutions, and regulatory bodies. History has shown repeatedly that the expansion of commerce requires a stable and uniform environment. Yet, in a single aspect of electronic commerce such as electronic purses, there are more than 20 commercialized schemes in […]
The automation and dematerialization of monetary exchanges are not objectives per se, but are solely means to improve the productivity of financial institutions. In this regard, an overabundance of standards, and sometimes their competition, may constitute a barrier to the establishment of electronic commerce. Even if some manufacturers think they can profit from this situation, […]
The modern monetary system freed itself of material support by replacing it with a generalized system of trust based on continuous growth. In the past, monetary creation was absolutely limited by the scarcity of materials to be exchanged or of precious metals for minting coins. Now, however, money liberated from a material basis, in particular […]
ecommerce, hosting, domain registration, electronics, digital, appliance
Throughout the history of the United States, one of the greatest political tensions has been that which balances personal privacy against the need for law enforcement to protect individuals and the country as a whole.
That tension has been with us from the very earliest days of the Republic. The Founding Fathers were extremely cognizant of […]
Creating a New User to Establish a Connection
Because this is a brand-new Web site, we do not have any users who can access our site. Remember when we created the SQLSpyNetUser?
Now we need to create a new user who has only limited rights. We don’t want anybody hacking the site, now do we?
Create a user […]
In this section we will build a very basic front end that makes a connection to our database, validates a user’s login, and retrieves (searches for) data. Although this is just a start, it will provide the building blocks you need to develop it further for your own needs.
This unlike the others, is more like […]
Shrinking a transaction log is a little different from shrinking a data file. The main difference is when the process occurs.
When a data file is shrunk, the task is performed almost immediately, whereas with a transaction log it is not. The log file is marked, so SQL Server 2000 knows that it needs to be […]
It gives me a chance to rave about some of the cool new functionality in SQL Server 2000. Plus, I can show you some of the things that are not totally relevant to our application but that you definitely will want to know as you continue developing and maintaining SQL Server.
Although the enhancements to the […]
sql server, server, database, web hosting, domain, software, computer
User-defined functions (UDFs) rock! UDFs allow us to create compliant units of Transact-SQL that can return either a scalar value or a table.
A scalar value returns a single value (as our UDF did) of the type we specify in the CREATE FUNCTION statement.
A table returns a table of results. It leverages the new data type […]
SQL Server 2000 introduces the Copy Database Wizard and an enhanced version of the Index Tuning Wizard. Let’s take a look at both of these wizards, starting with the Index Tuning Wizard.
Tuning Indexes
The Index Tuning Wizard will assess your workload and give you suggestions for creating optimal indexes and statistics for your databases. The wizard […]
The instance name must follow some rules, and these are listed here. These rules are from the SQL Server Setup Help provided with the CD for installation.
An instance name is not case sensitive.
An instance name cannot be the terms Default or MSSQLServer.
Instance names are limited to 16 characters.
The first character in the instance name must […]
Server, web hosting, domain, fonts, template, php
To finish the development of our Spy Net application, we must install a Web server of some sort onto our machines. We must set up our machine as a Web server so that we can leverage the deployment of the interface. The installation of Personal Web Server (PWS) for Windows 98 is covered in this […]
One of the main concerns of network administrators in the 1980s was that any person in the company network could easily install a modem in her computer and connect to computers outside the network. For digital telephone systems, this was not a problem. But for small businesses using an analog telephone system, this could present […]